something strange in Navision web services
gorvega79
Member Posts: 73
Hi all
we have a three tier web service, and until last week has worked perfectly. Our problem is that sometimes gives an error like this,and all is stopped:
The login failed when connecting to SQL Server
but when i refresh the explorer with the url of web service in the host where navision services are installed,everything returns to work perfectly. i don´t know why and in the forum can´t find anything about this. i have downloaded the "Microsof dynamics nav 2009 best practices analyzer" and show us that all works perfectly. if you know something about or any idea, tell me please...thanks
we have a three tier web service, and until last week has worked perfectly. Our problem is that sometimes gives an error like this,and all is stopped:
The login failed when connecting to SQL Server
but when i refresh the explorer with the url of web service in the host where navision services are installed,everything returns to work perfectly. i don´t know why and in the forum can´t find anything about this. i have downloaded the "Microsof dynamics nav 2009 best practices analyzer" and show us that all works perfectly. if you know something about or any idea, tell me please...thanks
0
Answers
-
Sounds to me you have multiple Active directory, and replication is setup between the two which overwrites your SPN. When you reset them SQL caches the Kerberoes tickets for 24 hours and then it gets deleted, and you back at at step 0.0
-
-
hi ara3n
Again give us the same error and we have solved the same way by the refresh the explorer where navision web services are intalled. but now all everything has stopped working.
Any idea.0 -
Any error logs in the client station or server?
Something from Kerberos?
Are u using Domain Accounts for your services?0 -
thank you for your reply Dan77
finally in the "customsetting.config" file of the service i change so many parameters to MaxValue and other things.everything come to work perfectly. This is my "customsetting.config" file with new changes:
parameters:
- "WebServicesMaxMsgSize" value="1024"
- "OperationTimeout" value="MaxValue"
- "ProtectionLevel" value="None"
- "MaxConcurrentCalls" value="MaxValue"
- "MaxConcurrentConnections" value="MaxValue"
- "ClientReconnectPeriod" value="MaxValue"
- "EnableDebugging" value="true"<?xml version="1.0" encoding="UTF-8"?> <appSettings> <!-- The network protocol used to access the database. Valid options: Default, NamedPipes, Sockets --> <add key="NetType" value="Default"></add> <!-- Name of the database server to connect to. --> <add key="DatabaseServer" value="DOMAIN\SERVER"></add> <!-- Name of the database instance to connect to. --> <add key="DatabaseInstance" value=""></add> <!-- Name of the database to connect to. --> <add key="DatabaseName" value="DBNAME"></add> <!-- Name of the Microsoft Dynamics NAV Server instance to connect to (for client) or listen on (for server). --> <add key="ServerInstance" value="SRINSTANCE"></add> <!-- The listening TCP port for the Microsoft Dynamics NAV Server. This is part of the server's URL. Valid range: 1-65535 --> <add key="ServerPort" value="7050"></add> <!-- The listening HTTP port for the Microsoft Dynamics NAV Business Web Services. This is part of the web service's URL. Valid range: 1-65535 --> <add key="WebServicePort" value="7047"></add> <!-- Turns on or off the https for Web Services --> <add key="WebServiceSSLEnabled" value="false"></add> <!-- Maximum permitted size of a Web Services request, in kilobytes --> <add key="WebServicesMaxMsgSize" value="1024"></add> <!-- Turns on or off NTLM authentication protocol for Web Services false: Use SPNEGO (recommended) true: Use NTLM only --> <add key="WebServicesUseNTLMAuthentication" value="true"></add> <!-- Maximum time in seconds a call from the client to the server may take to return. Time span format: [dd.]hh:mm:ss[.ff] dd: days hh: hours mm: minutes ss: seconds ff: fractions of a second Or "MaxValue" to indicate there is no timeout. --> <add key="OperationTimeout" value="MaxValue"></add> <!-- The security services used to protect the client/server data stream. Valid options: EncryptAndSign, Sign, None --> <add key="ProtectionLevel" value="None"></add> <!-- Maximum number of concurrent client calls that can be active on the Microsoft Dynamics NAV Server. To disable this setting set the value to "MaxValue". --> <add key="MaxConcurrentCalls" value="MaxValue"></add> <!-- The maximum number of concurrent client connection that the service will accept. To disable this setting set the value to "MaxValue". --> <add key="MaxConcurrentConnections" value="MaxValue"></add> <!-- Sets the grace period within which the client can reconnect to a running session. Time span format: [dd.]hh:mm:ss[.ff] dd: days hh: hours mm: minutes ss: seconds ff: fractions of a second Or "MaxValue" to indicate there is no timeout. --> <add key="ClientReconnectPeriod" value="MaxValue"></add> <!-- Sets the maximum number of orphaned connections to be kept alive simultaneouly for a maximum time specified by the ClientReconnectPeriod setting. A connection becomes an orphan when the client becomes involuntarily disconnected from the server. --> <add key="MaxNumberOfOrphanedConnections" value="20"></add> <!-- Threshold for when to start compressing data sets to avoid that they consume prohibitive amounts of memory. --> <add key="CompressionThreshold" value="64"></add> <!-- Sets the Metadata Provider cache size (in number in objects cached). Set to 0 to disable cache. --> <add key="MetadataProviderCacheSize" value="150"></add> <!-- Limits the size of files that can be uploaded in order to avoid out of memory errors. This value is in megabytes. --> <add key="MaxUploadSize" value="5"></add> <!-- With the EnableDebugging flag set to true the Microsoft Dynamics NAV Server will start with debugging mode enabled. This mode has three main functions: 1) Upon first connection by a RoleTailored Client all C# for that application will be generated. 2) C# files will be persisted between server restarts. 3) Application Objects will be compiled with debug information. --> <add key="EnableDebugging" value="true"></add> <!-- Sets the maximum number of items to serialize or deserialize, in KB --> <add key="MaxItemsInObjectGraph" value="128"></add> <!-- Sets the default size of a chunk, in KB. Should be a value between 4 and 80. --> <add key="ChunkSize" value="28"></add> </appSettings>
regards0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions