SCCM 2007 SP1 with SQL 2008

Thu, 18 Sep 2008 14:00:05 Z

does SCCM 2007 sp1 works with SQL 2008?

SCCM 2007 SP1 with SQL 2008

Thu, 18 Sep 2008 15:26:48 Z

Not yet.

SCCM 2007 SP1 with SQL 2008

Fri, 19 Sep 2008 13:40:23 Z

SCCM 2007 SP1 does not work with SQL 2008 but I have successfully installed SCCM 2007 R2 with SQL 2008

SCCM 2007 SP1 with SQL 2008

Fri, 26 Sep 2008 20:01:34 Z

We do now support SQL Server 2008 with both the RTM and SP1 versions of Configuration Manager :-)

However, officially yet, we don't support the R2 features with SQL Server 2008. That testing is still under way.

SQL Server 2008 is now supported on Configuration Manager 2007 RTM and SP1

System Center Configuration Manager 2007 (RTM and SP1) now supports the use of SQL Server 2008 as a site database. In order to upgrade a site-server database to SQL 2008 there are 2 hot fixes required:

· ConfigMgr 2007 RTM customers must apply hot fix KB955229

· ConfigMgr 2007 SP1 customers must apply hot fix KB955262

The following are requirements when performing a clean install on a SQL Server 2008 database:

· A clean install of ConfigMgr 2007 RTM on a SQL Server 2008 database is not supported. You must first install SQL Server 2005, upgrade to SQL Server 2008 and then apply hot fix KB955229

· A clean install of ConfigMgr 2007 SP1 on a SQL Server 2008 database is supported, but should apply hot fix KB955262

We do now support SQL Server 2008 with both the RTM and SP1 versions of Configuration Manager :-)

However, officially yet, we don't support the R2 features with SQL Server 2008. That testing is still under way.

SCCM 2007 SP1 with SQL 2008

Wed, 22 Oct 2008 13:35:21 Z

Have there been any updates to this yet or is the above information still the latest?

Wally, is this published anywhere else on Microsoft's site?

Currently this now out-dated information is still posted on TechNet...http://technet.microsoft.com/en-us/library/bb694113.aspx

Site Database Server Prerequisites

Configuration Manager 2007 primary sites require access to a SQL Server database to host the site database. The site database can be hosted on a SQL Server instance installed on the same server as the primary site, on a remote computer, or on a virtual SQL Server cluster instance. The following conditions apply:

SQL Server 2005, Service Pack 2 is the only version of SQL Server supported for hosting the Configuration Manager 2007 site database.
SQL Server 2005 Express is not a supported SQL Server 2005 version for hosting the Configuration Manager 2007 site database.
The SQL database service is the only SQL Server component required to be installed to host the site database.

SCCM 2007 SP1 with SQL 2008

Wed, 22 Oct 2008 16:26:47 Z

Documentation does not get immediately updated. I've heard that the next doc drop is not until December.

So yes, as far as I know the information above is the most current. What is it that you are looking for exactly?

SCCM 2007 SP1 with SQL 2008

Mon, 27 Oct 2008 13:34:44 Z

I'm just looking for the official word that SCCM 2007 supports SQL 2008 that I can present to management. I will just reference your post. Thanks for getting back with me.

SCCM 2007 SP1 with SQL 2008

Mon, 27 Oct 2008 19:51:10 Z

I'm not entirely sure why we only updated the Supported Configurations documentation to state we support Windows Server 2008, but not to reflect SQL Server 2008. I know the support came quite awhile apart, but seems to be a gap to me.

Sorry that we haven't done so :-(

SCCM 2007 SP1 with SQL 2008

Tue, 24 Feb 2009 17:23:15 Z

Wally, is this still the most current data?
"However, officially yet, we don't support the R2 features with SQL Server 2008. That testing is still under way."

Thanks, Duncan

Duncan McAlynn, MVP/MCSE/MCSA/CISSP

SCCM 2007 SP1 with SQL 2008

Tue, 24 Feb 2009 19:24:10 Z

Based on the following statement, I'm going to assume that it is supported with the applied hotfix:

"2When SQL Server 2008 is used to host the site database for a Configuration Manager 2007 R2 installation, it is recommended that you install the update described in Microsoft article ID 957576 located at http://go.microsoft.com/fwlink/?LinkId=134675."

Source: http://technet.microsoft.com/en-us/library/cc161851.aspx

Duncan McAlynn, MCSE/MCSA/CISSP

SCCM 2007 SP1 with SQL 2008

Tue, 24 Feb 2009 21:18:37 Z

Hi,

