September 9, 2009 at 11:46 pm
First let me say that I am aware of the issues that occur in my situation and the need to create an SPN for the server, however the usual procedure does not seem to work. I have searched around and everything I have found does not seem to relate to this particular issue, and I have been trying unsuccessfully to figure out what is going on.
The Setup:
sql server: db1.domain.local - sql 2005 - ip: 10.10.10.51
dns A record: sql.domain.local - points to 10.10.10.51
mixed authentication on sql server
sql running as a domain account
sql is a named instance: db1.domain.local\orange
The Issue:
- When launching SSMS locally on the sql server, we are able to connect to db1.domain.local\orange using both windows and sql authentication
- When launching SSMS locally on the sql server, we are able to connect to sql.domain.local\orage using sql authentication only
- When launching SSMS from a different machine, we are able to connect to db1.domain.local\orange using both windows and sql auth
- When launching SSMS from a different machine, we are able to connect to sql.domain.local\orange using both windows and sql authentication
The question is, why is there a problem with windows authentication with the dns pointer only when we are connecting locally. I have tried using setspn to add a reference to MSSQLSvc/sql.domain.local:instanceport but when I try that I get an SSPI handshake error.
Note: The user I am connecting to the server as is a domain administrator and is part of the sysadmin role on the server. As I mentioned, this user connects fine through remote SSMS but not locally
The exact error message I get when trying to login locally using windows authentication is "Login failed for user ''. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)"
Any help would be greatly appreciated...
October 20, 2009 at 9:41 am
*bump* Anyone have any ideas here?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply