H Kent, Can you be bit specific? I used the domain administrator account, do I need to go the SQL server and give the administrator account SYSadmin rights? how? is there any instructions? sorry I am new to SQL server! Also when I added the SCCM machine to the Administrators group in AD and when I try to add the sccm machine to the local Administrators group it says the machine is already in the Administrators group. Thx

Yes, you need to do that: http://blog.sqlauthority.com/2008/12/27/sql-server-add-any-user-to-sysadmin-role-add-users-to-system-roles/. Being a domain admin has nothing to do with SQL Server; domain admins are for domains. Note that with certain older combinations of Windows Server 2003 and SQL Server, domain admins were automatically added to the sysadmin role in SQL Server, but this is no longer the case with Windows Server 2008.Jason | http://myitforum.com/cs2/blogs/jsandys | Twitter @JasonSandys

I followed the link and I used Method 2: SQL Server Management Studio. I am getting the following errors: SQLServer sysadmin rights: Either the user account running Configuration Manager Setup does not have sysadmin SQL Server role permissions on the SQL Server instance targeted for site database installation or the SQL Server instance could not be contacted to verify permissions. Setup cannot continue. Domain membership: Configuration Manager site server components can only be installed on computers that are members of a Windows domain. Short File Name 8.3 support (site system): Setup either could not verify that short file name (8.3) support is enabled on the computer specified for site system installation or the server could not be contacted to determine short file name support information. No further prerequisite checking rules can be evaluated on the specified system. Setup cannot continue. Please guys I am burning so much time on this

First I created an OU container called “AdminGroup” and I added 2 groups “SCCM-Admins” and “SQL-Admins” , I crated 2 accounts “sccmadmin” and “sqladmin” in “Service Managed Accounts” counter. I add both user accounts to both groups, So I added “sccmadmin” to SCCM-Admins” group and I added “sqladmin” to ” SQL-Admins” group. Also I added both groups to the “Domain Admins” group and “Administratros” group. When I logged in to the SCCM machine with “sccmadmin” account I can’t run install anything it keeps telling me I do not have permission so I gave up I logged in as Domain Aministrator user account and when I installed the SQL server during the installation I have to entered the credential I want use the domain user “sqladmin” and it bouncing back with error saying no mapping between the user and I can’t remember the exact error, if I use the Domain Administrator it works but when I was trying to install the SCCM and I run the prerequisite there are 3 errors: Configuration manager site server can only be installed on computer that are members of windows domain. Setup either could not verify that short file name (8.3) support is enabled on the computer specified for site system installation or the server not be contacted to determine short file name support information …….. SQL does not ’t have sysadmin. So I just want be able: Log in with domain user account “sccmadmin” Is there any instruction for setting SQL server? I think I need some accounts within SLQ server in order to resolve the issues. Setup SLQ Reporting Services? Here are the steps: Extend the Active Directory Schema Follow the path to: %Cd-rom%\Z:\SMSSETUP\BIN\I386 In this location you will find the file: EXTADSCH.exe I check the C:\ ExtADSch.log If the actions was succesfull the .log file should contain the lines: Succesfully extended the Active Directory Schema Create the Systems Management Container in Active Directory For creating the System Management Container I logged on to an Active Directory Domain Controller On a Domain Controller open the ADSI Edit snap-in Browse to the following location: Domain\DC\CN=System Right click the container “System” and select the option System\New\Object Container then Enter the following values: System Management Permissions on the System Management Container Open the “Active Directory Users and Computers” snap-in. Open the “System” Ou and browse to “System Management” Rightclick the “System Management” container and select the option: Properties: Select the tab “Security” Add "SCCM" machine and "sccmadmin" user. Give them full Permission: This object and all descendant objects. Installation of Windows Server 2008 feature Remote Differential Compression Select the "Features” option. Click on à Add Features: Remote Differential Compression Installation of the WebDAV extensions for IIS Installation of Windows Server 2008 BITS Extensions feature I follow the following URL: http://maijen.nl/index.php?option=com_content&view=article&id=70:sccm-2007-r2-installation-in-windows-server-2008-sccm-installation&catid=31:microsoft-sccm&Itemid=64 http://www.ahmedgroup.co.uk/articles/47/1/Step-by-step-guide-installing-SCCM-2007-Part-1/Page1.html Thanks for your helps.

you need to ensure that the user account has SYSadmin rights on the SQL box and that the ConfigMgr. site server is a member of the local administrator group on the SQL box. But what you are writing it do not sound like the local administrator group has SYSadmin rights.Kent Agerlund | My blogs: http://blog.coretech.dk/author/kea/ and http://scug.dk/ | Twitter @Agerlund | Linkedin: /kentagerlund

Also, you can get more details about permission from the below technet article Checklist for Configuration Manager Account SecurityAnoop C Nair - Twitter @anoopmannur MY BLOG: http://anoopmannur.wordpress.com SCCM Professionals This posting is provided AS-IS with no warranties/guarantees and confers no rights.