Solved

SQL upgrade question

Posted on 2010-09-13
16
255 Views
Last Modified: 2012-05-10
I'm running small business server 2008 which comes with SQL 2005.

I just got the full version of SQL 2008 and upgraded successfully (according to the install wizard)

Now I want to install the SQL 2008 Management Studio.  I downloaded that from MS and when I click on it it starts the SQL install program.  On the 2nd step - Installation - I select "New SQL Server stand-alone installation or add features to an existing installation" but when I go through the steps it fails at the Installation Rules step  at "SQL Server 2005 Express Tools" with the message that "The SQL Server 2005 Express Tools are installed.  To continue, remove the SQL Server 2005 Express Tools."

I don't understand how that message could come up if I successfully upgraded from 2005 to 2008.  So I have 2 questions:

1) Since I upgraded to 2008, is it safe to uninstall 2005?  It seems to me running 2 versions of SQL on the same server might be unstable, but then why didn't the upgrade uninstall 2005?

2) Is there another way to get the SQL 2008 Management Studio installed?  I must have that.

Thanks in advance for your replies.
0
Comment
Question by:visionarys
  • 9
  • 7
16 Comments
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 33665604
Depending on how you installed 2005 (assuming express), the tools were likely installed separately.  So what happened is that the DB engine was upgraded but your tools were not.  You need to uninstall the SQL 2005 Express tools and install the 2008.

To install management studio in 2008, go to add/remove programs, find SQL 2008 and right click > uninstall/change.  Then go through and choose the add features option and add client tools.
0
 

Author Comment

by:visionarys
ID: 33666340
I didn't install SQL 2005, it came built-in with the SBS 2008 Server install.

I know I need to uninstall the 2005 (not Express) tools but what I don't understand is why 2005 is still there at all if I successfully upgraded to 2008.  

Also, in Programs and Features, I don't have SQL 2008.  I have "Microsoft SQL 2008 Setup Support Files" and "Microsoft SQL Upgrade Advisor."  Do I need to reboot the server to get the SQL 2008 to show up there?  If I upgraded sucessfully (as the upgrade wizard told me - there were no errors) then why doesn't what you're describing appear there?
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 33666375
You should attach to your instance and run the following to see what you are actually running.


SELECT @@VERSION

10.5 = 2008 R2
10.x = 2008
9.x = 2005
8.x = 2000
0
 

Author Comment

by:visionarys
ID: 33666399
How do I attach to my instance?  I hate to sound dumb but I'm no SQL expert, not by a long shot.  That's why I'm getting help here.

Thanks.
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 33666407
Run SQL Server Management Studio and open a new query window to the database server.
0
 

Author Comment

by:visionarys
ID: 33666453
I only have SQL Server Management Studio 2005.  Part of what I'm trying to do is get the 2008 Management Studio installed.

When I open a new querry it says 9.0 SP2, so does that mean it didn't actually upgrade even though it told me it did?
0
 

Author Comment

by:visionarys
ID: 33666477
I could blow away SQL 2005 and install 2008 clean, but the SBSMONITORING is using 2005 and isn't that what runs sharepoint?  I don't want to mess that up, but I need to be running SQL 2008
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 33666557
>> When I open a new querry it says 9.0 SP2, so does that mean it didn't actually upgrade even though it told me it did?

Yes


>> I could blow away SQL 2005 and install 2008 clean, but the SBSMONITORING is using 2005 and isn't that what runs sharepoint?  I don't want to mess that up, but I need to be running SQL 2008

Can you be sure that your software is compatible with 2008?
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:visionarys
ID: 33666613
Which software?  I have a 3rd party program that is compatible with 2008 and I need to restore the db from a 2008 .bak file.

Or do you mean the software that came built into the sbserver?
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 33666718
Both I guess.  Usually it is a bad idea to do an in-place upgrade of SQL 2005 to 2008.  It is best to stand up a new 2008 server then migrate to it.  The reason is that you have no rollback plan in the event of an upgrade, or other, failure.
0
 

Author Comment

by:visionarys
ID: 33666743
What about having both on 1 server?
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 33666772
You can run multiple instances as long as you have a license.  If you bought an upgrade license of 2008, then you can't continue to use 2005.
0
 

Author Comment

by:visionarys
ID: 33666796
I have a full license for 2008 but when I tried to install a standalone I got the error about the 2005 tools
0
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 500 total points
ID: 33666803
Well you can always for 2005 use the add/remove programs to remove the 2005 tools, then install full 2008.
0
 

Author Comment

by:visionarys
ID: 33666810
Ok I'll try that and let you know what happens.  Thanks.
0
 

Author Closing Comment

by:visionarys
ID: 33674142
This worked - thanks a lot!
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

758 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

21 Experts available now in Live!

Get 1:1 Help Now