Tag: SP2

Slipstream SQL Server 2008 SP2 for SCCM 2012

The Release Candidate version of System Center Configuration Manager 2012 requires MS SQL Server 2008 SP2 with Cumulative update package 6. Now this can be a little annoying and will hopefully change to SQL Server 2008 R2 in the RTM version.

Now if you want to install MS SQL Server 2008 on a Windows Server 2008 R2 you need at least a install media with SP1. Now this post shows you how you can integrate Service Pack 2 into the install media of SQL Server 2008.

  1. Copy the SQL Server 2008 install media to C:\SQLServer2008withSP2
  2. Download and copy the SQL Server 2008 Service Pack 2 files to C:\temp
  3. Now you can run the following commands:
    SQLServer2008SP2-KB2285068-IA64-ENU.exe /x:c:\SQLServer2008withSP2\PCU
    SQLServer2008SP2-KB2285068-x64-ENU.exe /x:c:\SQLServer2008withSP2\PCU
    SQLServer2008SP2-KB2285068-x86-ENU.exe /x:c:\SQLServer2008withSP2\PCUrobocopy C:\SQLServer2008withSP2\PCU c:\SQLServer2008withSP2 Setup.exe
    robocopy C:\SQLServer2008withSP2\PCU c:\SQLServer2008withSP2 Setup.rll
    robocopy C:\SQLServer2008withSP2\pcu\x86 C:\SQLServer2008withSP2\x86 /XF Microsoft.SQL.Chainer.PackageData.dll
    robocopy C:\SQLServer2008withSP2\pcu\x64 C:\SQLServer2008withSP2\x64 /XF Microsoft.SQL.Chainer.PackageData.dll
    robocopy C:\SQLServer2008withSP2\pcu\ia64 C:\SQLServer2008withSP2\ia64 /XF Microsoft.SQL.Chainer.PackageData.dllecho PCUSOURCE="C:\SQLServer2008withSP2\PCU" >> C:\SQLServer2008withSP2\x86\DefaultSetup.ini
    echo PCUSOURCE="C:\SQLServer2008withSP2\PCU" >> C:\SQLServer2008withSP2\x64\DefaultSetup.ini
    echo PCUSOURCE="C:\SQLServer2008withSP2\PCU" >> C:\SQLServer2008withSP2\ia64\DefaultSetup.ini
  4. After you have done this you can install the MS SQL Server
  5. After you have installed it, you still need to download and install the Cumulative update package 6 for SQL Server 2008 Service Pack 2

More about SQL Slipstreaming on Peter Saddow’s MSDN blog post.



Error: IIS6 Error EventID 1059 and 1021

Just a had a problem with an application pool which always crashed after start. The application pool worked some days ago without any problems. After watching den System Eventlog I got the Error with Event ID 1059 and a Warning with Event ID 1021.
I had this problem on a Windows Server 2003 SP2 with all the latest patches
EventID 1059
Event Type: Error
Event Source: W3SVC
Event Category: None
Event ID: 1059
Date: 27.05.2011
Time: 11:49:31
User: N/A
Computer: WEB-WIN
Description:
A failure was encountered while launching the process serving application pool 'www.domain.ch'. The application pool has been disabled.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

EventID 1021
Event Type: Warning
Event Source: W3SVC
Event Category: None
Event ID: 1021
Date: 27.05.2011
Time: 11:50:01
User: N/A
Computer: WEB-WIN
Description:
The identity of application pool, 'www.domain.ch' is invalid. If it remains invalid when the first request for the application pool is processed, the application pool will be disabled. The data field contains the error number.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 2e 05 07 80 ...€

The Solution for this problem is very simple. Just reset the password of the specific IUSR and don’t forget to reset the password for the application pool identity.