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: [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.
- Click with Surface Area Configuration for Features.
- Just click on Enable CLR integration and click Apply and OK.