using System Center 2012 Configuration Manager - Part 1. Installation - CAS

[BewilderedAtTheMoment]

Hello this has been a really excellent feed. But no matter what I do I can not get Configuration manager to get get past the pre-requisites check. As expeted the WSUS warning is their. But there is also the following errors:

 

Firewall exeception for SQL ServerScreenshot of sccm pre-recquisites

 

I am able to connect to the SQL server with SQL server management studio with the Administrator acct that I am using to install SCCM 2012. I am able to browse through all parts of SQL server management studio.

 

The firewall exceptions have been made through active directory for ports 1433 and 4200.

 

SQL Service service running acct. I get the error that "The logon account for the SQL Server service can not be a local user account or LOCAL SERVICE. You must configure the SQL Server service to use a valid Domain acct, NETWORK SERVICE, or LOCAL SYSTEM."

 

 

Lastly I am getting the error SQL Server sysadmin rights. "

Either the user account running Configuration Manager Setup does not have sysadmin SQL Server role permissions on the SQL Server instance selected for site database installation, or the SQL Server instance could not be contacted to verify permissions. Setup cannot continue."

 

 

Also the collation is set correctly to: SQL_Latin1_General_CP1_CI_AS

 

 

 

I am attaching the ConfigMgrPrereq lof file, the ConfigMgrSetup log file and the smstsvc log file.

 

Please help I have rebuilt the server 4 times trying to get this to work.

 

ConfigMgrPrereq.log

ConfigMgrSetup.log

smstsvc.log

 

Please get back to me as soon as you can.

 

Regards,

 

BewilderedAtTheMoment

 

Cheers

[anyweb]

from your ConfigMgrSetup.log

 

"ERROR: The current user does not have administrative rights on computer: SC01.edgeoffice.local. $$<"

 

is the logged on user a domain user and a local administrator of this computer ?

[BewilderedAtTheMoment]

Hi Root Admin,

 

Thanks forgetting on this so fast.

To answer your question "YES" the Domain userscadmin is a member of Domain Admins as well as local administrators group.

 

[BewilderedAtTheMoment]

I have been able to install every other module except Configuration Manager. here is the list that I have installed on the SC01 server. App Controller, Operations manager, VMM, DPM, Orchestrator and Server manager managment server. All of these modules were able to connect to the SQL server and authenticate.

[bogaert91]

Instead of installing SQL on the CAS and the primary site. isn't better to make one SQLserver instead and direct the CAS and the primary towards that Server?

[BewilderedAtTheMoment]

I will install another SQL server with a different instance on another server that I have and se how it goes. Does all the System Center 2012 have to share the same SQL server instance?

[BewilderedAtTheMoment]

I installed SQL server 2008 with SP2 and CU9 on a 2003 R2 SP2 server and the same issues cam back except the WSUS as I installed it on the CAS server.

[Jeff K]

Love the articles, they have helped me so much. now I have been googling around for a way to add the Client install to the local admin group, through GPO instead of logging in to every machine, not much other than restricted groups or scripts. why not use another setting in the GPO?

 

you said: "* ClientInstall, a domain user used when installing the Configuration Manager Client for Client Push. This user must be a local administrator on computers you want to install the Configuration Manager Client."

 

how about doing like this, not sure if you want to add it as a step? it would be faster, except for DC's since they dont have a local admin group. The steps i did i used PSR.exe great tool for these walk-through.

adding a local admin.zip

[anyweb]

thanks, people still do want to do client push though, even if it's the manual option. I will certaintly consider adding this as a step in the next iteration of these guides, thanks !

 

As regards getting the client on the computers i've simplified it even more using Microsoft's best practise method which i describe in detail in Part 5 of this series (linked below).

 

using System Center 2012 Configuration Manager - Part 5. Adding WSUS, Adding the SUP role, deploying the Configuration Manager Client Agent

Part 5. Adding WSUS, Adding the SUP role, deploying the Configuration Manager Client Agent [June 3rd, 2012]

[Iroqouiz]

The SQL memory requirements seem a bit excessive to me. We have a very small environment, maybe 300 machines, tops. Would 3 GB memory be enough to allocate for SQL?