Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked Server not working with schema

Status
Not open for further replies.

erikkl2000

Programmer
Jan 19, 2006
10
US
I have a linked server to my remote hosting company and when query tables that are in the dbo. schemas i get the expected results. However, when i query with one of my schemas (Person.Table.Column) i get a permission error.

==========================================================
--Error--
Msg 7314, Level 16, State 1, Line 7
The OLE DB provider "SQLNCLI" for linked server "DISCOUNTASP" does not contain the table ""SQL2005_xxxxxxx_xxxxxxx"."Person"."utbAlbums"". The table either does not exist or the current user does not have permissions on that table.


===========================================================


---I have also do this-------------------

GRANT SELECT ON SCHEMA :: Person
TO
[SQL2005_123456_userName_user]


==========================================================

I still get the error



Anyone have any suggestion?

erik
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top