No SPNs have been configured on SQL Server account error

josephdewey
Member Posts: 87
Web Services works on the middle tier, but doesn't work anywhere else. I've followed all of the instructions on http://msdn.microsoft.com/en-us/library/dd301254.aspx , so I need help on what I can look at next.
I have the Role Tailored Client connected, and it's working well. I'm now trying to get Web Services to work somewhere besides just the middle tier. I'm using a three-tiered environment.
I'm getting a "The request failed with HTTP status 401: Unauthorized" error when using some web services, or on my third tier, where the RTC works, then it asks me to log in, instead of passing my credentials through, and then errors no matter what credentials I enter. When it works on the middle tier, it doesn't ask me to enter credentials, so I think that's what it's supposed to do.
I'm running the Best Practices Analyzer, and it gives me the following error:
I'm really not sure what to test or try next. If anybody has any ideas, that would be awesome. Thanks!
I have the Role Tailored Client connected, and it's working well. I'm now trying to get Web Services to work somewhere besides just the middle tier. I'm using a three-tiered environment.
I'm getting a "The request failed with HTTP status 401: Unauthorized" error when using some web services, or on my third tier, where the RTC works, then it asks me to log in, instead of passing my credentials through, and then errors no matter what credentials I enter. When it works on the middle tier, it doesn't ask me to enter credentials, so I think that's what it's supposed to do.
I'm running the Best Practices Analyzer, and it gives me the following error:
However, I have the following SPNs set up already:No SPNs have been configured 'MSSQLSvc/NAVTEST' on SQL Server account 'corp\rtcuser'.
U:\>setspn -Q DynamicsNAV/* Checking domain DC=corp,DC=company,DC=com CN=RTCUSER,OU=Misc.,OU=USA,OU=Global,DC=corp,DC=company,DC=com MSSQLSvc/NAVTEST:1433 MSSQLSvc/NAVTEST.corp.company.com:1433I set these up by using the following commands to set up my SPNs:
setspn -A MSSQLSvc/NAVTEST.corp.company.com:1433 corp\rtcuser setspn -A MSSQLSvc/NAVTEST:1433 corp\rtcuser"navtest" is the machine with SQL Server on it. "corp\rtcuser" is the user I'm using for the services. And, the real company isn't really company.com due to clever editing on my part.
I'm really not sure what to test or try next. If anybody has any ideas, that would be awesome. Thanks!
Joseph Dewey
Microsoft Dynamics NAV User
Microsoft Dynamics NAV User
0
Comments
-
I still have my big problem, but I found the solution to the error of: No SPNs have been configured 'MSSQLSvc/NAVTEST' on SQL Server account 'corp\rtcuser,' when they already existed.
It was to delete the existing SPNs and then recreate them in reverse order:setspn -D MSSQLSvc/NAVTEST.corp.company.com:1433 corp\RTCUSER setspn -D MSSQLSvc/NAVTEST:1433 corp\RTCUSER setspn -A MSSQLSvc/NAVTEST:1433 corp\RTCUSER setspn -A MSSQLSvc/NAVTEST.corp.company.com:1433 corp\RTCUSER
So, I think that's actually probably a bug in the Best Practices Analyzer, and it wasn't actually a real problem.
But, I still can't connect anywhere outside of the middle tier. Now the Best Practices Analyzer shows everything to be perfect, but I'm still getting the 401 errors when trying to connect from another machine besides the middle tier machine.
Thanks in advance for any help!Joseph Dewey
Microsoft Dynamics NAV User0
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