Wednesday, September 23, 2009

Remove SQL2005 and Reporting Service

These few days I try to remove a previous installed SQL2005 (with reporting service) and then re-install a new instance of SQL2005 (with reporting service) again in the same server. Below are several items which needed to noted for proper installation:

1. Check "Services" by using features of "Administration", need to stop all services of "SQL XXX"

2. Use "Add/Remove" function to remove SQL2005 from the Server

3. Within IIS, delete those entries related to "Reporting Service" in the application pool

4. Check sub-directories of "C:\program Files\Microsft SQL Server", either rename or delete those directores related to "Reporting Service".

Can find more information from this URL: http://support.microsoft.com/kb/909967/en-us

No comments: