Login Fail fail for user '' - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Author

Topic

DLTaylor
Posting Yak Master

136 Posts

Posted - 2011-02-28 : 06:37:09

When I connect to an Instance of SQL 2005 under the user name; domain\ok_user

I get 2 different reasons for failed logon;

The 1st server (SERVER1) I see the message; Login failed for user ‘domain\ok_user’
(I would expect this as I haven’t set-up access!)

The 2nd server (SERVER2) is see the message; Login failed for user ‘’. The user is not associated with a trusted connection
Now I have setup user; ‘domain\ok_user’ to have access to SERVER2

I have been tinkering for a while & simply cant work out why I cant connect to SERVER2 with ‘domain\ok_user’.

Does my error message; Login failed for user ‘’ provide a clue?
Why doesn’t it say… Login failed for user ‘domain\ok_user’…. if the user isn’t trusted?

I am clutching at straws but does the error message give anyone any clues that can help me?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-02-28 : 13:56:03

How are you logging in to 2nd server? Is it a linked server from the 1st?

DLTaylor
Posting Yak Master

136 Posts

Posted - 2011-03-01 : 04:26:10

Thanks for your reply, interesting you say that.

I log on the actual servers

Yes SERVER1 is set-to to be linked to SERVER2

Could this cause the; Login failed for user ‘’. error message?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-03-01 : 10:40:07

Are you using a domain account for SQL Services?

SPN is registered for SQL Service?

Account is trusted for delegation in AD?

http://technet.microsoft.com/en-us/library/cc773257(WS.10).aspx

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2011-03-01 : 16:18:42

If you are accessing server2 through a linked server from server1, and getting the login failed for user '' as the error - it is because of how you have the linked server configured.

In order for you to be able to pass windows authentication through the linked server, you need to enable Kerberos authentication. This will require valid SPN records, a domain user running SQL Server and the domain user account trusted for delegation.

To work around that, you have to setup SQL Authenticated users and map to those users or set the linked server authentication to a single generic login with the appropriate rights.

Jeff

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources