Wednesday, August 01, 2012 8:37 PM
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.
Wednesday, August 01, 2012 9:28 PMModerator
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.
- Proposed As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Thursday, August 02, 2012 2:49 AM
Wednesday, August 01, 2012 9:39 PMYou 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"
Wednesday, August 01, 2012 10:02 PMModerator
Can you attach discovery report to see what is exactly installed on the machine and at what version
to generate discovery report:
SQL Server Setup Team
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.
Thursday, August 02, 2012 12:57 PM
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?
Thursday, August 02, 2012 2:19 PMModerator
Yes. That could be a solution. Please download it from the following link
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:
Hope this helps.
Saturday, August 11, 2012 9:04 PM
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?)
Thursday, August 30, 2012 3:14 PMModerator
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.
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.
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Thursday, September 06, 2012 4:22 PM
Thursday, September 06, 2012 4:34 PMThat reminds me. That page could use better labeling. A beginner might be justifiably confused as to which exe is which.