Installing SQL Server 2012 for Configuration Manager 2012 R2PrajwalDesai.Com.pdf

(4110 KB) Pobierz
Installing SQL Server 2012 for Configuration Manager 2012 R2PrajwalDesai.Com
Brand New Forums
Click here to register!
X
BLOG
Installing SQL Server 2012 for Configuration Manager 2012
R2
November 28, 2013
SCCM, Windows Server 2012
Facebook
Twitter
Google+
Pinterest
LinkedIn
E-mail
In this post we will be looking at the steps for Installing SQL Server 2012 for Configuration Manager
2012 R2. In this deployment series of Configuration Manager 2012 R2 we started with
system center
2012 R2 Configuration Manager system requirements
which tells more about the new features of
SCCM 2012 R2 and system requirements for Configuration Manager 2012 R2, in the next post we
saw the steps for
installing prerequisites for SCCM 2012 R2.
After installing prerequisites the next step
is to install SQL server. Most of the users have a question on where should the SQL server be
installed, should it be installed locally on the server where SCCM is installed or on a remote server ?.
The answer is you can install it on local server or host the database on remote server. I would prefer
to install SQL locally because this it requires less administrative overhead, the license for SQL is
included with System Center so no additional license needs to be purchased and with local SQL you
can achieve better performance than remote. In this post we will be installing SQL server 2012 with
SP1 on windows server 2012 R2, if you have only SQL server 2012 iso copy, you can download the
SQL server 2012 service pack 1 and install it.
DOWNLOAD MICROSOFT SQL SERVER 2012 WITH SP1
DOWNLOAD MICROSOFT SQL SERVER 2012 R2 SERVICE PACK 1
http://prajwaldesai.com/installing-sql-server-2012-for-configuration-manager-2012-r2/[11/30/2013 12:39:32 AM]
Installing SQL Server 2012 for Configuration Manager 2012 R2PrajwalDesai.Com
For System Center 2012 R2 Configuration Manager you can install the SQL server with combinations
:-
1)
Install SQL Server 2012 + Min Cumulative Update 2
2)
Install SQL Server 2012 + Service Pack 1 [no cumulative update required]
3)
Install SQL Server 2012 with Service Pack 1 [no cumulative update required]
If you are planning to use SQL server other than 2012 then click here to see the
SQL Server
Requirements for Configuration Manager 2012 R2.
Installing SQL Server 2012 for Configuration Manager 2012
R2
So lets look at the steps to install SQL Server 2012 with SP1. I have mounted the DVD on to the
Windows Server 2012 R2, open the SQL server folder, run the setup as
administrator.
Click on
Installation
and click on
New SQL server standalone installation.
http://prajwaldesai.com/installing-sql-server-2012-for-configuration-manager-2012-r2/[11/30/2013 12:39:32 AM]
Installing SQL Server 2012 for Configuration Manager 2012 R2PrajwalDesai.Com
Click
OK
once the Setup support rules are run and verified.
http://prajwaldesai.com/installing-sql-server-2012-for-configuration-manager-2012-r2/[11/30/2013 12:39:32 AM]
Installing SQL Server 2012 for Configuration Manager 2012 R2PrajwalDesai.Com
Check the box for
I accept the license terms
and click on
Next.
http://prajwaldesai.com/installing-sql-server-2012-for-configuration-manager-2012-r2/[11/30/2013 12:39:32 AM]
Installing SQL Server 2012 for Configuration Manager 2012 R2PrajwalDesai.Com
After the Setup Support Rules are completed click on
Next.
http://prajwaldesai.com/installing-sql-server-2012-for-configuration-manager-2012-r2/[11/30/2013 12:39:32 AM]
Zgłoś jeśli naruszono regulamin