Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
SQL account different to NAV service account (NAV2009 R2)
seff_yohanson
Member Posts: 23
Hi all,
I am familiar with the 3 tiers on 3 computers document which I have followed and setup other servers in the past, however, I am having problems which I suspect are down to having a different user running SQL and the NAV middle-tier. Both are Domain accounts.
When I launch the RTC I get the error "Login Failed when connecting to SQL Server" and in the event log
"Microsoft.Dynamics.Nav.Types.NavDatabasePasswordException"
In the SQL Error Log I get "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors."
Can anyone help?
Thanks
I am familiar with the 3 tiers on 3 computers document which I have followed and setup other servers in the past, however, I am having problems which I suspect are down to having a different user running SQL and the NAV middle-tier. Both are Domain accounts.
When I launch the RTC I get the error "Login Failed when connecting to SQL Server" and in the event log
"Microsoft.Dynamics.Nav.Types.NavDatabasePasswordException"
In the SQL Error Log I get "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors."
Can anyone help?
Thanks
0
Comments
HTTP/Server.Sub.Domain.com
HTTP/Server
DynamicsNAV/Server.Sub.Domain.com:7046
MSSQLSvc/Server.Sub.Domain.com:1433
setspn -A InstanceName/FullyQualifiedDomainNameOfServer:Port Domain\User
setspn -A DynamicsNAV/NAVSERV.yourDomain.yourCompany.com:7046 yourDomain\yourUser
Replace "yourDomain," "yourCompany," and "yourUser" with the appropriate values.
Create an SPN for the SQL Server service. This service runs on the NAVSQL computer with a default instance name of MSSQLSvc. Type the following command:
setspn -A MSSQLSvc/NAVSQL.yourDomain.yourCompany.com:1433 yourDomain\yourUser
After doing this if still you are getting error then use following steps:
1. remove all the spn's.
2. run command prompt with administrator.
3. run following commands
setspn -A InstanceName/FullyQualifiedDomainNameOfServer Domain\User
setspn -A DynamicsNAV/NAVSERV.yourDomain.yourCompany.com yourDomain\yourUser
Replace "yourDomain," "yourCompany," and "yourUser" with the appropriate values.
setspn -A MSSQLSvc/NAVSQL.yourDomain.yourCompany.com:1433 yourDomain\yourUser