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 |
|
mamzy
Starting Member
4 Posts |
 Posted - 2005-03-20 : 00:23:27
|
| I am traying to configure a linked server on a cluster server A with (window 2000 SP4 & sql 2000 ) to link to a DB1 on a non cluster server B with (Windows 2003 & sql 2000), i have created an sql user user1 on server B having access to DB1 ,then created the link on server A using enterprise manager (EM),the linke server is created on server A but when double clicking on tables or views i am getting the following error:ERROR 18452: login failed for 'user1'.Reason:Not associated with trusted SQL server connection.help is very much appreciated!!!! |
|
|
mamzy
Starting Member
4 Posts |
Posted - 2005-03-21 : 00:58:15
|
| hi everybodyit's mamzy again, it seems that my post on linked server is difficult , please reply because i have searched a lot for sulotionthanks |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-21 : 02:00:57
|
| are you using windows authentication or SQL Server authentication?-ec |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-03-21 : 02:08:20
|
| On the security tab of the linked server properties,you have to map your local login to a login on the linked server.How did You set that up ?rockmoose |
|
|
|
mamzy
Starting Member
4 Posts |
Posted - 2005-03-21 : 23:55:01
|
quote:
Originally posted by eyechart
are you using windows authentication or SQL Server authentication?Both servers(A & B) are using Mixed Mode for authentication, and the user1 on the linked server (security tab) is using SQL userid and password , i have tried mapping local user to remote user and i stil get the same errorbest regardsmamzy-ec
|
|
|
|
|
|
|
Linked Server