ERROR with OPENDUERY

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

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




"koteswararao" <kvaramu2005.TakeThisOut@gmail.com> wrote in message
news:99556434045b4191a97861aee02eb8bd@newspe.com...
>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