Error connection to MSDE

• Nazas

  Newbie

  Points: 1

  More actions

  March 27, 2004 at 11:43 am

  #82482

  Hi all,

   

  I have the Windows 2003 Server in my company and the MSDE SP3 install with an instance for a program. But the program can’t access the database, I have tried to create a new data source to SQL Server in ODBC and it tells me SQL Server Error: 11004 (Connection failed) and SQL Server Error: 6 (Specified SQL server not found).

   

  The MSDE is running with the name “SERVER\INSTANCE”. I have enabled the protocols in SVRNETCN.

   

  Does anyone know what to do?

   

  Thanks

• March 30, 2004 at 8:00 am

  This was removed by the editor as SPAM

• K. Brian Kelley

  SSC Guru

  Points: 114562

  More actions

  March 30, 2004 at 8:54 am

  #501092

  Find out what TCP port it is listening on and see if you can connect to it by directly referencing the port.

  K. Brian Kelley
  @kbriankelley

• uknow

  Valued Member

  Points: 55

  More actions

  April 1, 2004 at 11:40 am

  #501504

  I think sp3 turns off TCP for MSDE.

  You can load the sql tools from the full version of SQL server on the machine and turn TCP back on.