ERROR with OPENDUERY

[koteswararao]

I have given the fallwoing Query
INSERT INTO DATA
(EmployeeKey,[Title])


OPENQUERY([Adventure Works DW],'Select ([EmployeeKey],[Title]
FROM DimEmployee')

I got the error like this:

Either the 'BOSE\subhash' user does not have permission to access the
'Adventure Works DW' object, or the object does not exist.
Execution complete

How to solve this problem.

Thank in advance

url:http://www.ureader.com/gp/1144-1.aspx

[Russell Fields]

Your error message gives you two possible choices for what is wrong:

1. 'BOSE\subhash' user has no permissions to 'Adventure Works DW'

Check the security settings for the linked server. It might be restricted to
only allowing a fixed set of logins to use the linked server. Use the
following commands to check.

sp_serveroption
sp_helplinkedsrvlogin
Also read: http://msdn2.microsoft.com/en-us/library/ms175537.aspx


2. 'Adventure Works DW' does not exist.

Double check the spelling, etc. to make sure you are using a valid linked
server name.

RLF

Post by koteswararao
I have given the fallwoing Query
INSERT INTO DATA
(EmployeeKey,[Title])
OPENQUERY([Adventure Works DW],'Select ([EmployeeKey],[Title]
FROM DimEmployee')
Either the 'BOSE\subhash' user does not have permission to access the
'Adventure Works DW' object, or the object does not exist.
Execution complete
How to solve this problem.
Thank in advance
url:http://www.ureader.com/gp/1144-1.aspx