Solved

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

Posted on 2010-09-17
11
342 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
  • 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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
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 …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

786 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