Please also take a look at the following thread regarding SQL 2008 support:
http://social.technet.microsoft.com/Forums/en-US/configmgrdocs/thread/1763c6fa-aa46-4c0f-b9db-9dba34f163b2

Please mark posts as Answered if appropriate.

SCCM 2007 SP1 with SQL 2008

Mon, 09 Mar 2009 19:36:40 Z

DuncanMc said:

Wally, is this still the most current data?
"However, officially yet, we don't support the R2 features with SQL Server 2008. That testing is still under way."

No, it is not. We do now support Configuration Manager 2007 R2 with SQL Server 2008.

Wally Mead

SCCM 2007 SP1 with SQL 2008

Mon, 23 Mar 2009 16:30:04 Z

Would that include a clustered SQL 2008 configuration?

Duncan McAlynn, MCSE/MCSA/CISSP

SCCM 2007 SP1 with SQL 2008

Tue, 24 Mar 2009 08:11:45 Z

Yes: http://technet.microsoft.com/en-us/library/bb693612.aspx

SCCM 2007 SP1 with SQL 2008

Tue, 24 Mar 2009 16:58:52 Z

DuncanMc said:

Would that include a clustered SQL 2008 configuration?

Duncan McAlynn, MCSE/MCSA/CISSP

Yes, SQL Server 2008 supports the same features for Configuration Manager as SQL Server 2005 SP2.

Wally Mead

SCCM 2007 SP1 with SQL 2008

Wed, 13 May 2009 13:29:20 Z

The Hotfix page for KB955262 does not allow request any longer. Where do people get it, as the link states no public fixes for it are available.

Thanks
David Baur

David Baur

SCCM 2007 SP1 with SQL 2008

Wed, 13 May 2009 13:48:14 Z

Does the Hotfix for 969529 supercede 955262?

David Baur

SCCM 2007 SP1 with SQL 2008

Thu, 14 May 2009 06:49:58 Z

Does the Hotfix for 969529 supercede 955262?

Yes, according to the download section in premier.microsoft.com.
Edit: I just installed 969529 on a brand new ConfigMgr site and it also solved the issue that the drivers node was not displayed.

SCCM 2007 SP1 with SQL 2008

Thu, 14 May 2009 11:55:44 Z

I thought it would, Thanks Torsten!

David Baur

David Baur

SCCM 2007 SP1 with SQL 2008

Wed, 20 May 2009 23:39:26 Z

You know if you would have posted this as a new thread in the proper forum (such as General or Setup/Deployment) people might have gotten on it earlier :-)

Not sure how this is an announcement :-)

But yes, 969529 replaces 955262. The KBs are being updated to reflect that.

Wally Mead

SCCM 2007 SP1 with SQL 2008

Thu, 21 May 2009 14:33:21 Z

Many Thanks Wally,

David Baur

David Baur

SCCM 2007 SP1 with SQL 2008

Tue, 27 Oct 2009 05:47:34 Z

Hi Wally,

what can I do if I installed SCCM R2 and forgot to install KB969529 first?
The 969529 installer tells me that this is the wrong build number. I assume 969529 can only update SP1 but not R2?
Please don't tell me to install SP2 as i have a german version and SP2 is not yet available in german.

Thanks,
Dieter

SCCM 2007 SP1 with SQL 2008

Wed, 28 Oct 2009 11:01:37 Z

Hi,

in the meantime i could successfully resolve this issue.
The "wrong build number" referred to the Windows Version (not SCCM), as I was installing on Server 2008 R2.
So better wait for SCCM SP2, as 969529 cannot be installed on Server 2008 R2. (I know this is not fully supported...)
I manually replaced the files and executed the SQL script, works like a charm.

Dieter

SCCM 2007 SP1 with SQL 2008

Fri, 30 Oct 2009 23:07:12 Z

And just so everyone knows, we *do not* support Windows Server 2008 R2 as a site system with Configuration Manager 2007 RTM or SP1. It is only supported as of SP2.

Wally Mead

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

We do now support SQL Server 2008 with both the RTM and SP1 versions of Configuration Manager :-) However, officially yet, we don't support the R2 features with SQL Server 2008. That testing is still under way. SQL Server 2008 is now supported on Configuration Manager 2007 RTM and SP1

SCCM 2007 SP1 with SQL 2008

Site Database Server Prerequisites

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

SCCM 2007 SP1 with SQL 2008

We do now support SQL Server 2008 with both the RTM and SP1 versions of Configuration Manager :-)

However, officially yet, we don't support the R2 features with SQL Server 2008. That testing is still under way.

SQL Server 2008 is now supported on Configuration Manager 2007 RTM and SP1