The Disappearance of SQL Server Express

The Disappearance of SQL Server Express

Q: 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

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish