Solved

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

Posted on 2010-08-13
6
407 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
  • 3
  • 2
6 Comments
 
LVL 19

Expert Comment

by:amenkes
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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
In this article I will describe the Detach & Attach 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.
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 …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

867 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

25 Experts available now in Live!

Get 1:1 Help Now