SCCM 2012 SP2

[cpjitservices]

Hi everyone,

 

Struggling a bit trying to get SCCM 2012 SP2 to install, I cant for the life of me get past Pre Req checks.

 

Ive installed SQL 2012, its up to date. Im a noob when it comes to SQL - not really had a lot to do with it.

 

Looking at some of the guides on the internet I cant seem to find a good one, seem to be bits missing.

 

I am failing at one pre req, sysadmin has not go the right to access SQL or something along those lines, Ive tried a lot of options here. Been in services and have changed to local account and domain account and no difference when running re-check. Have also been into SQL Studio and added new login and added a domain user with admin provs to no success. Ive ended up with 4 different instances of SQL so have started the removal process and will begin again from the beginning.

 

I was hoping SQL Express could be used but seems not ?

 

Anyone got a definitive FULL guide ?

 

 

 

Thanks in advance.

 

Kind Regards.

[Norphy]

SQL Express definitely can not be used. The SQL requirements aren't all that extensive, the only thing you have to be careful about is the default collation of the database server. Make sure it's set to SQL_Latin1_General_CP1_CI_AS. If the SQL server lives on the same server as the management point, it should be able to run as the local system user; if not it'll need a domain user. If the SQL and SCCM are going to live on the same box, make sure it has plenty of RAM (16GB minimum) and that you restrict the amount of RAM that SQL uses to 8GB minimum and 12GB maximum.

 

I also know that SCOM is fussy about the version of SQL that you're using as well. I haven't tried anything newer with SCCM but I'd stick with SQL 2012 for the moment, just to be safe.

Edited December 1, 2015 by Norphy

[altecsole]

On my original SCCM setup I installed SQL 2008, but the process should be the same.

 

Set your sysadmin account as a member of the Local Administrators group.

 

Open an elevated cmd prompt and CD to the drive with the ISO image.

Run the following command to install (SQL 2008):

setup.exe /q /ACTION=Install /ERRORREPORTING="False" /FEATURES=SQLENGINE,RS,AS,IS,SSMS,TOOLS,BIDS,ADV_SSMS,CONN /INSTANCENAME=MSSQLSERVER /INSTANCEDIR="C:\Program Files\Microsoft SQL Server" /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 /ASCOLLATION="Latin1_General_CI_AS" /SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS" /TCPENABLED="1" /NPENABLED="1" /IAcceptSQLServerLicenseTerms

 

Run SQL Server Management Studio as Administrator and add your sysadmin to the list of Logins (Security -> Logins). Change Server Roles for this user to public and sysadmin. You should now be able to close SQL Server Management Studio and login as your sysadmin.

[cpjitservices]

Thanks Ill give that a go @altecsole

 

My server is a 6 core Intel Xeon with 24GB Ram so should be beefy enough.

[cpjitservices]

On my original SCCM setup I installed SQL 2008, but the process should be the same.

 

Set your sysadmin account as a member of the Local Administrators group.

 

Open an elevated cmd prompt and CD to the drive with the ISO image.

Run the following command to install (SQL 2008):

setup.exe /q /ACTION=Install /ERRORREPORTING="False" /FEATURES=SQLENGINE,RS,AS,IS,SSMS,TOOLS,BIDS,ADV_SSMS,CONN /INSTANCENAME=MSSQLSERVER /INSTANCEDIR="C:\Program Files\Microsoft SQL Server" /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 /ASCOLLATION="Latin1_General_CI_AS" /SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS" /TCPENABLED="1" /NPENABLED="1" /IAcceptSQLServerLicenseTerms

 

Run SQL Server Management Studio as Administrator and add your sysadmin to the list of Logins (Security -> Logins). Change Server Roles for this user to public and sysadmin. You should now be able to close SQL Server Management Studio and login as your sysadmin.

 

I tried your command, I think it must be different on SQL 2012.

 

I have a failure.

 

The following error occurred:

'SQLENGINE,RS,AS,IS,SSMS,TOOLS,BIDS,ADV_SS' is not a valid value for setting 'FE

ATURES'. Refer to Help for more information.

 

Error result: -2068578302

Result facility code: 1204

Result error code: 2

[Norphy]

You don't need most of those features to get ConfigMgr installed. You definitely don't need integration services or analysis services and you don't need reporting services if you don't have a reporting point. Just use SQLENGINE, SSMS and ADV_SSMS Edited December 1, 2015 by Norphy

[cpjitservices]

You don't need most of those features to get ConfigMgr installed. You definitely don't need integration services or analysis services and you don't need reporting services if you don't have a reporting point.

 

Ill give that a blast... Thanks

[cpjitservices]

OK next errors after running that command:

 

memory Settings need setting (min * max)

Wrong version of SQL detected - may need updates

[Norphy]

The first should just be a warning. You will need to open SQL Management Studio and set the limits.

 

The second is a bit more mysterious. Which version of SQL have you put on there? Standard? Enterprise? Latest service pack?