Connection Problems

• nick.watt

  SSC Rookie

  Points: 43

  More actions

  September 15, 2008 at 4:22 am

  #197757

  Hi folks

  We have SQL Server Express installed on a server and at present only one machine can connect. I have tried creating an ODBC connection (User DSN because that is what the software requires!) in exactly the same manner on the other 2 machines using the same credentials but to no avail. It says the SQL Server cannot be found despite the fact in the first step I actually select the Server\Instance from a drop down list.

  I have even tried writing a quick VB Script which creates an ADO connection (using a connection string) to connect to the database but this just fails saying server/instance cannot be found. However the script works on the other machine.

  Anybody got any ideas? The machines can all see the server and can access it via unc paths. On the machines that don't work I can even remote desktop to the server.

  Firewalls are not on, on any machine. TCP and Name Pipes is on and I restarted the services after making any changes on the server.

  Any help would be greatly appreciated.

  Thanks

  Nick

• Johan Bijnens

  SSC Guru

  Points: 135369

  More actions

  September 15, 2008 at 5:15 am

  #871663

  I would say their windows firewall isn't opened to use the sqlserver ports.

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  September 15, 2008 at 5:20 am

  #871666

  Hello,

  If it is not a firewall related issue then try specifying the Port in the connection string i.e. Ip-Address\instance-name,NNNN

  (Where NNNN is the Port that the SQL Server Instance is listening on. BTW - I am assuming the Instance is configured to listen on a Static Port?)

  Regards,

  John Marsh

  PS: Could you then post the full error message that is being returned?

  www.sql.lu
  SQL Server Luxembourg User Group