Good morning,
I am trying to get my head around linked servers.
I have two SQL Server 2005 boxes. One is a test server, and one is my local box.
My local box (Windows XP Pro) has mixed mode authentication turned on, I am not sure about the test server.
However, I log into the test server using Windows Authentication, and I log into my local SQL Server using SQL authentication.
On my local box, i have remote connections enabled for both TCP/IP and Named Pipes.
IN SSMS on the Test server, I right mouse click on Linked Servers and select New Linked Server. On the "New Linked Server" dialog, I select SQL SERVER for the Server Type and for the Linked Server I enter the machine name of my local box.
On the security page I have "Be made using the login's current security context" and I have added a "local server login to remote server login mapping" configured as follows:
Local Login: my windows credentials
Impersonate: is not checked
Remote User: sa
Remote Password: sa password
I then open a query window and execute the following query:
SELECT * FROM MyServerName.Test.db.TestTable
I get the following error:
Login timeout expired
Named Pipes Provider: Could not open a connection to SQL Server.
So, what did I miss?
Your insight is greatly appreciated.
Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html
Understanding Linked Servers
