How to resolve RequireKerberos value problem in sql 2008 failover cluster installation process?

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

Recent Posts

Popular Topics

Home

Home » SQL Server 2008 » SQL Server 2008 - General » How to resolve RequireKerberos value problem...

Add to briefcase

17 posts, Page 2 of 2

««1 2

How to resolve RequireKerberos value problem in sql 2008 failover cluster installation process?

Expand / Collapse

Author

Message

Posted Monday, March 15, 2010 8:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, March 15, 2010 8:06 AM
Points: 1, Visits: 0

Thanks. This was of great assistance to us as well.

-Eric
http://www.theoperationsgroup.com

Post #882963

Posted Wednesday, May 19, 2010 12:51 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, December 23, 2010 9:27 AM
Points: 9, Visits: 96

It is a greate help for my SQL2K8 on Win2K8 failover cluster.
I wondered can I apply other post SP1 CUs together with this /PCUSource extension?
Thanks ahead!

Post #924592

Posted Wednesday, June 09, 2010 11:57 AM

Old Hand

Group: General Forum Members
Last Login: Friday, January 13, 2012 11:54 AM
Points: 355, Visits: 522

Thanks to all on this Thread, I'm really glad it was here.

Got a couple wierd things though

I went to
http://blogs.msdn.com/b/petersad/archive/2009/03/02/sql-server-2008-basic-slipstream-steps.aspx

but got the error

The following error occurred:

The setting 'PCUSOURCE' specified is not recognized.

Error result: -2068578301

Result facility code: 1204

Result error code: 3

Please review the summary.txt log for further details

so I followed the link that Peter had placed to his other blog entry
http://blogs.msdn.com/b/petersad/archive/2009/06/17/creating-a-merged-slipstreamed-drop-containing-sql-server-2008-rtm-service-pack-1.aspx

When I built this I still got the Kerberos error because i forgot to run sqlsupport.msi from the SP1 extraction.

pulled it all out, re installed and this time it installed, however it is show version 10.0.1600 the RTM release!

I'm going to add the other node to my cluster before running the SP to see if it upgrades this time.....

Twitter: @SQLBalls
Blog: http://www.SQLBalls.com

Post #934827

Posted Thursday, June 10, 2010 7:36 AM

Old Hand

Group: General Forum Members
Last Login: Friday, January 13, 2012 11:54 AM
Points: 355, Visits: 522

Just to follow up, I ran SP1 on each node and it upgraded just fine. Not sure what the slipstream issue was but at least i have my cluster up and running! BigGrin

BigGrin

Twitter: @SQLBalls
Blog: http://www.SQLBalls.com

Post #935341

Posted Monday, August 02, 2010 4:12 PM

SSC Journeyman

Group: General Forum Members
Last Login: Sunday, January 15, 2012 11:05 PM
Points: 84, Visits: 441

I realize this is an old thread, but I just wanted to add a couple of things. This is the second cluster where we have run into this same issue. The first one we ended up rebuilding, so here is what we have learned:

1. You will need to slipstream SP1 into the SQL 2008 install. For those of you, like me, who don't follow the cliff notes well on creating a slipstreamed install, here is a more thorough post on creating one:

http://blogs.msdn.com/b/petersad/archive/2009/02/25/sql-server-2008-creating-a-merged-slisptream-drop.aspx

2. If you have a hosed SQL 2008 install on a cluster, you will need to uninstall it first. Some of the directions out there indicate you will need to hack the registry to do this. That is how we ended up rebuilding the first cluster!

Actually all you need to do is uninstall the cluster. To uninstall a cluster, you remove the passive node(s) first by using the setup disk. Go to Maintenance->Uninstall Cluster Node. Then you will need to reboot. Next go to Add/Remove Programs and uninstall what is left of SQL Server. You may need to do this more than once to get all the litter off. You'll need to reboot again. Follow the same steps on the active node(s).

With the hosed installation, we also had to go to the cluster "Services and Applications", right click on SQL and delete it. This worked and we were able to successfully install SQL 2008 slipstreamed with SP1 after uninstalling the unsuccessful attempt.

Here are a couple of links on uninstalling a cluster:

http://msdn.microsoft.com/en-us/library/ms191545.aspx
http://msdn.microsoft.com/en-us/library/ms189134.aspx

Hope that helps!

Post #962512

Posted Thursday, April 14, 2011 1:50 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 26, 2012 10:25 PM
Points: 1,070, Visits: 1,677

I have a problem the application don't want sp2 of sql server and I am installing sql server 2008 cluster.
I am getting the error "There was an error setting private property RequiredKerberos to value '1' for resource sql network name error: value does not fail within the expected range".

Can Anyone search and show this error in Microsoft document not in msdn so thet I can show this to application guys that sp2 is required.

Thanks

Post #1093350

Posted Monday, April 18, 2011 12:55 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 26, 2012 10:25 PM
Points: 1,070, Visits: 1,677

Thanks it works ... But it doesnt show Sp2 in sql sever.Please make one entry in AD and DNS for sql and dtc with full permission of windows virtual cluster name.

Thanks

Post #1094750

« Prev Topic | Next Topic »

Add to briefcase

17 posts, Page 2 of 2

««1 2

Permissions

Expand / Collapse