Saturday, October 04, 2008 11:07 AM Brian S. Tucker

SCCM 2007 & SQL 2008

While I recently stated that using SQL 2008 with SCCM was a 'no-no", I did some testing and came up with some interesting information. I will share this info in greater detail as I redo what I did to verify the steps. However, I built a pure Server 2008 domain (every server is 2008) and added a SCCM box. I installed SQL 2005 WITH SP1 and then ran R2. Since R2 requires Reporting Services and RS being configured, I made the required configurations to RS and everything was running great. Now, WebDAV on 2008 is a whole ball of wax an I will be making a video to walk you through all the configurations as they are not straight forward.

Once I had every thing installed, I added the proper KB hotfix (there are 2. One for RTM and one if you are running SP1) and it installed without issue. I then upgraded to SQL 2008 and it's been running nonstop for 3 days without any issues. I wanted to simply point out that since MSFT had released the hotfixes, I was skeptical about the upgrade, but had to test it to see for myself. If I see any issues with SQL 2008, I will be sure to let you know, but for now, it seems to be fully functional, Even with WSUS 3.0 SP1 on the servers DB and reporting services.

Share this post:                                       
Filed under: , , , , ,

Comments

# re: SCCM 2007 & SQL 2008

Monday, October 03, 2011 8:43 AM by Kianna

The work with this program is very difficult. You need to learn a lot for doing some things there.