I'm not much of a super-user but I've been struggling with this issue for hours and I hope maybe someone here will know how to assist me.
I've just installed
SQL Server 2008 Developer, I've chosen the stand-alone server on the installation options and ran through the wizard without a problem.
I then tried to run the SP2, which I downloaded from here, but I'm failing one test which prevents me from continuing on.
The test is:
"Not clustered or the cluster service is up and online".
When I click on the rule for more information it states:
"The machine is clustered, but the cluster is not online or cannot be accessed from one of its nodes...".
I'm not sure how it came to be that the
clustering service (whatever this might be) is up or that my machine is
clustered because I've installed the stand-alone server.
To verify that I indeed install the stand-alone version, originally, I removed the installation and re-installed it.
Also, it might be relevant to point out that I had at some point in the past
SQL Server 2005 trial and
SQL Server 2008 Express installed on this machine but they were both uninstalled at the time of this installation.
I need the SP2 installation as I have a DB which I backed up on my
2008 Express but I cannot use it now as the
Express was with SP2 (I get a message which says that the DB was created with a newer version).
If there is any additional information which is required please don't hesitate to ask
Update What I ended up doing, as a hack, was to uninstall the developer, reinstall the express and export the db via tasks-export scripts. This included the schema and the data. Then I reinstalled the developer, created my DB, and ran the SQL file.