Remote Connection to SQL 2005 Express running on Windows 7
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
Software/Hardware used:
Windows 7 Professional, SQL 2005 Express
ASKED:
August 21, 2012 2:47 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
You might want to let us know what happens when you try to connect. If you get an error message, posting it would be a good idea.
I am using a UDL file to test the connection. The UDL file gives me a MicrosoftData Link Error that states:Test connection failed because of an error in initializing provider. [DBNETLIB] [ConnectionOpen (Connect()).] SQL server does not exist or access is denied. The SQL is in Mixed Authentication Mode and I am using the sa account and password.
I believe the express edition installs as a named instance by default. Are you trying to connect using the named instance format ?
Yes, I am have tried using the IPAddress\InstanceName and the Computer Name\Instance Name.
Well. Not sure what else you can try/check.
I’m not a SQL Server expert. Let’s wait for someone with more experience/knowledge on the subject.
I found this document, which mentions possible causes for an error message like the one you are receiving. It mentions Sql Server 2000 a lot, but in the “Applies to” section, the 2005 version is included.
You might want to take a look:Potential causes of the “SQL Server does not exist or access denied” error message
are you able to telnet to the SQL servers port?
No, I am not able to telnet on the SQL port.
No, I am not able to telnet on the SQL port.
Why not? What happens? If messages showed up, what were they? What was the telnet command that you tried?
Tom
I used Telnet [IP ADDress of SQL Server] [Port of Dynamic SQL Port of SQL Server] .The message I get is that it could not open connection tothe host,on port [Port of Dynamic SQL Port of SQL Server]: Connection Failed. I have the firewalls on both machines turned off. We have a domain firewall and I put rules in place on that firewall to allow incoming and outgoing on this port.