July 3, 2008 at 12:12 pm
Hello,
we have 2 clustered environments,QA and Prod.
They are absolutely identical.
When i'm running select * from sys.servers...
one is showing virtual sql server name
second is showing me a clustername
how do i fix that?
July 3, 2008 at 12:46 pm
did you rename the server after installation.
Maninder
www.dbanation.com
July 3, 2008 at 12:50 pm
no sir, i didn't
July 6, 2008 at 10:42 pm
Could you please provide more details
How many nodes in each cluster?
How many SQL instances?
How many groups do you see in Cluster Admin?
July 7, 2008 at 6:55 am
Here is more details:
Windows 2003 standard, sql 2005 sp2,
QA environment:
1. Cluster group name - CL1
2. Consist of two active/passive nodes
ND1 and ND2
3. Virtual sql server name SQLQA01
Right click on sql server properties:
Server name - SQLQA01 - Looks good!
Now second installation,
PR environment:
1. Cluster group name – CL2
2. Consist of two active/passive nodes
ND3 and ND4
3. Virtual sql server name SQLPR01
Right click on sql server properties:
Server name - CL2 - ?????????
The vierd part is that I was able to connect to this virtual sql server by specifying the sql virt name.
Some of the sql fetures like error log or dbmail were not working.
So the way around was: create an alias in sql configuration manager.
Where alias name CL2, net protocol Named Pipes, server SQLPR01.
Working just great.
It just bothers me, WHY it has different properties name if the same installation procedure was followed during both setups.
Also please someone explain, what is the difference between instance name and virtual sql name?
Is the default instance name has the same name as a cluster group name?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply