Upgrade from SQL Server 2000 to SQL Server 2005 - incomplete

Question

I have installed MS SQL 2005 on a server that previously had 2000 on it but now I am not able to make the Database Engine connect to version 9 and it instead connects to 8. My SQL Management Studio connects to Microsoft SQL Server Enterprise Edition SQL Server 8.0.2039 while I need to make the Integration Services 9.0.1399 instead to become the Database Engine. What should I do? Can you help?

---

D-oh!

Answer 1

Hi,

Did you replace the SQL Server 2000 installation completely, or do a side-by-side install, i.e. both SQL Server 2000 and SQL Server 2005 co-exist?  You could look in Add/remove programs...

Did you install SQL Server 2005 as a named instance?  Did you actually install integration services? - it's an individual component

---

Thanks,

Andrew Bainbridge
SQL Server DBA

Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

Answer 2

Hi Andrew,

I first did a side-by-side install and then tried to get version 9 (SQL 2005) to work by uninstalling 2000 (version 8). That still didn't do the trick.

Thank you for looking into this so quickly!

-

Roger

---

D-oh!

Answer 3

Hi,

Can you see a folder for the SQL Server 2005 installation in the Start menu?  If so, could you launch the SQL Server Configuration Manager.  From there, you should be able to see details about what the instance name is, port number, etc.  Once you've got that information, you should then put "servername\instancename" in the connection box for the 2005 instance.  I think either: SQL 2005 didn't install properly, or you're inadvertently connecting to the old 2000 instance which still exists on the server.  They should happily coexist, and shouldn't be a need to uninstall 2000 to get 2005 to work.

Let me know how you get on.

Cheers

---

Thanks,

Andrew Bainbridge
SQL Server DBA

Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

Answer 4

Hi Andrew,

This is what I see. How do I get the Database Engine to connect to the 9 and not 8? The Integration Services connect to 9!

Thanks for being around, Andrew!

---

D-oh!

Answer 5

Hi,

Can you go in to SQL Server Configuration Manager, and whilst under SQL Server Services, screen shot the list... then post back here

---

Thanks,

Andrew Bainbridge
SQL Server DBA

Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

Answer 6

Here!

---

D-oh!

Answer 7

Interesting... It doesn't look like you've got the engine installed...

Can you double check by posting a screen shot of the SQL Server components in add/remove programs.  You might have to go through the install again and make sure to select the database engine components.

---

Thanks,

Andrew Bainbridge
SQL Server DBA

Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

Answer 8

I suspect this calls for a re-install?

---

D-oh!

Answer 9

it's looking that way.  Add/remove programs shows it installed, but I've not come across the SQL Server services not being shown in SQL Server Configuration Manager.

You could just try to add additional features and see if it lets you select the database engine... if not, I personally would try a reinstall

---

Thanks,

Andrew Bainbridge
SQL Server DBA

Please click "Propose As Answer" if a post solves your problem, or "Vote As Helpful" if a post has been useful to you

Answer 10

From the image, it looks like you are connected to the 2000 database engine and the 2005 Integration Services engine.

Since you mentioned that you installed 2005 side-by-side, can you run services.msc and see if you have the service installed and running? You will also see the name of the 2005 instance you installed earlier. It should be something like "SQL Server (InstanceName)"

If it is there, connect to it from SSMS using servername\instancename and see if that works. Btw, I'm assuming you're doing it all on the local machine so there is no need for enabling remote/network connections or sql browser.

---

No great genius has ever existed without some touch of madness. - Aristotle

Answer 11

Re-installation worked!

Thanks Andrew!

---

D-oh!

Answer 12

Joe - Thanks for your help too! It turned out to be a faulty installation problem that now finally got fixed!

---

D-oh!