April 14, 2013 at 8:33 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:30 am
no replies yet.. Hope my requirement is clear
April 15, 2013 at 5:39 am
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" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply