Connection Issue !

• Sanz

  Hall of Fame

  Points: 3412

  More actions

  July 12, 2007 at 7:04 am

  #124909

  Hi,

  I had sql server 2000 client installed. At the same time had sql server 2005 express installed on the same machine. It was workin well nd fine.Later I upgraded the client version of 2000 to server (as named instance).

  I can connect to both my instances locally but am not able to connect to the 2000 named instance through the network.

  Tried many things like changing the settings, installing sp3 and all but in vain.

  Please help me out !

  Thanks in Advance

  Santhosh

  Sanz

• Sanz

  Hall of Fame

  Points: 3412

  More actions

  July 12, 2007 at 12:12 pm

  #719067

  Issue solved !

  I tried giving the sql server 2000 port number i.e,1433 nd it got connected.

  The whole server name will look like this

  [server name]\[Instance],1433

  Was plannin for another installation actually. Hope this is of help to someone else.

  Sanz