?
Solved

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

Posted on 2010-09-17
11
Medium Priority
?
348 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 1000 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 1000 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
How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

 
LVL 22

Assisted Solution

by:65td
65td earned 1000 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 1000 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 1000 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

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 article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
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…

765 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