Microsoft® SQL Server® 2008 R2 Service Pack 1 and Cumulative Update package 1 for SQL Server 2008 R2

I will explain the steps how to install SQL Server R2 SP1 & its CU in Cluster environment.

[Microsoft® SQL Server® 2008 R2 Service Pack 1]

http://www.microsoft.com/download/en/details.aspx?id=26727

[Cumulative Update package 1 for SQL Server 2008 R2]

http://support.microsoft.com/kb/2544793/en-us

1. First download the setup files.
2. Take backup of your environment.
3. Go to Passive Node.
4. Install Microsoft® SQL Server® 2008 R2 Service Pack 1 in Passive Node server.
5. Install Cumulative Update package 1 for SQL Server 2008 R2 in Node server .
6. Restart the server
7. Move SQL Service to Upgraded Server and wait for 1 min until SQL Server finish from Upgrade mode
8. then go to Second server and do the same steps

Note : 

1. before install SP 1 & CU make sure Integration Service is started
2. if you get any error just reboot the system and rerun the setup file again

Cluster network name resource SQL Network Name{} failed to create its associated computer object in domain{}

I got an error while installing SQL Server 2008 R2 Clustering which the error is :
"Cluster network name resource SQL Network Name{} failed to create its associated computer object in domain{} for the follwoing reason:Unable to update password for computer account. The text for teh associated error code is :Access is denied."

so if you see the error in the first image you will see also the suggestion solution to sovle this error and this problem so you have to do the following before install SQL Server Clustering :

1. Go to Active Directory Users and Computers
2. Right Click on SQL Cluster Name (Computer Object name)
3. Go to Properties
4. Go to Security Tab
5. Add Windows Cluster Name (Computer Object name) with Full Control
6. Apply and OK.

then remove the current installation and reinstall SQL Server 2008 R2 from begining.

SQL Server 2008 in Windows Server 2008 R2 (SlipStream method)

During these days i have tried to install SQL Server 2008 Failover cluster in Windows Server 2008 R2 but i have faced many problems when i try to install SQL Server 2008 with SP1 or SP2 and these error like "There wan an error setting private property RequireKerberos to value 1 for resource ..." , "Network Name already exists" so i search for the solution in the internet and i found this is way to fix the above problem by using SlipStream method
http://blogs.msdn.com/b/petersad/archive/2009/03/02/sql-server-2008-basic-slipstream-steps.aspx
http://blogs.msdn.com/b/petersad/archive/2010/10/14/creating-a-merged-slipstream-drop-containing-sql-server-2008-rtm-and-service-pack-2.aspx

and these are the steps for basic Slipstream :
Extract SP1 to folder c:\SP1 by using this command

SQLServer2008SP1-KB968369-x64-ENU.exe /x:C:\SP1
then run MSI file go to C:\SP1\x64\setup\1033\sqlsupport.msi
finally run this command
setup.exe /PCUSource=C:\SP1 and continue as normal steps.
Done

Moving tempdb to new clustered disk with SQL Server 2008

If you create new clustered disk for tempdb database and you want to move the current tempdb database to this new clustered disk you have to do the following:
so after you add new storage to SQL Server services group

and this disk for example label as I: so if you try to run the following command:

USE master
GO

ALTER DATABASE TempDB MODIFY FILE
(NAME = tempdev, FILENAME = 'I:\MSSQL10_50.SQL2008\MSSQL\DATA\tempdb.mdf')
GO

ALTER DATABASE TempDB MODIFY FILE
(NAME = templog, FILENAME = 'I:\MSSQL10_50.SQL2008\MSSQL\Data\templog.ldf')
GO

you will get this error

Msg 5184, Level 16, State 1, Line 1
Cannot use file 'I:\MSSQL10_50.SQL2008\MSSQL\DATA\tempdb.mdf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.

Msg 5184, Level 16, State 1, Line 1
Cannot use file 'I:\MSSQL10_50.SQL2008\MSSQL\Data\templog.ldf' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.
 
so to resovle the above error you have to add the new Clustered disk to dependencies of SQL Server resource

so go to Other Resources and Right Click on Sql Server instance resource and then go to dependencies
and then add a Dependency and choose Clustered disk (I:)

Now again re-run the T-Sql statement and then restart the SQL Server instance serivce.

NOTE: SQL Server will create new tempdb database in the new place so you have to go to the old space where the original files of tempdb database and remove it.

Done.