0

I'm opening up SQL Server 2008 R2 Management Studio.

When I connect to my database server, it says the version is 9.0.2047. But when I connect to my analysis server and report server, they are both version 10.50.1600.1.

How can I change my database server so that it is running version 10.50.1600.1?

Improve this question
1
  • 2
    Run the instance upgrade wizard in 2008R2? 9.xxxx means it's SQL 2005 at the moment. Commented Jun 1, 2012 at 14:44

2 Answers 2

Reset to default
1

In the SSMS Object Explorer, from the "Connect dropdown > Database Engine..." item, you can choose from all your available database servers.

It seems like you have different versions of SQL Server installed alongside each other.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

0

Uninstall SQL Server 2005, and install SQL Server 2008 R2.

Here's a nice website with versions for you.

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.