Adding Linked Servers - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Adding Linked Servers

Author

Topic

scelamko
Constraint Violating Yak Guru

309 Posts

Posted - 2005-10-17 : 10:37:02

Guys,
To be able to access remote sql server 2000, I have activated DTC (Distributed Transaction Coordinator) on the server hosting sql server 2000

Then I ran the following script to add the server

EXEC sp_addlinkedserver
'PROTOSRV\TYPE',
N'SQL Server'

then I tried to access data on this server by running the following query

select * from [PROTOSRV\TYPE],[DBNAME].[dbo].[employee]

I get the following error

"
Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'sa'.
"

I have tried to look up in help but it does not have any clear fix for this.

Any suggestions/inputs would help

Thanks

sachinsamuel
Constraint Violating Yak Guru

383 Posts

Posted - 2005-10-17 : 10:54:13

Please check the authentication details supplied while adding Linked server. I doubt that is incorrect.

Regards
Sachin Samuel

Priya Rajagopalan
Starting Member

10 Posts

Posted - 2005-10-19 : 05:35:47

Have you added the remote server login id & password. Pls check it & add it.

syntax : exec sp_addlinkedsrvlogin '<linked servername>',false,null,'sa','password'

Regards
Priya

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources