Compatibility problems with SQL Server Management Studio 2012 (?)

Question

I'm running SQL Server Management Studio 2012

Microsoft SQL Server Management Studio      11.0.2100.60
Microsoft Data Access Components (MDAC)      6.1.7601.17514
Microsoft MSXML      3.0 4.0 5.0 6.0
Microsoft Internet Explorer      9.0.8112.16421
Microsoft .NET Framework      4.0.30319.269
Operating System      6.1.7601

This machine is only a few months old (Windows 7) so I must have downloaded this recently. 

For no good reason I thought I'd take a peek at AdventureWorks for SQL Server 2012.  (http://msftdbprodsamples.codeplex.com/releases/view/55330)

When I try to attach either of the first two data files listed, I get the message: The database 'AdventureWorks2012' cannot be opened because it is version 705. This server supports version 612 and earlier. A downgrade path is not supported.

What's the simplest fix for this?  To the best of my knowledge all my updates are current.

Answer 1

Hello,

Version 612 means SQL Server 2005. It seems you are trying to attach the database created on a SQL Server 2012 (version 706) into a SQL Server 2005. That is called a downgrade and it is not supported.

If you have more than one instance/version of SQL Server, please try to attach the database to the SQL Server 2012 instance.

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 2

You have SSMS 2012, you are trying to attach it to a 2005 DB Engine instance.  Did you just install 2012 management tools or did you install an instance as well?  COnnect to your instance and run "SELECT @@VERSION"

---

Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz

Answer 3

Can you attach discovery report to see what is exactly installed on the machine and at what version

to generate discovery report:

http://blogs.msdn.com/b/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
My Blog
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 4

My apologies to everyone.  I seem to have a mess on my hands.  I've got bits of everything from 2005 to 2012, and almost no memory of how it got there.  As I said, this is a new machine, purchased back in February.  (Also I can't install that discovery report.  No media.)

I think some parts might have been installed as part of VS2010 prequisites.

So all I have to do, at a minimum, is download and install a SQL 2012 Express instance?

Answer 5

Hello,

Yes. That could be a solution. Please download it from the following link

http://msdn.microsoft.com/en-us/evalcenter/hh230763.aspx

Please make sure .NET Framework 3.5 is enabled (Control Panel -> Programs and Features) before installing Express Edition. You may need to install PowerShell 2.0 also:

http://support.microsoft.com/kb/968929

Hope this helps.

Regards,
Alberto Morillo
SQLCoffee.com

Answer 6

Several points of uncertainty.

1.   Even though I have Dot Net Framework 4.0 installed, I still need to install 3.5?  (I do have Compact Framework 3.5 installed.)

2.   That link to support puts me on a page that states: This article applies to a different version of Windows than the one you are using. Content in this article may not be relevant to you.  The link to the Windows 7 support page seems to be mostly concerned with Service Pack 1, which I already have.  Yet I seem to have PowerShell 1.0 installed.  (Ok, I'm lost.  Is there actually a place where I can download PowerShell 2.0 for Windows 7?)

Answer 7

Hi B.Chernick,

SQL Server Express (with database engine only) can work with either .NET 3.5 SP1 or .NET 4, there is no need to have both enabled.

Microsoft released PowerShell 2.0 with Windows 7 and Windows 2008 R2. Windows PowerShell 2.0 is installed by default on Windows Server 2008 R2 (except on Core installations where it is optional) and Windows 7. You do not need to install PowerShell 2.0.

Download SQL Server 2012 Express and install it: http://www.microsoft.com/en-us/download/details.aspx?id=29062.

Thanks,
Maggie

 

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 8

That reminds me.  That page could use better labeling.  A beginner might be justifiably confused as to which exe is which.