Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 14th, 2007, 11:48 AM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default Understanding Linked Servers

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
__________________
========================
Scott Klein
Author of:
Professional SQL Server 2005 XML
Professional WCF Programming: .NET Development with the Windows Communication Foundation
Professional LINQ
========================
 
Old February 14th, 2007, 12:25 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Never mind...i got it. Stupid Windows XP firewall... :-)

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html





Similar Threads
Thread Thread Starter Forum Replies Last Post
LINKED Servers. WebLadyBug SQL Server 2005 1 April 9th, 2007 01:27 AM
Linked Servers rklio SQL Server 2005 0 February 5th, 2007 12:00 PM
Linked Servers msrnivas .NET Web Services 1 January 8th, 2005 09:27 AM
linked servers msrnivas General .NET 1 November 26th, 2004 01:19 AM
linked servers bukky Classic ASP Databases 1 March 6th, 2004 06:31 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.