Remote Connection to SQL 2005 Express running on Windows 7

90 pts.
Tags:
Remote connection
SQL 2005 Express
windows 7 32 bit
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 9  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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.
    69,175 pointsBadges:
    report
  • Goofy
    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.
    90 pointsBadges:
    report
  • carlosdl
    I believe the express edition installs as a named instance by default. Are you trying to connect using the named instance format ?
    69,175 pointsBadges:
    report
  • Goofy
    Yes, I am have tried using the IPAddress\InstanceName and the Computer Name\Instance Name.
    90 pointsBadges:
    report
  • carlosdl
    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 
    69,175 pointsBadges:
    report
  • Denny Cherry
    are you able to telnet to the SQL servers port?
    66,075 pointsBadges:
    report
  • Goofy
    No, I am not able to telnet on the SQL port.
    90 pointsBadges:
    report
  • TomLiotta
    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
    125,585 pointsBadges:
    report
  • Goofy
    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.
    90 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following