Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Instance name Expand / Collapse
Author
Message
Posted Friday, June 20, 2008 3:16 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Friday, June 20, 2008 3:37 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC 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 »

Add to briefcase

Permissions Expand / Collapse