Linking Severs to Run Queries in Query Anlyzer

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 Development (2000)

Linking Severs to Run Queries in Query Anlyzer

Author

Topic

sgrahman
Starting Member

10 Posts

Posted - 2005-05-05 : 11:29:48

Hi,
I do not have Enterprise Manager in my PC but I am using Query Analyzer to Run the following select statements:

select s.id, s.lname, s.fname, d.score
from [bell.sp.com].customer.dbo.employee
join [fruit.sp.com].test.dbo.testscore d
on s.id=d.id
where s.id in (2378, 3606, 5415, 5366)

Error Message: Could not find server 'bell.sp.com' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

I have never run queries between the servers. So I was not exactly sure what do I have to do first in order to run this query. After running the query above, I get the above error message.

So, I executed the following to add the server to sysservers:

Execute sp_addlinkedserver
[bell.sp.com]

Error Message: User does not have permission to perform this action.

Still it did not work out, Could someone tell me where exactly am I making mistake. Thanks for you suggestions.

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2005-05-05 : 11:33:08

>>User does not have permission to perform this action.

Does this not make sense?

- Jeff

sgrahman
Starting Member

10 Posts

Posted - 2005-05-05 : 11:37:04

which part of this does not make sense? Please be more specific.

sgrahman
Starting Member

10 Posts

Posted - 2005-05-05 : 11:39:21

i understood user doe not have permission to perform this action..but my DBA says it should work with the statements i provided...could you please elabrote what kind of permission do I need to run this?

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2005-05-05 : 12:05:16

This is copied and pasted directly from Books On-Line:

quote:

sp_addlinkedserver

...

Permissions
Execute permissions default to members of the sysadmin and setupadmin fixed server roles.

Your DBA should really know this, and he or she should be the one setting up linked servers for you.

- Jeff

sgrahman
Starting Member

10 Posts

Posted - 2005-05-08 : 16:37:19

I thought so too. Thanks for the reference to the BOL.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources