Linked Server ISSUE - 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)

Linked Server ISSUE

Author

Topic

thugs
Starting Member

13 Posts

Posted - 2008-06-11 : 11:35:04

I have Two servers
Server-A
WIN2k3 Standard, sp1
SQL server 2000 Standard edition(RTM)
Server- B
Win2k3 ENTERPRISE, SP1
SQl server 2000 Enterprise edition(SP4)

I created a linked server for Server-A IN SERVER-B.
The security i am using is "Be made using this security conest" - I am providing SQL LOGIN and Password here.
While running a Linked server query in Server - B

I am getting an ERROR as follows
Login Failed for user 'MY username' Reason: Not associated with a trsuted SQL Server Connection.

My query: Select * from ServerB.DBNAME.DBO.tablename

I created a linked server FOR Server- B in SERVER - A
I am able to run linked server query here.

Can someone help me out in this.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-11 : 12:52:58

Does that login exist in Server B (Same as Server A)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-11 : 22:47:27

Does server-a allow sql authentication? By the way, should you run 'Select * from Servera.DBNAME.DBO.tablename' in server-b?

thugs
Starting Member

13 Posts

Posted - 2008-06-12 : 02:41:33

Thanks For the replies.

Does that login exist in Server B (Same as Server A) --- I tried this one also but no use.

Does server-a allow sql authentication? By the way, should you run 'Select * from Servera.DBNAME.DBO.tablename' in server-b? -- Both servers are in mixed mode.

While running a QUERY in serverB - my Query 'Select * from ServerA.DBNAME.DBO.tablename' - Its not working its showing the error msg as mentioned above.

While running a QUERY in serverA - My Query 'Select * from ServerB.DBNAME.DBO.tablename' - Its working fine.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-12 : 11:47:06

Does that sql login has permission for that database/tablename in Server A & Server B?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources