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?
Software/Hardware used: Windows 7 Professional, SQL 2005 Express
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!