SQL Server Performance

SQL Server error - The linked server has been created but failed a connection test. Do you want to keep the linked server?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jan 15, 2008.

  1. Anonymous New Member

    Linked Server errors, such as between SQL Server 2000 and 2005 versions are quite common in DBA-day life. When it goes wrong I would always refer (myself) and others to review HowDoI-PreventLinkedServerIssues resource from ASPFAQ site. Also the usual practice of checking of whether its a security issue to allow the logins, if so then goto the Security page (still on Linked Server Properties). Select ' Be made using this security context '. Type a login and password that exists on the remote server....(<a href="http://sqlserver-qa.net/blogs/tools/archive/2008/01/16/linked-server-issues.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=891" width="1" height="1">

Share This Page