a developer's notes – a semi-technical web development BLOG

September 5, 2011

How to find SQL Instances installed and uninstall SQL Server 2005 Express

Filed under: General Tips — Duy Nguyen @ 2:17 pm
Tags: , , , , , ,

Run this script in Management Studio to find what instances are installed:

http://blogs.msdn.com/b/sqlserverfaq/archive/2009/03/20/how-to-list-all-the-installed-sql-server-on-the-server-using-tsql.aspx

1. In add/remove find Microsoft SQL Server 2005 Express
2. Uninstall
3. Choose Microsoft SQL Server 2005 Express instances
4. If prompted to do so, stop any Microsoft SQL Server 2005 Express services in services.msc

Advertisements

Install order for Visual Studio and SQL Server

Filed under: General Tips — Duy Nguyen @ 1:06 pm
Tags: , , , , , ,

Install SQL Server 2005 BEFORE you install Visual Studio 2005/2008. If you install Visual Studio first, you will have a hard time installing SQL Server because Visual Studio , by default, will install SQL Server Express. And when you try to install SQL Server on top of an existing Express installation, you won’t be able to install SQL Server Management Studio.

Blog at WordPress.com.