Solved

SQL Server 2008 Cluster Install Issues On Windows 2003 (SQL Network Name)

Posted on 2010-09-17
11
345 Views
Last Modified: 2012-05-10
Greetings,

I have had several failed attempts when attempting to install SQL Server 2008 Cluster on a windows 2003 active/passive cluster. Here's my issue. When I get to the point where I have to type a name for the SQL Network Name, I improvise a type a name like SQL2K8VRTL for example and the install completes with success but when I look in the cluster administrator tool the SQL Network name fails to start. I used the cluster admin account during installation and I still get the same error. Should I just use the virtual name created for the windows cluster instead of typing a name that does not already exist? Please advise.
0
Comment
Question by:Omega002
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 22

Accepted Solution

by:
65td earned 500 total points
ID: 33701622
Do not use the cluster network name.
In the SQL group is the IP address on line?
Is there a DNS name associated with the SQL IP?
SQL wants to register the SQL2K8VRTL  name it's self.

In the SQL group, one should have the at least the following resources:
IP
Network Name
Disk and SQL agent, SQL Server.
0
 

Author Comment

by:Omega002
ID: 33702677
So in order to use the SQL2k8VRTL name someone needs to create that name in DNS and assign an ip or can it have the same ip as the virtual name used for the windows cluster?
0
 
LVL 22

Assisted Solution

by:65td
65td earned 500 total points
ID: 33703291
Let SQL attempt to populate an empty DNS entry, if does not then populate it.
If there is an entry in DNS SQL will not create the network name.

Do not use the default cluster group resources including network name and IP or quorum drive.
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
LVL 22

Assisted Solution

by:65td
65td earned 500 total points
ID: 33703338
should have one IP for each node and one heartbeat address per node and an IP for the default cluster group (Administrative cluster).

Then each new group or service such as SQL should have it's own group and resources such as Network name and IP, disk and application or service.
0
 

Author Comment

by:Omega002
ID: 33703522
So it's fine to create any SQL network name during the installation even though it does not exist in DNS? So if that is the case and it doesn't create the SQL network name in DNS after the installation is complete just have the network admin add the unique SQL network name into DNS and everything should be working?
0
 
LVL 22

Assisted Solution

by:65td
65td earned 500 total points
ID: 33704336
Q1 yes
Q2 correct

What flavor of DNS is used, active directory integrated?
0
 

Author Comment

by:Omega002
ID: 33704592
Another question I have is that I have to run setup from second node after I complete the installation on the first node correct? In SQL Server 2005 you would only perform the installation on the first node and the installation is complete correct? So if I understand correct, SQL Server 2008 Cluster involves installation setup being executed on node1 then once completed you run installation setup on node2 correct?
0
 

Author Comment

by:Omega002
ID: 33704602
we use AD for DNS.
0
 
LVL 22

Assisted Solution

by:65td
65td earned 500 total points
ID: 33704717
Is the SQL install files 2005 Enterprise?
SQL 2005 standard can be used in a cluster (two nodes only).

http://support.microsoft.com/kb/327518

Install notes for SQL 2k5 std:
http://technet.microsoft.com/en-us/library/cc719004(WS.10).aspx
0
 

Author Comment

by:Omega002
ID: 33756478
This is not SQL Server 2005 it's SQL Server 2008 Enterprise Edition RTM.
0
 

Author Closing Comment

by:Omega002
ID: 34270533
No comments
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question