You are viewing limited content. For full access, please sign in.

Question

Question

windows 8.1 demo repository attach fails

asked on May 20, 2014

 On windows 8.1, with SQL Express I get an error trying to attach the demo database to SQL:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'TOMLAPTOP10\LASERFICHE'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.2100.60+((SQL11_RTM).120210-1917+)&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)

------------------------------

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

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

------------------------------
BUTTONS:

OK
------------------------------

 

Any ideas?

0 0

Answer

APPROVED ANSWER
replied on May 20, 2014

The database you're using appears to be from SQL 2012 and it looks like you're trying to attach it to a SQL 2008 R2 instance. Try using SQL Express 2012 or higher.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.