Having trouble installing/running SQL Server Management Studio 2008 Express
Posted on 2011-02-27
I am running Windows 7 Professional 32-bit. I had the following programs installed, if it matters:
- Microsoft Visual Web Developer 2010 Express
- Microsoft SQL Server Management Studio 2005 Express
- Oracle 11g RDMS Enterprise Edition (don't think it matters)
I want to create a website that has a database on the backend. So I created a SQL Server 2008 database on my webspace hosted by GoDaddy. I tried connecting to this database remotely using SQL Server Management Studio 2005 Express from my home computer, but it said that the versions are not compatible. In other words, I need to have SQL Server Management Studio 2008 Express, not 2005 (because it's a 2008 database that I created).
So I downloaded SQL Server Management Studio 2008 Express and installed it, but I do not see it anywhere. I don't know how to run it. I have also installed SP1 for it, as it says to do.
When I go to:
Start -> All Programs -> Microsoft SQL Server 2005, I see the shortcut for Mgmt Studio.
But when I go to:
Start -> All Programs -> Microsoft SQL Server 2008, I do not see the shortcut.
To sum things up, I want to be able to run Microsoft SQL Server Management Studio 2008 Express from my home computer so that I can manage a SQL Server 2008 database created on my GoDaddy (godaddy.com) hosting plan.