August 23, 2006 08:23 PM

The Disappearance of SQL Server Express

Rating: (0)
SQL Server Magazine
InstantDoc ID #53967

I had SQL Server 2005 Express Edition installed along with Visual Studio 2005. Today, I installed SQL Server 2005 Developer Edition, but installed it as the default instance instead of as a named instance. Probably as a result of that installation, I’ve lost the Express Edition. Is it OK to install SQL Server Express on the same machine as the SQL Server Developer Edition?

Yes, I have them side by side on several machines. Are you sure you lost SQL Server Express? Look in the Administrative tools, Services menu. Typically, SQL Server Express is installed as a named instance called SQLEXPRESS, but you might not see the SQLEXPRESS named instance when SQL Server Management Studio first opens. When you see the instance, you simply need to establish a connection to Database Engine\<server name>SQLExpress.

If you did overwrite your SQL Server Express instance during your installation of the Developer edition, then yes, you can add SQL Server Express as a named instance. Just download the Service Pack 1 (SP1) version at http://www.microsoft.com/sql
—Richard Waymire
Program Manager Architect
Visual Studio Team System

Add a Comment

This happened to me also, on two different machines. I had SQLExpress installed; and the instance name was SQL Express. I installed SQL Server 2005 Developer Edition and the SQLExpress instance vanished. There is no services with the name SQLExpress (The only SQL Server service is now SQLServer), and when I use the SQL Server Configuration Manager, there are no objects named SQLExpress. Finally, my app that pointed to .\\SQLExpress instance now blows up when I try to run it (though I can easily correct it to point at .)

RobKraft3/29/2007 7:39:26 AM


You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS