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 |
|
klegrand
Starting Member
29 Posts |
 Posted - 2005-04-04 : 07:12:14
|
| Hey,I've a problem to create a linked server. When I want to create a linked server and I want to see the data tables, the server gives me the following error --> Error 18452 : Loginfailed for user 'sa'. Reason : Not associated with a trusted SQL server connection.The registration of the server is done with the SQL server login. If I make the same connection but with the Windows account login, then I can create the linked server.What can be the cause of this ?Thanks for the help... |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-04-04 : 07:54:40
|
| In enterprise manager have a look at the linked server properties security tab.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
klegrand
Starting Member
29 Posts |
Posted - 2005-04-04 : 08:27:56
|
| The security tab is refering to the following login --> Be made using this security context. The remote login is a user on the remote server. |
|
|
|
|
|
|
Linked Servers