Though this process looks easy but havent had a chance to use this.Recently ,i have upgraded my SQL server 2005 to SQL server 2008.There are different ways that you can do this like taking backup of SQL server 2005 ,uninstall 2005 later install 2008 and restore backed up database.I just simply ran the upgrade advisor to see if it has any DTS jobs and other stuff.So started installing SQL 2008(passed pre requisists) and it prompt me to select the instance name.So tried using the default instance name but failed bcz it used by SQL 2005 .I selected named instance(computername\SQLserver2008).For installing the SQL server 2008 ,use the microsoft guides .The SQL server installation is finished and restore backup done successfully.so thought,i have almost done and started the SCCM console but it failed. But when i open my SCCM console ,it failed in doing so,look the below screen shot.
I forgot to do site maitanance tasks ,so opened the configmgr setup Before doing the SQL server modification ,try to stop all the configuration manager services other you get annouy by clicking ignore option for around more than 15 services 🙂 .To stop all the services ,run the following command in command prompt:
Go to your SCCM server installation folder and locate preinst.exe file ,In my scenario it is E:\SCCM\bin\i3860000409.Once you locate this file,start the cmd with syntax E:\SCCM\bin\i3860000409\ \preinst.exe" /stopsite ,more you can find from http://www.windows-noob.com/forums/index.php?/topic/693-guide-moving-your-site-database/
Verified all the services running or not but found that there are some SQL services which are in not started(SQL server VSS Writer,etc ) .After sometime,tried connecting the console and able to locate the server name.I always keep an eye on site system status to see if there are any issues (most thing to look at).Seen hell lot of errors under component status ,mainly for SMS_MP_control_manager and SMS_collection_evaluator with error message "Microsoft SQL Server reported SQL message 6263, severity 16: [42000][6263][Microsoft][ODBC SQL Server Driver][SQL Server]Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option."
To enable CRL integration in SQL server 2008 ,just run the follwing query in SQL server.By default the common language runtime (CLR) integration feature is turned off, and must be enabled in order to use objects that are coded to use CLR integration.
Open up the SQL server management studio and click on new query
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE;
GO
when you execute this,you will see results looks like below
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
Configuration option 'clr enabled' changed from 0 to 1. Run the RECONFIGURE statement to install.
Just try reset count all messages under site system status to see still if it generates any error messgaes regarding CLR. more information about CLR can be found here http://msdn.microsoft.com/en-us/library/ms131048.aspx