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
>
>