Re: Linked Server Connection Error: 18459

I cannot execute the sqlcmd query against the linked server from sqlServer A to sqlServer B but I can run the linked server query from B to A.
From A to B I get the following error (which we have seen before):
sqlcmd -d tempdb -q "select top 10 identifier from server.database.dbo.identifier"
Msg 18456, Level 14, State 1, Server WSV3DB03, Line 1
Login failed for user xxxxx\yyyyy.

Ping from A to B is successful and quick.
Telnet from A to B on port 1433 is successful.
The Profiler trace shows that the request actually makes it to Server B but is denied. (Event Class: Audit Login Failed, EventSubClass: 1 - Nonpooled, Error 18456, DatabaseName: master)

I do notice that the login is trying to connect to the master database via the linked server connection however this login is actually defauted to another user database. This should not make a difference as far as the login (access denied) error goes however since this "user/login" is sysadmin and is mapped to the master database and the user databases. I only get this error when trying to connect via linked server from A to B.

.

Relevant Pages

  • Re: Setting up Linked server to MsAccess
    ... This will set the security so anyone using the linked server ... At the database level I have added my Server login ...
    (microsoft.public.sqlserver.security)
  • Data Objects for Win and Web
    ... We have a set of objects that use a DAL to connect to SQLServer. ... database they will be using is selected during login. ... Phenix ...
    (microsoft.public.dotnet.languages.csharp)
  • Linked Server Security
    ... I'm having problems querying a linked server. ... "SELECT permission was denied on the object all_columns, database ... I get the same "Login failed" error message. ...
    (microsoft.public.sqlserver.security)
  • error conection frm clients to the sqlserver
    ... computer with ' MIS' name.the type of SQLserver installation is mixed mode ... network clients without login to the SQlserver besuse the sqlserver is mixed ... sqlserver database without login to SQLserver computer. ...
    (microsoft.public.sqlserver.connect)
  • Access permissions on tables for current user
    ... I want to find out the access permissions available to the user associated ... with the current login for each database in sqlserver. ... granted to or by the current user in the current database. ...
    (microsoft.public.sqlserver.security)