FAQShop.com : ConfigMgr 2007 Installation and Configuration: SQL

ConfigMgr 2007 Installation and Configuration: SQL

This page details Installation and Configuration FAQs relating to SQL and ConfigMgr 2007. If you wish to see anything added to this page please feel free to email me the details.

Critical Updates for SQL 2005 SP2 [updated 11/04/08]
Cumulative Hotfix for SQL 2000 SP4 - Build 2187 for x86 and x64 Based Systems [23/03/06]
Cumulative Update Package for SQL Server 2005 SP2 [21/10/08]
Security Updates for SQL 2000 Reporting Services SP2 [08/09/08]
Security Updates for SQL 2005 SP2 [21/08/08]
Where can I download SQL 2000 Reporting Services SP1? [22/06/04]
Where can I download SQL 2000 Reporting Services SP2? [22/04/05]
Where can I download SQL 2000 SP3a? [27/08/03]
Where can I download SQL 2000 SP4? [06/05/05]
Where can I download SQL 2005 SP1? [18/04/06]
Where can I download SQL 2005 SP2? [06/03/07]
Where can I download SQL 2005 SP3 - CTP? [27/10/08]
Where can I download SQL 2005 SP3? [18/12/08]
Where can I find the Microsoft Support Lifecycle for SQL 2000? [04/05/04]
Where can I find the Microsoft Support Lifecycle for SQL 2005? [11/11/08]
Where can I find the Microsoft Support Lifecycle for SQL 2008? [12/11/08]

Critical Update for SQL 2005 SP2

Contributed By: Cliff Hobbs [MVP ConfigMgr/ SMS]
The following are critical updates for SQL 2005 SP2:

http://support.microsoft.com/?kbid=933508 - Only applicable if you downloaded SP2 BEFORE 05 March 07
http://support.microsoft.com/?kbid=934458 - This problem occurs in SQL Server 2005 builds 3042 - 3053 and 3150 - 3158. If you are running a build of SQL Server 2005 SP2 between 3042 and 3053, download and install the following critical update from the Microsoft Download Center:

SQL2005-KB934458-ENU

http://support.microsoft.com/?kbid=934459 - This problem occurs in SQL Server 2005 builds 3042 - 3053 and 3150 through 3158. If you are running a build of SQL Server 2005 SP2 between 3150 and 3158, download and install the following file from the Microsoft Download Center:

The following file is available for download from the Microsoft Download Center:

SQL2005-KB934459-ENU

Cumulative Hotfix for SQL 2000 SP4 - Build 2187 for x86 and x64 Based Systems 2

Contributed By: Cliff Hobbs [MVP ConfigMgr/ SMS]
This package contains all hotfixes that are available for SQL Server 2000 Service Pack 4 prior to build 2187.

This build contains hotfixes that were available for SQL Server 2000 Service Pack 3 build 1031 but were not included in SQL Server 2000 Service Pack 4:

http://www.microsoft.com/downloads/details.aspx?FamilyID=9c9ab140-bdee-44df-b7a3-e6849297754a&DisplayLang=en

Cumulative Update Package for SQL Server 2005 SP2

Contributed By: Cliff Hobbs [MVP ConfigMgr/ SMS]
The latest available Cumulative Update for SQL 2005 SP2 is Package 10 available from:

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

Update Package 11 is in progress see "Cumulative update package 11 for SQL Server 2005 Service Pack 2" for the latest information.

Security Updates for SQL 2000 Reporting Services SP2

Contributed By: Cliff Hobbs [MVP ConfigMgr/ SMS]
The following are Security Updates for SQL 2000 Reporting Services SP2:

MS08-052: Description of the security update for GDI+ for SQL Server 2000 Reporting Services Service Pack 2: September 9, 2008

Security Updates for SQL 2005 SP2

Contributed By: Cliff Hobbs [MVP ConfigMgr/ SMS]
The following are Security Updates for SQL 2005 SP2:

o MS08-040: Description of the security update for SQL Server 2005 GDR: July 8, 2008
o MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008
o MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 Hotfix: September 9, 2008

Contributed By: Cliff Hobbs [MVP]
The Support Lifecycle for SQL 2000 is available at:

http://support.microsoft.com/lifecycle/?p1=2852

Use the Support Lifecycle Index page to see an alphabetical index of all Microsoft products from which you can see their respective Support Lifecycles.

Where can I find the Microsoft Support Lifecycle for SQL 2005?

Contributed By: Cliff Hobbs [MVP ConfigMgr/ SMS]
The Support Lifecycle for SQL 2005 is available at:

http://support.microsoft.com/lifecycle/?p1=2855

Use the Support Lifecycle Index page to see an alphabetical index of all Microsoft products from which you can see their respective Support Lifecycles.

Where can I find the Microsoft Support Lifecycle for SQL 2008?

Contributed By: Cliff Hobbs [MVP ConfigMgr/ SMS]
The Support Lifecycle for SQL 2005 is available at:

http://support.microsoft.com/lifecycle/?p1=13165

Use the Support Lifecycle Index page to see an alphabetical index of all Microsoft products from which you can see their respective Support Lifecycles.