Installing a SQL Server 2008 named instance – Windows Server 2008 R2

Run the setup from your SQL Server 2008 CD

Click Installation tab and click New SQL Server Stand Alone installation or add features to an existing installation.

Accept the licensing terms.

Give a name to the SQL Server instance.

i am not going to install this particular instance in mixed mode hence i have selected the windows authentication mode. Setup wont allow you to go to next step unless if you didn't specify a administrator account. I have added the current user credential as one of the administrator account for the SQL Server.

http://support.microsoft.com/kb/955499

http://support.microsoft.com/kb/956173

Uninstalling SQL Server 2008 Instance

please follow the steps mentioned below to uninstall a named instance of a SQL Server 2008. For the reference of others I have published the screen shots to help you guys in some way. Please make sure before uninstalling that none of the SQL services are not used by other applications.

Go to the control panel => Programs => Programs and Features

Browse to SQL Server 2008 and click the Uninstall/Change button above.

Click continue when a prompts comes and make sure that no one is logged into the server.

Click Remove and please follow the screen shots as mentioned below.

Select the SQL Server 2008 instance to uninstall.

Select the features belonging to the instance that you are going to uninstall and keep the shared features.

At the time of uninstallation process I had problem with uninstalling the reporting services and the error was:

"An error has occurred: Access to the path '<Path of perf-ReportServer-rsctr.dll>' is denied"

Please refer this link to resolve the error:

To resolve this issue, close or stop any process or application that may be using the Report Server performance counter, and then try to uninstall Report Server.

http://support.microsoft.com/kb/956173