dbTalk Databases Forums  

SQL 2008 Clustering Error

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss SQL 2008 Clustering Error in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
drew.flint@gmail.com
 
Posts: n/a

Default SQL 2008 Clustering Error - 07-20-2009 , 08:44 AM






I'm trying to setup a SQL 2008 Cluster on a Windows 2008 Failover
Cluster. I'm going through the SQL Server Failover Cluster instance
setup wizard. I make it to the Instance Configuration screen. I've
entered SQL2K8_Cluster into the SQL Server Network Name field. I've
created an A record in DNS that matches the name specified. I have
also given an instance name of Primary and an instance ID of Primary.
I haven't changed the Instance root directory specification at all.
Name resolution appears to be working properly as I can do an nslookup
on the name and I get an IP address returned. Further if I do a ping
it comes back with the right IP address. I don't get any responses but
DNS is definitely doing it's job.
The specific error that I receive when I try to progress past this
screen is:

The SQL SErver failover cluster network name 'SQL2K8_Cluster is not
valid. The name must be a valid DNS and WinS name.

Please tell me that I don't have to setup WINS on my network to get
this to work properly. I just spent 2 months getting rid of it.
Any help would be greatly appreciated.

Drew Flint
Plex Systems

Reply With Quote
  #2  
Old   
drew.flint@gmail.com
 
Posts: n/a

Default Re: SQL 2008 Clustering Error - 07-20-2009 , 09:44 AM






On Jul 20, 9:44*am, "drew.fl... (AT) gmail (DOT) com" <drew.fl... (AT) gmail (DOT) com>
wrote:
Quote:
I'm trying to setup a SQL 2008 Cluster on a Windows 2008 Failover
Cluster. I'm going through the SQL Server Failover Cluster instance
setup wizard. I make it to the Instance Configuration screen. I've
entered SQL2K8_Cluster into the SQL Server Network Name field. I've
created an A record in DNS that matches the name specified. I have
also given an instance name of Primary and an instance ID of Primary.
I haven't changed the Instance root directory specification at all.
Name resolution appears to be working properly as I can do an nslookup
on the name and I get an IP address returned. Further if I do a ping
it comes back with the right IP address. I don't get any responses but
DNS is definitely doing it's job.
The specific error that I receive when I try to progress past this
screen is:

The SQL SErver failover cluster network name 'SQL2K8_Cluster is not
valid. The name must be a valid DNS and WinS name.

Please tell me that I don't have to setup WINS on my network to get
this to work properly. I just spent 2 months getting rid of it.
Any help would be greatly appreciated.

Drew Flint
Plex Systems
I think I might have figured this out. Evidently, the SQL Server
Network Name doesn't like to have _s in the name. Although the
instance name and instance id both support these.

Reply With Quote
  #3  
Old   
Ross Mistry
 
Posts: n/a

Default Re: SQL 2008 Clustering Error - 07-20-2009 , 01:46 PM



That error typically occurs if you are not using a valid DNS or WINS server
name. No, WINS is not required and can be retired.
--
Ross Mistry - Author Windows Server 2008 Unleashed, SQL Server 2008
Management & Administration


"drew.flint (AT) gmail (DOT) com" wrote:

Quote:
On Jul 20, 9:44 am, "drew.fl... (AT) gmail (DOT) com" <drew.fl... (AT) gmail (DOT) com
wrote:
I'm trying to setup a SQL 2008 Cluster on a Windows 2008 Failover
Cluster. I'm going through the SQL Server Failover Cluster instance
setup wizard. I make it to the Instance Configuration screen. I've
entered SQL2K8_Cluster into the SQL Server Network Name field. I've
created an A record in DNS that matches the name specified. I have
also given an instance name of Primary and an instance ID of Primary.
I haven't changed the Instance root directory specification at all.
Name resolution appears to be working properly as I can do an nslookup
on the name and I get an IP address returned. Further if I do a ping
it comes back with the right IP address. I don't get any responses but
DNS is definitely doing it's job.
The specific error that I receive when I try to progress past this
screen is:

The SQL SErver failover cluster network name 'SQL2K8_Cluster is not
valid. The name must be a valid DNS and WinS name.

Please tell me that I don't have to setup WINS on my network to get
this to work properly. I just spent 2 months getting rid of it.
Any help would be greatly appreciated.

Drew Flint
Plex Systems

I think I might have figured this out. Evidently, the SQL Server
Network Name doesn't like to have _s in the name. Although the
instance name and instance id both support these.

Reply With Quote
  #4  
Old   
drew.flint@gmail.com
 
Posts: n/a

Default Re: SQL 2008 Clustering Error - 07-21-2009 , 09:00 AM



On Jul 20, 2:46*pm, Ross Mistry <RossMis... (AT) discussions (DOT) microsoft.com>
wrote:
Quote:
That error typically occurs if you are not using a valid DNS or WINS server
name. *No, WINS is not required and can be retired.
--
Ross Mistry - Author Windows Server 2008 Unleashed, SQL Server 2008
Management & Administration



"drew.fl... (AT) gmail (DOT) com" wrote:
On Jul 20, 9:44 am, "drew.fl... (AT) gmail (DOT) com" <drew.fl... (AT) gmail (DOT) com
wrote:
I'm trying to setup a SQL 2008 Cluster on a Windows 2008 Failover
Cluster. I'm going through the SQL Server Failover Cluster instance
setup wizard. I make it to the Instance Configuration screen. I've
entered SQL2K8_Cluster into the SQL Server Network Name field. I've
created an A record in DNS that matches the name specified. I have
also given an instance name of Primary and an instance ID of Primary.
I haven't changed the Instance root directory specification at all.
Name resolution appears to be working properly as I can do an nslookup
on the name and I get an IP address returned. Further if I do a ping
it comes back with the right IP address. I don't get any responses but
DNS is definitely doing it's job.
The specific error that I receive when I try to progress past this
screen is:

The SQL SErver failover cluster network name 'SQL2K8_Cluster is not
valid. The name must be a valid DNS and WinS name.

Please tell me that I don't have to setup WINS on my network to get
this to work properly. I just spent 2 months getting rid of it.
Any help would be greatly appreciated.

Drew Flint
Plex Systems

I think I might have figured this out. Evidently, the SQL Server
Network Name doesn't like to have _s in the name. Although the
instance name and instance id both support these.- Hide quoted text -

- Show quoted text -
Thanks, Ross, I appreciate the advice.

Drew

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.