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.
| Author |
Topic |
|
MBeal
Posting Yak Master
110 Posts |
 Posted - 2002-10-16 : 16:01:20
|
| I am trying to run a query that will link two databases from two different servers. I can run each individual part of the query on each of the servers individually, but when I put it as part of a join and call on the other server I get the following message:Login failed for user 'user name here'. Reason: Not associated with a trusted SQL Server connection.The original DBO no longer is employed with our company. Do I need to change the DBO? Any suggestions?MBeal |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-10-16 : 17:10:40
|
| Have you tried mapping logins from your local server to the logins on the remote server using sp_addlinkedsrvlogin? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-10-16 : 18:15:38
|
| Are you using windows authentication? If you are, then...For some reason, you can not use windows authentication when using linked servers. I don't know why, but this is the case. You will need to use sql authentication. If someone knows how to use windows authentication with linked servers, please let us know because I can never get it to work. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-16 : 18:40:21
|
| If you read Books Online for the entry that Ilya mentioned (sp_addlinkedsrvlogin) it describes how to do that (the @useself parameter). However, the logins used on the local server must also exist and be trusted on the remote server. If not, then you need to create mappings. |
|
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2002-10-18 : 11:28:43
|
| Probably good to change the DBO to sa or another generic account so that you don't have to rotate the ownere around evertime someone leaves. Good practice. |
|
|
|
|
|
|
Not associated with a trusted SQL Server