SQL Server 2008 with SCCM 2007

[shevary]

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:

1. Configuration manager site server can only be installed on computer that are members of windows domain.
   
2. 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 ……..
   
3. 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.

[Prajwal Desai]

looks like SQl server is not installed properly, but very strange message " Configuration manager site server can only be installed on computer that are members of windows domain" . Also check the firewall if you have enabled the SQL communication ports.

Ports : 1433. create an inbound and outbound rule in server and allow the communication.

[shevary]

I disabled the Firewall and the SLQ server is already member of windows domain, I am getting the following errors:

 

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.

 

Configuration Manager site server components can only be installed on computers that are members of a 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 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.

 

thx

[Nzastudios]

Make sure you add the sccmadmin account to Local Admin group on that server where you trying to install, and also in network operators. Also ensure the OU you created is not inheriting policies that might prevent your new sccadmin account from doing what it should do.

 

Also check eventvwr on the server you trying to install on.

[Prajwal Desai]

can you tell me which edition of the SQL server is this ???