Thursday 14 April 2011

SQL Server Installation Problem

Another day and another install of SQL Server Developer Edition (2005 in this case). Installation complete & there's no way to connect to reporting services or analysis services. Strange, no icons, nothing in the object explorer connection.

Turns out SQL Server Express edition is installed and it is a higher version that I've just tried to install so I am missing the options.

The resolution was to install using SKUUPGRADE = 1 as a startup parameter and then when that install completed I had to refer to an earlier post because management studio was still missing.

Got there in the end.