April 15, 2013 at 3:35 am
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
April 15, 2013 at 3:54 am
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply