Enjoy Sharing

Error Installing SCCM

Trying to install SCCM with SP1 on a Windows Server 2003 x64 Standard Edition, fails after it has passed the pre-requisite checker and the installation has begun. It failed with the error of not being able to create tables in the database and asks to seek the administrator. Checking the ConfigMgrSetup.log file showed the below lines.

<05-19-2009 15:45:25> ***SqlError: [42000][5847][Microsoft][ODBC SQL Server Driver][SQL Server]Execution of .NET Framework code is disabled. Set "clr enabled" configuration option and restart the server.
<05-19-2009 15:45:25> Error: Could not create assembly file.

This is somehow caused by the CLR being disabled in SQL 2005 (though never happened when installing on a x86 Windows). To enable CLR integration in SQL 2005 using my preferred way is to do it through SQL Server Surface Area Configuration tool.

  • From Start –> Programs –> SQL 2005 –> Configuration tools –> SQL Surface Area Configuration.

CLR1

  • Click with Surface Area Configuration for Features.

CLR2

  • Just click on Enable CLR integration and click Apply and OK.

 

Enjoy!!!

Advertisements

One response

  1. Lean

    Hi sir,I tried this but it does not work. I have already set it to CLR enabled and then click apply then ok. It still does not work after this. Do I still need to restart my computer?Here is my set-up: Windows Server 2008 x64Microsoft SQL Server 2005 SP2 x86Config Manager 2007 SP2 x86All in the same box.Here is the steps I used to install:1. Install Win Server 2008 x642. Make active Directory 2a. Add Role : Active Directory Domain Services (AD DS) 2b. Change computer name 2c. Static IP 2d. Run dcpromoFollowed the steps here: More info: http://www.petri.co.il/installing-active-directory-windows-server-2008.htm3. Install IIS, etc. (Prerequisites to SCCM)I followed the steps here: More info: http://technet.microsoft.com/en-us/library/cc431377.aspx4. Install SQL (named instance: SCCMSQL) (username: SCCM\LEAN pass: P@ssw0rd) Note: Use DEFAULT INSTANCE 4a. Run service pack 2 4b. Run User Provisioning Tool and grant previliges (?) I am not sure if I should run this. I tried running it and assigning, and also not assigning. Both still creates the error above.5. Install ConfigManager Pass the prerequisite check although there are some warnings. I tried doing both Custom Settings and Simple Settings. However, for the prereq check, there is a warning for WSUS andschema extensions. But I think that this is not required.Can you help me figure out my problem? Thank you!!

    May 2, 2010 at 5:17 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s