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
Estimado simplemente MUCHAS GRACIAS!!!…..habia peliado de una forma!! con esto del VWD y el SQL Server Express 2008……instalado primero el vwd, despues desintalado todo rastro del sql express que viene por defecto y despues instalé el Con los advances services por separado….pese a eso seguia recibiendo una y otra vez el error de que no podia conectarse a la instancia del sqlexpress 2005, cosa que aun no entiendo porke se pide…..pero weno…..lo de upgradear de version como explicaste hizo desaparecer todos esos malditos errores de conexion…
Be sure to uninstall Management Studio 2005 Express, if you have it, before following the five steps outlined above.
I was having a great deal of trouble with this too and although your process managed to get everything on as required I also found that having IIS6 installed helped somewhat in getting SQL talking with VWD. Especially if the user reciving the Website Management tool time-out whilst trying to setup an default login setup.
[…] http://www.arguingwithmyself.com/archives/106-how-to-install-sql-server-2008-express-with-visual-web... […]
Thank you very much. I had the same problem and have been trying and trying for days. Happy I found your link !
Than you very much for this useful information. I’ve been busy for days about this problem. Now it’s solved.
Thank you! I was having this problem with an installation on a Windows VPS and this solution worked perfectly.
Thanks for the tip about the edition upgrade, but that didn’t seem to work either. I ended up having to do that with this exectuable:
https://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en
what a nightmare that all was. Looks like Microsoft is taking after its big brother IBM, where the left hand doesn’t know what the right hand is doing.
Thanks a lot! It was driving me nuts since last 18 hrs.
Thanks!! I can’t belive how hard it was!!
Thanks mate :)