Friday, March 23, 2012

Installing SQL Server Management Studio over Express

I just got a new machine with Vista on it. It also came with SQL Server 2005 Express.

How do I install SQL Server Management Console on this machine? I do have an MSDN DVD with a Developer's Edition on it. Can I use this somehow? When I try to run the Tools setup.exe with SKUUPGRADE=1, it tells me there is nothing to upgrade.

Is there a separate download somewhere?

Brian

I would uninstall Express and install the Developer Edition. Express doesn't have alot of stuff and Developer is the equivalent of the Enterprise Edition (but obviously can't be used in production). For instance, some features you can't use with Express is SSIS (which is the new generation DTS) and SQL Profiler.

Like you, I initially had Express installed, but the above is what I did and it wasn't a problem to uninstall and reinstall.

No comments:

Post a Comment