Instance name

• Bharatdaputtar

  Grasshopper

  Points: 15

  More actions

  June 20, 2008 at 3:16 pm

  #124467

  When we install a MSSQL Server instance, can we use a custom instance name? E.g. If I am installing on hostname -serverA, my only choices are serverA ( default instance ), or serverA\dev if I chose "dev" as my named instance.

  However I wish to install SQL server as instance serverB.

  I need this for Disaster recovery.

  Please advise,

  Thanks ... Bharat

• SQLshifu

  SSC Eights!

  Points: 953

  More actions

  June 20, 2008 at 3:37 pm

  #832101

  If I'm understanding you correctly, you are asking if you could install a sql server instance called serverB on a physical server called serverA. However, when you make a connection to it, you want to just want to connect to "serverB".

  My guess is that it is not possible.

  Why not just name both instances. ServerA\instance1, ServerA\instance2?