Linked Server error

Hi, All

I have one default SQL Server 2005 "LIANG" and "LIANG\SQLEXPRESS".

After I set up a linked server "LING" in "LIANG\SQLEXPRESS"., I try to run a
query

select * from LIANG.Northwind.dbo.Customers

it gives me the following error:

OLE DB provider "SQLNCLI" for linked server "LIANG" returned message
"Invalid authorization specification".

Msg 7399, Level 16, State 1, Line 1

The OLE DB provider "SQLNCLI" for linked server "LIANG" reported an error.
Authentication failed.

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "SQLNCLI" for
linked server "LIANG".



Please help



Kai

Hi

Have you added a linked server login? Can you connect to the remote server
directly with this login?

John

"kai" wrote:

> Hi, All
>
> I have one default SQL Server 2005 "LIANG" and "LIANG\SQLEXPRESS".
>
> After I set up a linked server "LING" in "LIANG\SQLEXPRESS"., I try to run
 a
> query
>
> select * from LIANG.Northwind.dbo.Customers
>
> it gives me the following error:
>
> OLE DB provider "SQLNCLI" for linked server "LIANG" returned message
> "Invalid authorization specification".
>
> Msg 7399, Level 16, State 1, Line 1
>
> The OLE DB provider "SQLNCLI" for linked server "LIANG" reported an error.
> Authentication failed.
>
> Msg 7303, Level 16, State 1, Line 1
>
> Cannot initialize the data source object of OLE DB provider "SQLNCLI" for
> linked server "LIANG".
>
>
>
> Please help
>
>
>
> Kai
>
>
>