Solved

Having trouble installing/running SQL Server Management Studio 2008 Express

Posted on 2011-02-27
3
477 Views
Last Modified: 2013-11-12
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
Comment
Question by:TriCannon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 11

Accepted Solution

by:
louisreeves earned 500 total points
ID: 34992921
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
 

Author Comment

by:TriCannon
ID: 34992930
Thanks a lot.  I will try this and get back to you.
0
 

Author Closing Comment

by:TriCannon
ID: 34993226
I had to uninstall 2005 before I could install 2008.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
GeoClustering  and AOG 25 51
selective rebuild of SQL Tables in scheduled job 10 46
Database-Scoped Permissions 2 40
2008 to 2016 jump (SQL Server) 1 30
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

732 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question