I'm running small business server 2008 which comes with SQL 2005.
I just got the full version of SQL 2008 and upgraded successfully (according to the install wizard)
Now I want to install the SQL 2008 Management Studio. I downloaded that from MS and when I click on it it starts the SQL install program. On the 2nd step - Installation - I select "New SQL Server stand-alone installation or add features to an existing installation" but when I go through the steps it fails at the Installation Rules step at "SQL Server 2005 Express Tools" with the message that "The SQL Server 2005 Express Tools are installed. To continue, remove the SQL Server 2005 Express Tools."
I don't understand how that message could come up if I successfully upgraded from 2005 to 2008. So I have 2 questions:
1) Since I upgraded to 2008, is it safe to uninstall 2005? It seems to me running 2 versions of SQL on the same server might be unstable, but then why didn't the upgrade uninstall 2005?
2) Is there another way to get the SQL 2008 Management Studio installed? I must have that.
Thanks in advance for your replies.