Can’t create ODBC connection to sql 2005 instance

15 pts.
Tags:
Microsoft Windows Server 2003
Microsoft Windows Vista
Microsoft Windows XP
ODBC
SQL Server 2005
SQL Server 2005 connectivity
SQL Server connectivity
SQL Server Management Studio
I have a server 2003 two node cluster with SQL 2005 installed. The orginal instance is working fine and there is no connection problem. I have created a second instance and can connect with the SQL Management Studio. When i try to create a ODBC connection from my client os both XP and VISTA both fail saying sql server error: 14. I am guessing there is a permission problem but I can't figure out where to start.

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: 2  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
  • Therockatmsu
    I am giving a update. I got the xp box to connect finally. It was a permission problem that was corrected when i used the vista provisioning tool but it still did not correct my vista box. The vista box will connect by named pipes but not with tcp/ip. The xp box will connect either way. What is something to look at?
    15 pointsBadges:
    report
  • Denny Cherry
    Check that the SQL Browser is working and that the Vista firewall is setup to allow communication to the SQL Cluster. It will need access to communicate to all IPs on the cluster.
    66,185 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