Installation of Secondary Site in Configmgr SCCM 2012 is not as simple as compared to SCCM 2007 due to several changes in SCCM Configmgr 2012 secondary site.
Before you proceed to install the secondary site,you need to ensure all the prerequisites are met including SQL server installation,IIS etc else you may have to come back to finish all the required prereq.
In My previous blog post here, i listed down the prerequisites to install secondary site. Below is little more descriptive:
Install IIS, BITS, RDC,.net framework 3.5
Add Primary site computer Account and secondary site(which you are going to install on) as member of local administrators group on secondary site server.
Add secondary site computer computers as member of sitesystem-to-siteserver connection group in Primary Site.
Install SQL server 2008 R2 SP1 Express with Cumulative Update 6 or above. Please refer to MS for more information about SQL server. http://technet.microsoft.com/en-us/library/gg682077.aspx#BKMK_SupConfigSQLSrvReq
I installed SQL server 2008 R2 SP1 Express with CU6 using default instance. Database Collation: SQL_Latin1_General_CP1_CI_AS.
check if the SQL server agent is not disabled and set to automatic and log on as ' local system account'.
Installation is straight forward without any special settings.
To know more about how to install SQL server, you can either refer my previous blog post here or Internet search will provide you lot of articles.
Once you are done with installation of SQL Server and CU, you will have to enable/configure couple of things.
1. Check if you SQL server service is not running in network account (should be either domain account or local system account) and set to automatic.
2. Enable TCP/IP Protocol with Port:1433 in IPALL for Dynamic Port as blank and TCPIP as 1433 . How do to this ?
Open SQL Server Configuration Manager
Move onto SQL Server Network Configuration-->Protocols for SQLExpress
Enable TCP/IP and Named Pipes
Also check if you have set the TCP port as Static with port number 1433 for all else you will not succeed with installation of Secondary site.
Now Restart the SQL server Service to make changes into effective.
We are now done with all the prereq needed to install Secondary Site.
Go back to your Primary Site administration node and start the installation of secondary site by selecting the right Primary site.
Sitecode,site name and where do you want to install SCCM.
Since I have already installed SQL server Express 2008 Version with Default instance on the server manually with required Cumulative Updates with Database Location etc.I leave instance as blank.If you have used other than default,Please specify it.
Click next ,Next and close.
Now we will monitor the progress of site Installation.
Once the prerequisites check list is completed, Primary site will start copying the required files for sccm installation on to secondary site installation drive with extension .pkg which will be decompressed to .tmp folder before the installation starts.
Monitor sender.log on the primary site to see the progress of .PKG File
sending the package file is completed.
Go back to your secondary site and see what is it doing ?
You can see couple of files with extension .INI and .log
Look at .ini file with site information like Site name, Primary site, Installation Drive etc.
You may not be able to open the .ini file due to permission issues but try to copy to desktop/different folder to view the content on it.
Watch out for the installation/Errors either from console or log located in Primary site Root folder C:\configmgrsetup.log
You see from above,The installation is Completed successfully.