Hi
I downloaded the AdventureWorks 2012 DB and tried to attach it to my SQL management Studio 2012 running on the RTM Win 8 OS and it says :


The database 'AdventureWorksLT2012' cannot be opened because it is version 706. This server supports version 655 and earlier. A downgrade path is not supported.
Could not open new database 'AdventureWorksLT2012'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

The version of SQL Management Studio I have is
Microsoft SQL Server Management Studio 11.0.2100.60
Microsoft Data Access Components (MDAC) 6.2.9200.16384
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.10.9200.16384
Microsoft .NET Framework 4.0.30319.17929
Operating System 6.2.9200


Any ideas why this should happen, I sort of expected the latest release of adventureworks to work with the latest version of SQL man studio. I have checked for a later release of SQL Man. studio and there doesn't seem to be one.

Brenda

Sorry, I just read your question. We are investigating this issue, and I will respond back in a few days. (I'm not at my office right now where I can test your issue; otherwise, I would test it today :-)
Thanks,
Derrick VanArnam

Hi Brenda,

I will not be able to respond to this issue for about a week. Are you blocked from doing something else by not having more info?

Thanks,
Derrick

Hi, i am having same problem Brenda has with same OS.

I downloaded Adventure Works LT 2008 not 2008R2 and I was able to attach it but it showed only as READ ONLY access in 2012 Express.

So i downloaded the AdventureWorksLT.msi which was used in a video for SQL Server 2005. I installed in the ...\Data subdirectory under Microsoft Sql Server.

I tried Access Control List to add NT Service\SQLSERVEREXPRESS as having full control but same read-only error!

I get this error with the .msi application:

TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'DEVTRA-PC\SQLEXPRESS'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1846+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Database 'AdventureWorksLT' cannot be upgraded because it is read-only or has read-only files. Make the database or files writeable, and rerun recovery. (Microsoft SQL Server, Error: 3415)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=3415&LinkId=20476

BUTTONS:

OK

I get a read only error as well. Looks like this issue is not being investigated at this point?

Hello,

We are investigating this issue. Thank you for reporting this error.

I have downloaded all of the available version for AdventureWorks 2008. When I try to attach the database I get an error that states that I need version 612. I am not sure how to get 612. I have 661 and 655. Any help would be appreciated.

Version 661 is SQL Server 2008 and 612 is SQL Server 2005 SP2. Please make sure that you downloaded the right package. You may have multiple SQL Server instances on your computer, so make sure that you are running against the right SQL instance.

Here is a short list of version for the major SQL Server versions I compiled:
SQL Server Version Compatibility Level Internal Database Version Build
SQL Server 2012 RTM 110 706 11.0.2100.60
SQL Server 2008 R2 100 665 10.50.xxxx
SQL Server 2008 100 661 10.00.xxxx
SQL Server 2005  SP2 90 612 9.00.xxxx
SQL Server 2005 90 611 9.00.xxxx
SQL Server 2000 80 539 8.00.xxx(x)

Run this query to confirm the version installed on your computer:
SELECT @@Version,
SERVERPROPERTY('productversion') as [Product version],
SERVERPROPERTY ('productlevel') as [Product level] ,
SERVERPROPERTY ('edition') as [Edition],
DATABASEPROPERTYEX((select DB_Name()),'Version') as [Internal Version Number],
DATABASEPROPERTY((select DB_Name()),'Version') as [Internal Version Number--Deprecated],
(select DB_Name()) as DBName,
(SELECT COMPATIBILITY_LEVEL FROM SYS.DATABASES WHERE NAME = (select DB_Name())) as compatibilityLevel