I have a Windows 7 machine running SQL 2005 Express. I am able to connect to the SQL from the local machine. However, I am not able to connect from other machines. This machine will connect to a SQL 2005 running on Windows XP but the Windows XP will not connect to the Windows 7 SQL. I have ensured that the Named Pipes and TCP/IP protocols are enabled. I have the SQL set to allow Remote Connections. The Windows Firewall is turned off on each machine. The Windows 7 machine is using Dynamic Port for the SQL. I have the SQL Browser service running using Local System account. What else would I need to check to be able to connect to the SQL on the Windows 7 machine?
Windows 7 Professional, SQL 2005 Express
August 21, 2012 2:47 PM