John Kaster

Behind the Screen

Archive for the ‘SQL Server’ Category

Fun and games with MSSQL installations

with one comment

After spending a couple minutes scratching my head wondering where my SQL Profiler was for SQL 2008 Standard R2, I did some searching and found out that Microsoft evidently thinks you don’t want a SQL Profiler on a machine that has Visual Studio on it.

The Visual Studio installation also installs SQL Express. There’s lots of samples that are pre-configured to use SQL Express. That’s fine with me.

The headaches come when you want to install SQL Standard or higher on a machine that already has SQL Express installed. The profiler is part of the “Complete” management tools, as explained in this blog post.

Problem is, I couldn’t select “Complete” when I installed SQL Standard, because I already had SQL Express on the machine.

You can’t get there from here

A picture’s worth a thousand bug reports, hopefully. Here’s my confounded picture.

image

What’s the solution? Evidently, it’s wiping out all vestiges of “SQL Server” from my machine in add/remove programs and starting all over. Again. (I’d already had to do this once because SQL 2008 R2 had issues with installing on a different version of SQL server, and SQL 2008 (not R2) can’t install on Windows 7.)

Please, Microsoft – think for a couple seconds about your installation practices for future MS SQL installer releases, and make some appropriate implementation decisions. Thanks.

Written by John Kaster

April 8, 2011 at 9:43 am

Posted in IT Industry, SQL Server