Linked servers -- sql server clustering

dotNet
6/28/2004 7:44:16 PM

Hi!

I have a problem with linking two servers.

I have created a login called "linked" and set full permissions to the
pubs-database on booth servers.

When I first create the linked server and linked server login on server1
everything goes fine. And I can connect to server2:s pubs-database.
But when I do the same thing on server2 and want to connect server1 it gives
me this error:
Server: Msg 18452, Level 14, State 1, Line 1
Login failed for user 'linked'. Reason: Not associated with a trusted SQL
Server connection.

I have logged in with linked/password to QA and trying to execute:

select * from server1.pubs.dbo.authors

Booth servers have Authentication under the security tab set to "SQL Server
and Windows".

Any suggestions?

Joe Belson
6/29/2004 11:33:51 AM

Hi dotNet,

Try executing the following T-SQL:

sp_addlinkesrvlogin 'Server1', false,
NULL, 'srv1Login', 'Password'

Replace srvLogin and Password with the login and password
of the SQL Standard login & password you want to use on
the target server.

The SP will map ALL users that do not have an explicit
mapping to use the provided login/pwd when connecting to
the target server. You can use
sp_helplinkedsrvlogin 'Server1' to view all "Server1"
linked server logins.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clustering

sql server clustering : Linked servers