Installing SQL Server 2012 SP1 Standard for System Center 2012
This post consists of:
- Setting up Users in Active Directory for installing
- Installation of SQL Server 2012 SP1
- Setting SQL Server Communication Ports
Moved: Configuring SQL Server 2012 SP1 for System Center 2012 R2 :: Setting SQL Server Communication Ports
Setting up Users in Active Directory for installing
- First I’m going to create a new OU in the root of my AD named SQLSCC where I am going to create my users.
- In this OU we create the two users we are going to use for running SQL for SCCM and the Global SQLGroup Security Group.
Below is all the users we are going to need. They should all be member for the SQL Group.
- SCCMServiceAndAccess needs to be added to the local administrators Group on the server running System Manager 2012.
Installation of SQL Server 2012 SP1
Insert the DVD and run setup.exe from there, use auto play or run setup.exe (if you downloaded the files). The setup program will start. I’m not going to fill this up with unnecessary screenshots, so I’ll gloss over the bits that aren’t interesting in bullet points.
- In the SQL Server Installation Center, choose the Installation menu, and then select a ‘New installation or add features to an existing installation’. From here I can set up SQL Server failover clusters and cluster nodes too.
- The Setup Support Rules runs first; everything should be fine here with no errors reported.
- Enter your product key next, or choose to run as an evaluation (you can change to a paid product later if you wish).
- Accept the license terms if you want to get any further.
- Allow the Setup Support Files to install.
- The Setup Support Rules will run, and all going well you shouldn’t have any errors.
Note: I’ve made a post in order to Setup Firewall for SQL
- Make sure the appropriate ports are open to enable remote access in you firewall as needed. http://msdn.microsoft.com/da-dk/library/cc646023.aspx
- Now we get to choose whether to install as ‘SQL Server Features Installation’ or ‘All Features With Default‘. As I don’t want all the features and because I want to be able to set service accounts and collation, I choose the first option ‘SQL Server Feature Installation’.
- I select the features I want in this installation from the ‘Feature Selection’ screen. I want to install the Database Engine Services as well as the sub-feature Full-Text Sematic Extractions for Search (as SCCM needs that to install).
I also select “Reporting Services – Native” as “DataProtection Mgr Server” will need that one.
I select to install the Management Tools-Basic too (note that Management Tools-Complete also gets checked).We can change where the features gets installed, but I recommend keeping it as default.
- Now, I’m just keeping it at Default instance. I’ve had some issues with the Reporting Services and Endpoint Protection when setting it up manually, so I’ve started doing it this way.
- In the Server Configuration we choose the Accounts we made earlier for SQL Server Agent, SQL Server Database Engine and SQL Server Reporting Services..
Input Password and set Startup Type to Automatic. Dont’ press next as you need to modify Collation.
- Click the Collation tab, hit Customize…
Under SQL collation, used for backwards compatibility you choose “SQL_Latin1_General_CP1_CI_AS“Press OK and Next >
- Database Engine Configurationtab 1)
Server Configuration tab
Authentication mode: Mixed Mode write a password of your choice (strong)
Specify SQL Server administrators:
Add… and select the SQLsvrDBEngine user we created at the beginning.
Also press the Add Current User button to add the current logged on user as a SQL Server administrator if needed.
Database Engine Configuration (tab 2)
Click Data Directories tab and change the directories if required. These options will locate the database data files wherever you specify, this could be on another partition or disk.
I’m using defaults. Next
- Choose Install and configure. This will save you a lot of hassle regarding the SQL Reporting Service.
- Next, Next, Review Configuration Rules.
- Verify the features to be installed and click Install.
- Sit back and wait.
- Review and press Close.
- Now you should update your installation before proceeding.