I have a development machine that is Windows 7 x64. I have a client computer that is Windows XP SP3. I have deployed a ClickOnce .NET application that uses SQL Server 2008 (installed on development machine) as it's data access. No matter what I try I cannot
get the Windows XP computer to connect to the SQL Server.
- Firewall is completely shut off on the Windows 7 machine
- The SQL Server instance is a named instance
- I have modified the instance to accept TCP Connections via SQL Server Configuration Manager > Protocols For [named instance] > TCP/IP > Enabled
- I have created a secure login using SQL Server authentication for the connection string
- The SQL Server instance is set up for "SQL Server and Windows Authentication Mode"
- Development computer is setup to allow network discovery
- SQL Server is not installed on client computer (because it doesn't need to be - correct?)
- Instance is configured to allow remote connections
Despite this I get a "Error: 26 - Error Locating Server/Instance Specified." I can't figure this out...
What do I need to do so that my development computer can host a named SQL Server instance that other computers on the network can connect to?
View Complete Post