SQL Server 2012 version showing as SQL server 2008

Hi, I currently have sql server 2008 r2 installed on my machine. I have installed sql server 2012 on my machine.

but when i open sql server 2012 management studio, and do a select @@version to check the version, it comes up as sql server 2008.

Does anyone have any idea about this ?

Many Thanks
gvamsimbaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Sounds like you are opening SQL Server Management Studio in the 2008r2 version instead of the 2012 version.

One way to test it. Please right-hand click on a database, go to Properties and the Options tab.

Does it give you an option to change the Compatibility level of the database to "SQL Server 2012 (110)"?

Another way to test - go to Help - About.
0
gvamsimbaAuthor Commented:
Hi Philllip, I have tried this option - Please right-hand click on a database, go to Properties and the Options tab
this shows 2008 but there is no option of 2012.

However HELP-ABOUT says sql 2012...

very strange..any idea.
0
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Try opening SSMS directly through Windows Explorer, such as

C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe

See if that makes a difference.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> when i open sql server 2012 management studio, and do a select @@version

Kindly connect to SQL Server 2012 instance and run SELECT @@version to show the correct values.
If you are connected to SQL Server 2008 R2 instance from 2012 SSMS, then it will show 2008 R2 only
0
gvamsimbaAuthor Commented:
Hi Phillip, the result is the same if i open by windows explorer.

Hi Raja, how do I connect to SQL server 2012 instance ?
0
gvamsimbaAuthor Commented:
Raja, just to let you know that my sql server 2012 is a brand new installation on my local machine and I did not create or attach any databases on it at the moment.

I have just ran the SELECT @@version on the default report server DB and it says 2008. I also tried on master and it also says 2008.  but HELP- ABOUT clearly says 2012 version.

any suggestions please ?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
You are mixing stuffs here. You are using SSMS 2012 but connecting to a SQL Server 2008R2 database engine.
Run the SQL Server Configuration Manager and in SQL Server Services check how many SQL Server service do you have running (check attached image).
Configuration Manager
0
gvamsimbaAuthor Commented:
Hi Victor, I have just done this....and I can clearly see sql server 2012 here..  

Any idea what is happening ?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Can you post your Configuration Manager screen?
0
gvamsimbaAuthor Commented:
configuration-manager.png
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Ok. As I thought you have at least 3 SQL Server installed (SQLExpress, 2008 and 2012) and you might be connecting to SQL Server 2008 instance. In SSMS you need to connect to .\MSSQLServer2012 as below example:
Capture.JPG
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gvamsimbaAuthor Commented:
Fantastic Vitor, you are the Man..

Problem solved....full points to you....
0
gvamsimbaAuthor Commented:
Brilliant...
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Thanks.
Keep in mind that SSMS 2012 can connect to SQL Server 2008 and 2005 instances but SSMS 2008 can't connect to SQL Server 2012 or 2014 instances. It works only backwards and not forward.

Cheers
0
gvamsimbaAuthor Commented:
oh yes sure, got you...

Thank you very much Boss...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

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.