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 |
|
waskelton4
Starting Member
12 Posts |
 Posted - 2006-05-10 : 14:22:11
|
| Hey group..I'm trying to setup a linked server on my departments sql 2000 server that I have full control of.The server I'd like to add as a linked server is in a different department and I only have a user account using the datareader role. They are about to upgrade that server also and don't want to grant any additional access to it at the moment.I have registered the remote server and can browse it using Enterprise Manager.I am able to add it as a linked server but when I try and browse the tables and/or views I am unable. I have tried to query it using OPENROWSET as well as OPENQUERY but with no success.My question is.. can I use this datareader account to link to this server or does it need additional access?I was under the impression before that "sp_addlinkedsrvlogin" needed to be run on the remote server but i'm not so sure about that anymore.Any help is greatly apprecitated!ThankswillBAD SPELLERS OF THE WORLD UNTIE!! |
|
|
waskelton4
Starting Member
12 Posts |
Posted - 2006-05-11 : 10:19:04
|
| It appears that the server i want to link is allowing remote access via RPC.could it be a sql 2000 server version issue.both servers are running SQL Server 2000 Standard and are patched with sp3any thoughts at all?thanks!WillBAD SPELLERS OF THE WORLD UNTIE!! |
 |
|
|
waskelton4
Starting Member
12 Posts |
Posted - 2006-05-11 : 11:47:48
|
| Ok..Turns out that the problem wasn't with anything above..For some reason just using the server name wasn't enough. Using the IP Address or a fully qualified DNS name works..ThankswsBAD SPELLERS OF THE WORLD UNTIE!! |
|
|
|
|
|
|
[SOLVED] linked server rights question..