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 |
|
Soumen Dey
Starting Member
20 Posts |
 Posted - 2004-11-25 : 03:07:31
|
| Hi,I have a machine A and a machine B. I want to access the data in Machine B from Machine A via Linked Server. Bothe the databases are in SQL Server. I've created the linked server using sp_addlinkedserver but when I'm querying the linked server using open query it is showing the message that SQL server is not registered or access denied. Though I could see he sysservers table in Machine A which actually has the the linkserver registered.I'm new to sql server pl helpSoumen |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2004-11-25 : 06:25:38
|
| Look at sp_addlinkedsrvlogin to create login credentials for the remote user. If you look it up in BOL you'll find examples of how to set up the link./Andraax |
 |
|
|
|
|
|
configuring linked server