How to Delete Microsoft SQL Serverby Ryan Menezes
Microsoft's SQL Server provides services to databases, helping them communicate with computers and other programs. The company released the first edition in 1989, and the database server reached version 10.5 in 2010. Professionals such as Robin Dewson, author of "Beginning SQL Server 2008 for Developers," call SQL the best choice in the database marketplace. It costs less that it's top competitors, is user-friendly and features a front-end graphical user interface. When it comes time to delete SQL Server, Microsoft recommends using your control panel's Add or Remove Programs feature. The company also provides detailed instruction to uninstall manually.
Back up stored data, as uninstalling SQL will delete the MSSQL folder and all its contents. Move your databases elsewhere.
Delete local security groups. Go to the "Start" menu and open the "Control Panel." Open "Administrative Tools," "Computer Management" and "Local Users and Groups." Open the "groups" folder. Delete all entries beginning with "SQLServer2008."
Move the "Reporting services" folder from your "Microsoft SQL Server" folder.
Open the "Internet Information Services Manager" from the "Start" menu's "Administrative Tools" section. From the "IIS Manager," delete "ReportServer[$InstanceName]" and "Reports[$InstanceName]". Delete the "ReportServer pool" while still in the "IIS Manager."
Stop SQL Services to sever active connections.
Switch to an administrative account if you haven't already.
Enter "appwiz.cpl" in the "Start" menu's search box. Select "Microsoft SQL Server" from the window that opens and click "uninstall." This launches the SQL Server Installation Wizard. The "Component Selection - Uninstall" page will open.
Click the "report" button. Select a server or shared components to uninstall, and click "next." Review your choice and click "next" to confirm it. Click "finish," and repeat for each component you want to remove.
Items you will need
- Computer running Microsoft Windows
- "Beginning SQL Server 2008 for Developers: From Novice to Professional"; Robin Dewson; 2008
- Microsoft Support: How to uninstall an instance of SQL Server 2008
- laptop with database record on 15.4" wide screen image by .shock from Fotolia.com