Monday, March 19, 2012

Installing SQL Server 2005 Express

Hi, I have installed the Visual Web Developer 2005 trial IDE. The installation also came with SQL Server 2005 Express. I have used other versions of SQL Server in the past and have been able to navigate the databases, use Query Analyzer etc.

In the current (SQL Server 2005 Express edition) installation all I have is a program group named "MS SQL Server 2005">"Configuration Tools">"SQL Server Configuration Manager", "SQL Server Error and Usage Reporting" and "SQL Server Surface Area Configuration".

My question is 'Have I not completed the installation?". How do I create databases?

Thanks in advance for your help!

*shiku

SQL Server 2005 Express does not come with Query Analyzer and Enterprise Manager.It's like MSDE. You can create a database from within Visual Studio (see View menu, Server Explorer) or try this download from Microsoft http://www.microsoft.com/downloads/details.aspx?FamilyID=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en (though it's not the final version, it worked fine for me)

No comments:

Post a Comment