SQL Express install/upgrade?

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
LVL 4
klouxAsked:
Who is Participating?
 
lcohanConnect With a Mentor Database AnalystCommented:
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
 
lcohanConnect With a Mentor Database AnalystCommented:
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
 
klouxAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.