|
Home > Archive > MS SQL Server > March 2006 > Linked Server error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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
| |
| John Bell 2006-03-31, 3:23 am |
| 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
>
>
>
|
|
|
|
|