Solved

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

Posted on 2010-09-17
11
344 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Cannot take ownership of a folder 8 79
SSIS Paramater on start 2 27
SQL Select Query help 1 38
SQL- GROUP BY 4 25
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 we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
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…

730 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