How to install SQL Server 2008 Express with Visual Web Developer 2008 Express
I’m sure this information is already all over the place, but I couldn’t find a straightforward anwser with a simple search.
How do I get to the Management Studio after installing SQL Server with VWD 2008 Express?
Here’s the situation. I just installed Visual Web Developer 2008 Express, and checked the SQL Server box to install that too. The installation went smoothly, but I could find any tools for actually using SQL. 3 links were added to my start menu under Microsoft SQL Server 2008 -> Configuration Tools: SQL Server Configuration Manager, SQL Server Error and Usage Reporting, and SQL Server Installation Center.
None of them were what I wanted. I tried the installation center, which had an option to add features, but it didn’t give me any features to add.
So I decided to download and install SQL Server separately. It comes in 3 flavors - basic, with tools, and advanced. Naturally I chose advanced, because I didn’t want to miss out on anything I might need.
When I run it, it looks just like the installation center I already have. I tried installing a new instance, but it said I already had one. I tried repairing and adding features, but it didn’t let me add anything. Finally, I found Edition Update, under the Maintenance section.
When I tried it it seemed to upgrade to the “advanced” version I downloaded. Appearantly, installing SQL Server with Visual Web Developer installs only the most basic version, and the tool I needed are only available in the more advanced versions. Once that finished, I was able to go back to the “add features” option and add all the tools, which filled my start menu with another half-dozen links.
So, with everything said and done, here’s a quick step-by-step:
- Download VWD 2008
- Install VWD with SQL Server
- Download SQL Server 2008 with Advanced Services
- Run and go to the Maintenance section, then select Edition Upgrade
- After the upgrade is finished, go to the Installation section, then select New SQL Server stand-alone installation or add features to an existing installation