May 31, 2011 at 8:45 am
I have a domain id: company\abc, this account is a dedicated account for fetching data from another server where privilege has been set up.
From my own server, I need to add this dedicated account to link remote server.
I am trying to add it but failed unofrtuntely for the following error message, how do I fix it? thank you very much.
TITLE: Microsoft SQL Server Management Studio
------------------------------
"The linked server has been created but failed a connection test. Do you want to keep the linked server?"
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Named Pipes Provider: Could not open a connection to SQL Server [2].
OLE DB provider "SQLNCLI" for linked server "HRFEED" returned message "Login timeout expired".
OLE DB provider "SQLNCLI" for linked server "HRFEED" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.". (Microsoft SQL Server, Error: 2)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4053&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476
May 31, 2011 at 9:13 am
1 - See if you can ping the remote server >> fix all switches routers and ports
2 - See what connection types are allowed (can try ip over server name too)
3 - See if remote connection is allowed
4 - Remake the linked connection with sa so that you know permissions are not blocking anything
5 - Once sa works move down to the minimum permissions required.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply