Here is the error:
[ProvideX][ODBC Driver][FILEIO]Table is not accessible
I get this when I run a view or stored proc using:
SELECT * FROM OPENQUERY(MAS90_1, 'SELECT * FROM AR_Salesperson')
MAS90_1 is the linked server. I think my problem has to do with the login info. We have 2 servers... our MAS90 DB is located on "MAS90_srv" and our SQL Server 2005 is on "Utility". If I login to "Utility" using "DOMAIN\user1" would I need to allow access to "MAS90_srv" for "DOMAIN\user1" AND what would the sp_addlinkedsrvlogin command look like...
[ProvideX][ODBC Driver][FILEIO]Table is not accessible
I get this when I run a view or stored proc using:
SELECT * FROM OPENQUERY(MAS90_1, 'SELECT * FROM AR_Salesperson')
MAS90_1 is the linked server. I think my problem has to do with the login info. We have 2 servers... our MAS90 DB is located on "MAS90_srv" and our SQL Server 2005 is on "Utility". If I login to "Utility" using "DOMAIN\user1" would I need to allow access to "MAS90_srv" for "DOMAIN\user1" AND what would the sp_addlinkedsrvlogin command look like...