Remote Login Failure - 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)

Remote Login Failure

Author

Topic

scelamko
Constraint Violating Yak Guru

309 Posts

Posted - 2005-10-04 : 09:43:46

Guys,

I am trying to query from database on a different server, inorder to do so I ve set up DTC and executed the following
stored procedure.

USE master
GO
EXEC sp_addlinkedserver
'SERVERNAME',
N'SQL Server'
GO

But I get the following error
"
Server: Msg 18456, Level 14, State 1, Line 1
Login failed for user 'sa'.
"

This is strange for me b'cos it worked earlier for me and I never entered sa login credentials for it work.

Any suggestions/inputs would be very helpful

Thanks
Sri

SreenivasBora
Posting Yak Master

164 Posts

Posted - 2005-10-04 : 15:34:39

I hope 'sa' password was modified OR your user has revoked the permissions on Linked server !!!

Check it.

With Regards
BSR

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources