how to upgrade server to SQL 2005

5 pts.
Tags:
SQL Server 2005
SQL Server Express Edition
SQL Server Management Studio
SQL Server upgrades
I have a system with MS SQL Server 2005 installed and am running the MS SQL Server Management Studio Express but when I query the database version it comes back as SQL 2000 - 8.00.194. How do it change to using SQL 2005?

Answer Wiki

Thanks. We'll let you know when a new response is added.

If when you query the server it says that it’s SQL 2000, then you haven’t installed the database server, only the client tools.

You will need to install the database server component on the SQL Server backend and upgrade the instance of SQL Server.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: