Can’t create ODBC connection to sql 2005 instance
Home > IT Answers > SQL Server > Can't create ODBC connection to sql 2005 inst...
Therockatmsu
15 pts.
0
Q:
Can't create ODBC connection to sql 2005 instance
SQL Server 2005 connectivity, SQL Server 2005, SQL Server connectivity, ODBC, Windows Server 2003, Windows XP, Vista, 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.
ASKED: Apr 21 2009  4:20 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Therockatmsu
15 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: Apr 21 2009  4:20 PM GMT by Therockatmsu   15 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Therockatmsu   15 pts.  |   Apr 21 2009  5:34PM GMT

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?

 

mrdenny   46765 pts.  |   Apr 26 2009  4:35AM GMT

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.

 
0