• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 517
  • Last Modified:

Having trouble installing/running SQL Server Management Studio 2008 Express

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.

Why not?

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.
0
TriCannon
Asked:
TriCannon
  • 2
1 Solution
 
louisreevesCommented:
I think you are running into an old incompatibility with 2005 and 2008. You cant have 2005 SQL management studio installed, if you want to put the 2008 version on. If you have a 2005 databas installed, that is fine. However, you have to remove the 2005 management studio and install SQL 2008 and the 2008 Management studio. The 2008 Managment studio will manage both the 2005 and 2008 intances. HEre is the download.


http://www.microsoft.com/downloads/en/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b


Once all this is out of the way- you ma find yout port 1433 is closed by your ISP.

In SQL Configuration Manager, under SQL Server Network Configuration select Protocols for MSSQLSERVER. Then in the right handed window, right mouse click on TCP/IP and choose Properties. In the IP Address tab, I changed the TCP Port from 1433 to 14430 in all instances. Stop and start the SQL Server service. Note: This turned out to be a reeboot

I hope this helps

L
0
 
TriCannonAuthor Commented:
Thanks a lot.  I will try this and get back to you.
0
 
TriCannonAuthor Commented:
I had to uninstall 2005 before I could install 2008.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now