November 16, 2009 at 10:52 am
Hello everyone,
i'm trying to use - in a first time level - linked server in sql2005, connecting a server A (XPTO) to a server B and the console shows the message (both servers in sql2005) and i receive this error message:
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
The OLE DB provider "SQLNCLI" for linked server "XPTO" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "XPTO".
OLE DB provider "SQLNCLI" for linked server "XPTO" returned message "Invalid authorization specification". (Microsoft SQL Server, Error: 7399)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=7399&LinkId=20476
------------------------------
I need some help to configure in a step-by-step the linked server.
Samebody help me, please.
best regards...
November 16, 2009 at 11:03 am
Instead of "OLE DB provider" in the providers try using Sql Native Client.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply