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 |
|
vaidyanathanpc
Starting Member
24 Posts |
 Posted - 2002-08-07 : 02:16:47
|
| Hello, I have configured linked server on my SQL server (server1) to access data from a remote SQL server(server2). Both are SQL Server 2000. The linked server was setup without errors. I have checked the privileges on the objects being accessed and everything is fine.. Now when I try to access data from a table (table2 on database db2) in server2 such asselect * from server2.db2.dbo.table2I get the following error..OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any information about the error.What could be the problem?Thanks in advanceP.C. Vaidyanathan |
|
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
Posted - 2002-08-11 : 21:26:34
|
| Had you mapped the logins between the two servers?May you see the tables in the Enterprise Manager?BEST REGARDS |
 |
|
|
|
|
|
OLEDB error when accessing data thru linked server