Instance name

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Instance name

Instance name

Rate Topic

Display Mode

Topic Options

Author

Message

Bharatdaputtar

Posted Friday, June 20, 2008 3:16 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 23, 2008 10:30 PM
Points: 1, Visits: 3

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

Post #521076

SQLshifu

Posted Friday, June 20, 2008 3:37 PM

SSC Rookie

Group: General Forum Members
Last Login: Thursday, June 03, 2010 5:55 PM
Points: 35, Visits: 134

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?

Post #521085

« Prev Topic | Next Topic »

Permissions