I'm starting with ConfigMgr 2012 in the lab and will be building it out with SCSM, SCOM, SCVMM etc as I go along.
For an idea of what's new in SCCM 2012, take a look here:
http://technet.microsoft.com/en-us/library/gg699359.aspx
I'm not going to go into building the DC, except to say that I've created some standard service accounts for use with SCCM.
These are:
SCCMAdmin - SCCM Setup & Admin Account
SCCMNA - Network Access Account
SCCMPush - Push Install Account
Before installing in the lab environment, I used an internet connected machine to download the files that setup tries to download at run time.
In ConfigMgr 2007, these were downloaded using setup.exe /download <pathtostorefiles>
In ConfigMgr 2012, this is now a separate file called SetupDL.exe. Running this will prompt for where to store the files.
Last time I ran it (07/06/2011) it gave me a total of 192Mb in 14 files.
While you've got internet access, now would be a good time to also grab these pre-reqs:
Now that I've got these, it's time to setup the server and install SQL.
Setting up a 2008 R2 server with pre-reqs
SCCM 2012 requires the following components:
- Remote Differential Compression
- Internet Information Services (IIS) - 7.5 & 6 Compatability
- BITS
- WebDAV
- Configure requestFiltering on distribution points
- .NET 3.5 & 4
Use PowerShell to setup .Net 3.5:
import-module servermanager
add-windowsfeature NET-Framework
Install .Net 4.0
<Path to file>\dotNetFx40_Full_x86_x64.exe /passive /norestart
The server features/roles can be easily installed via PowerShell:
add-windowsfeature FS-FileServer,Web-Static-Content,Web-Default-Doc,Web-Dir-Browsing,Web-Http-Errors,Web-Http-Redirect,Web-Asp-Net,Web-Net-Ext,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Http-Logging,Web-Log-Libraries,Web-Request-Monitor,Web-Http-Tracing,Web-Windows-Auth,Web-Filtering,Web-Stat-Compression,Web-Dyn-Compression,Web-Mgmt-Console,Web-Metabase,Web-WMI,BITS-Compact-Server,BITS-IIS-Ext,RDC,RSAT-Web-Server,RSAT-Bits-Server
Reboot Server – a reboot is required before installing SQL
SQL 2008 SP1 CU10 Setup
To make things easier, I've written a quick batch file to automate the setup of SQL 2008, including SP1 and Cumulative Update 10 AND all the required SQL components (Reporting, Integration Services etc)
To make this work, extract the SP1 files to a folder called SQL_Server_2008_SP1 at the same root level as the SQL install files.
Also, extract the CU10 files to a folder called SP1_CU10 at the same level.
Store the batch file at the same root folder level, this should give you a file layout like this:
The batch file basically does the following:
Add two reg entries to stop the OS moaning that SQL 2008 isn't compatible without SP1:
reg add "HKCU\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags" /v {45da5a8b-67b5-4896-86b7-a2e838aee035} /t REG_DWORD /d 4 /f
reg add "HKCU\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags" /v {f2d3ae3a-bfcc-45e2-bf63-178d1db34294} /t REG_DWORD /d 4 /f
Run the SP1 SQL Support files:
start /wait %~dp0SP1_CU10\x64\setup\1033\sqlsupport.msi /QB
Then install SQL 2008, slipstreamed with SP1 & CU10 and all required roles:
%~dp0setup.exe /q /ACTION=Install /ERRORREPORTING=0 /FEATURES=SQL,RS,AS,IS,SSMS,ADV_SSMS,Conn /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="NT AUTHORITY\System" /SQLSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /SQLSVCSTARTUPTYPE=Automatic /AGTSVCACCOUNT="NT AUTHORITY\System" /AGTSVCSTARTUPTYPE=Automatic /RSSVCACCOUNT="NT AUTHORITY\System" /RSSVCSTARTUPTYPE=Automatic /ASSVCACCOUNT="NT AUTHORITY\System" /ASSVCSTARTUPTYPE=Disabled /ASSYSADMINACCOUNTS="BUILTIN\ADMINISTRATORS" /ISSVCACCOUNT="NT AUTHORITY\System" /ISSVCSTARTUPTYPE=Disabled /PCUSource=%~dp0SQL_Server_2008_SP1 /CUSource=%~dp0SP1_CU10
N.B. I've used the %dp0 variable in the batch file so it doesn't matter where the source files or batch file is run from, as long as the batch file is run from the folder with the SQL files.
The batch file can be found here (I've renamed to txt so please rename back to .bat or .cmd)
http://cid-d130da82a6555249.office.live.com/self.aspx/.Public/ConfigMgr%20SQL%202008%20Setup.txt
http://cid-d130da82a6555249.office.live.com/self.aspx/.Public/ConfigMgr%20SQL%202008%20Setup.txt
To save the posts getting too long, I'll pop the SCCM 2012 install into a part 2 post.
No comments:
Post a Comment