Specified SQL Server not found

• parasu

  Default port

  Points: 1460

  More actions

  July 9, 2003 at 3:27 pm

  #160519

  Hi all,

  When one of my VB based application opens, I get an error saying

  '[DBNETLIB][ConnectionOpen(Connect()).]Specified SQL Server not found.'

  Can someone help.

  Cheers

  Regards

  Parasu Raman

  
  Regards
  Parasu Raman

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737961

  More actions

  July 10, 2003 at 11:55 am

  #464950

  Are you sure the server is running? This is usually when you have typo'd the name or the server isn't running.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  http://www.dkranch.net

• hcl618

  SSC Enthusiast

  Points: 166

  More actions

  July 30, 2003 at 8:40 am

  #467748

  Hi, Steve,

  I have very similar question. I have installed Visio Studio.net and SQL Server 2000 on Windows 2003 Server. I'm using mix mode of security for SQL Server. When I launched .net and try to connect to SQL Server, the same error '[DBNETLIB][ConnectionOpen(Connect()).]Specified SQL Server not found.' came out. I then using ODBC to connect to SQL Server, it's successful. I then change the PC name of Windows Server 2003, it connected succesfully thru .net. I just wondering why is that?

  Harrison

  
  Harrison Lee
  HCL618@yahoo.com
  908-219-5435