SCE 2007: Configuring on SBS 2003 R2 Premium Edition - SQL Workgroup Edition Needs more work to get running
When I wrote the post about what SQL instance and version should we install SCE 2007 to, I was pretty sure my best practice would be the copy of Express that ships with SCE 2007
I do know that running SCE 2007 on SBS 2003 R2 Premium DOES work with the Express Database that ships with System Center Essentials 2007, and to be honest this really should be good enough given the cap of 75 Devices in SBS 2003 and the number of dedicated SQL Instances that get installed on an SBS Build. So what's one more in the scheme of things?
I have completed a build on the Default Instance of SQL Server 2005 Workgroup Edition which ships with SBS 2003 R2 and all things considered I would always recommend that the Express Instance be used.
That said here are the manual work around's I used which did not need to be done using the Express Instance:
- Install SQL 2005 Workgroup edition according to the SBS Installation Instructions use the version from the web site as the version on the DVD is version 1, (make sure you do not install reporting services);
- Rerun the installation of SQL 2005 Workgroup selecting Reporting Services, (do not configure reporting services);
- Install SQL 2005 Service Pack 2
- Run the Reporting Service Configuration....
I looked at the reporting services configuration as set in the "Express Build" and made it the same for the "Workgroup Build" which I hope you agree we do not recommend. Oh BTW did I mention the SCE Installation does this for you if you choose the SQL Express route.
 | Select the Correct Instance and Click Connect |
 | Click Server Status;
Check the Service Status: is Running |
 | Click Report Server Virtual Directory;
Click New |
 | Select Default Web Site;
Enter ReportServer;
Click OK |
 | Click Report Manager Virtual Directory;
Click New |
 | Select Default Web Site;
Enter Reports;
Click OK |
 | Click Windows Service Identity;
Click Built-in Account;
Select Local System |
 | Select Web Service Identity;
Press New next to Report Server;
Repeat for Report Manger |
 | Enter ReportServer or ReportManager in the application pool name;
Select Built-in Account and select Local System |
 | Click Database Setup;
Select the SBS Server Name and click Connect;
Select ReportServer from the list of Databases;
Select Service Credentials from the list
Click Apply |
 | Click Email Settings;
Enter and address for the Sender Address ie Reports@smemanaged.com;
Enter the SMTP Server details |
 | Click Execution Account;
The default is domain\administrator (however I suggest some effort be taken to find a least privilege alternative) |
Install SCE 2007 IAW Installing System Center Essentials in SBS 2003 R2 Standard Edition
In the section that covers the removal of the SSL Certificates the following procedure should be followed instead, if the SSL Port remains configured SCE 2007 Install will report un-configured Reporting Services.
| 
| Select the Default web and Right Click Properties |
 | Click Advanced |
 | Select the SSL Address and Click Remove;
Click OK |
| 
| Select the Directory Security Tab;
Click Server Certificate |
 | Click Next > |
 | Click Remove the current certificate;
Click Next > |
 | Click Next > |
 | Click Finish |
Return to the installation
When complete reverse this procedure