Solved

Having trouble installing/running SQL Server Management Studio 2008 Express

Posted on 2011-02-27
3
476 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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 …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

735 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