Solved

installed sql server 2008 - now 2005 management studio doesn't work

Posted on 2010-08-13
6
421 Views
Last Modified: 2012-05-10
I installed visual webdeveloper on my server, however it put on sql server 2008

now when i try and connect to 2005 managment studio express , it fails and says it can't be used:

This version of Microsoft SQL Server Management Studio Express can only be used to connect to SQL Server 2000 and SQL Server 2005 servers. (Microsoft.SqlServer.Express.ConnectionDlg)

Ideally i want to keep, visual web developer on the server, but remove sql 2008

the site is running live sites so i have to be careful, can i remove 2008 and it still work ok
if so how, as i dont see any options on removing it!

0
Comment
Question by:websss
[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
  • 3
  • 2
6 Comments
 
LVL 19

Expert Comment

by:Adam Menkes
ID: 33429084
You can use 2008 management studio to connect to 2005 databases.
0
 
LVL 8

Expert Comment

by:Yiogi
ID: 33429137
SQL Management studio 2005 can only see versions up to 2005. You can connect to older versions but not newer ones.

You can download Management Studio Express 2008 for free and use that as a centralized management for all your previous versions of SQL Server up to and including 2008. For the full management studio you cannot use the express edition but you have to use the one that comes with the SQL Server installation files.

I personally love the 2008 auto-complete features so I would recommend this.
0
 

Author Comment

by:websss
ID: 33429177
thanks
i did download 2008 management studio, but it came up with lots of options about sql 2008 and none of them said anything about management studio

where do i look?
0
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 

Author Comment

by:websss
ID: 33429192
it comes up with "SQL Server Installation Centre"


0
 

Author Comment

by:websss
ID: 33429373
I've made some progress but i'm getting issues on the server and locally

i want to play it safe and roll back to sql 2005 however, it doesn't look like there is an option to do this

how would i do this?
0
 
LVL 8

Accepted Solution

by:
Yiogi earned 500 total points
ID: 33433915
there is no way to downgrade your SQL Server. The only way would be to uninstall 2008 and reinstall 2005 and restore your database backups but of course you will lose whatever data you have inserted since. A second way to not lose data would be to script everything including data and again uninstall and install 2005 but I wouldn't recommend this either as you can't be sure everything will work.

I don't see where you are having trouble with 2008. It's better than 2005 in terms of performance and Management Studio 2008 can connect to any of the older instances. This is a link to SQL 2008 Management Studio Express:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&familyid=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b

0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

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.
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

617 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