Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Having trouble installing/running SQL Server Management Studio 2008 Express

Posted on 2011-02-27
3
Medium Priority
?
500 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 1500 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

Independent Software Vendors: 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

Regular maintenance of GroupWise Mailbox keeps it running flawlessly. Sometimes, it is also seen that mailbox maintenance is needed for resolving various issues of mailbox and other Novell GroupWise database. By using the ‘Repair Mailbox’ feature, a…
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 …
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…

705 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