Wednesday, March 10, 2010

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

clip_image002

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

clip_image004

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.

clip_image006

clip_image008

clip_image010

Select the SQL Server 2008 instance to uninstall.

clip_image012

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

clip_image014

clip_image016

clip_image018

clip_image020

clip_image022

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

0 comments: