Cannot Connect XP sp2 To SQL server 2005

• Tony Merritt

  Newbie

  Points: 7

  More actions

  October 9, 2006 at 10:58 am

  #114689

  Please Help, Have connected up a number of clients to my SQL server with no problem. But on one machine I cannot connect. Same setting as other client etc, and I can ping the server but it will not connect coming back with SQL server error 17. Have tried MS site , but really find it to be no help. If someone could point me in the right direction to solve this I would be most grateful

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  October 9, 2006 at 11:36 am

  #664855

  Would ylu please post the entire error message you are getting.  I can't find anything regarding SQL Server error 17.

  

• Greg Edwards-268690

  SSC-Insane

  Points: 20676

  More actions

  October 10, 2006 at 7:19 am

  #664992

  Tony -

  Verify if the firewall is on or off. Then test with it off.

  There's also a log file for this, which may be helpful.

  How you are connecting?

  Thanks, GE

• Dylan Davis

  Ten Centuries

  Points: 1283

  More actions

  October 10, 2006 at 7:55 am

  #665004

  do you have the right port selected? I was having that problem. Either and and alias, or use servername, port.

  hope it helps

• vadba

  SSChampion

  Points: 11133

  More actions

  October 10, 2006 at 8:35 am

  #665018

  Error 17 is not a SQL Server error - it is probably an error in the OLEDB provider. Read this link and see if it applies to your situation:

  http://blogs.msdn.com/sql_protocols/archive/2005/12/19/505372.aspx