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 |
|
msrnivas
Starting Member
4 Posts |
 Posted - 2004-12-08 : 00:46:39
|
| Hi My working database is sql2000.I have admin previliges on my local server.I created a linked server name 'test' and can execute sqlselect * from test.remotesrv.dbo.salesBut when i try connect to other sql account say "Sales_Access" (which is having only db_datareader and db_datawriter)and execute same above sql its giving error.what previliges to give my Sales_Access accoun.i tried below one but still no useEXEC sp_addlinkedsrvlogin 'test', 'true', 'Sales_Access','sales','sales'thanks |
|
|
|
|
|
Linked Server problem