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 Monday, April 15, 2013 3:35 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 #1442223
Posted Monday, April 15, 2013 3:54 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 AM
Points: 42,445, Visits: 35,501
Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1442104-1550-1.aspx



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1442231
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse