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

multiple instances of sqlserver different dns alias Expand / Collapse
Author
Message
Posted Sunday, April 14, 2013 8:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 15, 2013 6:20 AM
Points: 3, Visits: 12
Hi ,

I have installed named instances sqlserver2005 express and sqlserver2012 on the same Windows 2008 server Virtual machine ,configured sqlserver2012 to use NON Default TCP IP port .

we need 2 different DNS Aliases for these 2 database Servers i.e I should be able to access by specifying the following properties in my application
user=sa
password=myPwd
hostname=mysql2005.us.comp.com
port=1433
instanceName=sqlserv2005

user=sa
password=myPwd
hostname=mysql2012.us.comp.com
port=1533
instanceName=sqlserv2012

Is this possible?Can you give pointers on how to achieve this

ManyThanks,
BG


Post #1442104
Posted Monday, April 15, 2013 3:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 15, 2013 6:20 AM
Points: 3, Visits: 12
no replies yet.. Hope my requirement is clear
Post #1442219
Posted Monday, April 15, 2013 5:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:55 AM
Points: 6,752, Visits: 14,397
You'll need to use aliases within the SQL Server configuration manager, these are detailed here.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1442264
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse