[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SQL Express install/upgrade?

Posted on 2011-03-10
3
Medium Priority
?
268 Views
Last Modified: 2012-06-27
On a server it looks like I have SQL 2000 and SQL 2005 installed.  I was asked by a software vendor to install SQL 2005 Express on the server.  From the looks of it, it was installed and I left things alone.  The vendor tells me it's not installed properly and that there is no default instance.  Where I see the instances, he says they are not 2005 instances but 2000 instances.  I was asked to reinstall SQL 2005.  Is this going to be a problem?  Is what he saying seem correct?  I don't want to cause any problems with existing instances.

When I run the install I get a warning that I am not quite clear on how to deal with it.  I am just not strong in SQL.

How can I install SQL 2005 so this vendor is happy?
SQLConPan.png
SQLStudio.png
SQLWarning.png
0
Comment
Question by:kloux
[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 40

Accepted Solution

by:
lcohan earned 2000 total points
ID: 35099052
I believe you can't have two "DEFAULT" SQL servers on the same server box. You can have one "DEFAULT" which I believe is your SQL2000 as it was older, and now you have a "instance" of SQL 2005 which should be no problem to address like

server_names\sql_instance_name
0
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 2000 total points
ID: 35099072
And BTW you need to use latest Management Studio 2005 to manage both SQL 200 and 2005 - Old SQL 2000 Enterprise Manager can't register SQL 2005.
0
 
LVL 4

Author Closing Comment

by:kloux
ID: 35110498
I continued with the SQL 2005 install and ultimately had to install additional coponents to get this working.  The information provided was very helpful in understanding what was going on.

Thank you.
0

Featured Post

Technology Partners: 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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
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.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

649 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