Named Instance

• y.koteswarrao-652921

  SSCrazy

  Points: 2010

  More actions

  April 4, 2009 at 10:30 pm

  #71410

  Hi DBA gurus,

  Iam new to DBA..i installed the sql server 2000 defualt instance & named instance.And how to connect the named instance in sql server 2000?

  Can we work with both the instances paralelly!

  Please give me suggetions

  Thanks

  Koteswar.

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  April 4, 2009 at 11:52 pm

  #972137

  Hello,

  You just need to specify the Instance Name after the Server Name e.g. MyServer\MyInstance.

  You can use both a Default and a Named Instance simultaneously.

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group