SQL connection issue?

• Biank

  Ten Centuries

  Points: 1332

  More actions

  October 21, 2008 at 3:05 pm

  #103608

  Hello,

  I'm having an issue connecting SQL 2000 server, weird one. I cannot ping/tracert from client machine to SQL server or vice versa. However, osql and telnet using 1433 work just fine but the application keeps throwing errors saying can't connect to SQL server... So, I wonder if this is a connection issue or not...

  Thanks for your help

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738337

  More actions

  October 21, 2008 at 4:50 pm

  #887883

  It sounds like networking. How is the app connecting? Is it trying for a named instance? Might need UDP 1434 open as well.

  Can you browse there from isqlw, click the drop down for server lists?

• Biank

  Ten Centuries

  Points: 1332

  More actions

  October 21, 2008 at 6:48 pm

  #887896

  thanks. yes, it was a network issue and network team found something (saying they were in different vlan) and coccrected. now i can connect the SQL server without any issue.

  Thanks again.