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 |
|
acesover
Starting Member
15 Posts |
 Posted - 2008-11-14 : 17:32:23
|
| I've added a new DB (actually a restore from another instance) onto a SQL instance, but can't access it from a remote client. Using management studio, when I expand the Catalogs folder below the linked server, I don't see my DB. There are 10+ DBs on that server, and only 3 show up in the catalog. I can access the data from those 3 DBs, but none of the others, including my new restore. The error message I get is:Msg 7314, Level 16, State 1, Line 1The OLE DB provider "SQLNCLI" for linked server "sl7-dev" does not contain the table ""test_slappcad"."dbo"."soheader"". The table either does not exist or the current user does not have permissions on that table.Any ideas? Thanks.Dan |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-14 : 21:36:13
|
| Login used in linked server should have permission for other DB. |
 |
|
|
acesover
Starting Member
15 Posts |
Posted - 2008-11-17 : 12:53:48
|
| that was the problem. Thanks. |
|
|
|
|
|
|
Can't see all DBs on linked server