Solved

Having trouble installing/running SQL Server Management Studio 2008 Express

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server Reporting Services Service Start Timeout 4 48
Update in Sql 7 30
DATETIMEOFFSET feature 1 33
today minus 2 years SQL server 2008 2 31
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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 …
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

895 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now