Can't attach the sample database in SQL Server 2012

sql sql-server sql-server-2012 sql-server-2012-express
darking050 picture darking050 · Jul 19, 2012 · Viewed 7.3k times · Source

I have downloaded the sample database for SQL Server 2012 Express but I am having the following error message whenever I try to attach it:

The database 'AdventureWorks2012' cannot be opened because it is version 706. This server supports version 655 and earlier. A downgrade path is not supported.

Answer

Aaron Bertrand picture Aaron Bertrand · Jul 19, 2012

Sounds like the server you are trying to attach the database to is not SQL Server 2012. This may be the version of Management Studio / Management Studio Express you're using, but I suspect SELECT @@VERSION; will tell you something different. It may just be a connection string mixup if you have multiple instances of SQL Server installed, otherwise you should download and install SQL Server 2012 Express from here.

Related questions

Can't create stored procedure with table output parameter

I have this code: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetProfitDeals]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[GetProfitDealsVar2] GO IF EXISTS(SELECT 1 FROM sys.types WHERE name = 'TableOrderType' AND is_…

Read More
Convert Date format into DD/MMM/YYYY format in SQL Server

I have a query in SQL, I have to get a date in a format of dd/mm/yy Example: 25/jun/2013. How can I convert it for SQL server?

Read More
Recover unsaved SQL query scripts

How to recover the unsaved scripts if the SSMS crashes / unsaved tab gets accidentally closed?

Read More