locked
SQL Server Management Studio 2012 Error 948 RRS feed

  • Question

  • Hello

    I get the following error when trying to attach a database:

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

    Attach database failed for Server 'WLKCNU11216XJ\SQLEXPRESS'.  (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 'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\ADVENTUREWORKS2012_DATA.MDF' cannot be opened because it is version 706. This server supports version 661 and earlier. A downgrade path is not supported.
    Could not open new database 'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\ADVENTUREWORKS2012_DATA.MDF'. 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
    ------------------------------

    I suspect the database has been developed in SQL 2012, so I've ran SELECT @@VERSION in my version of SQL 2012, which returns:

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
        Apr  2 2010 15:48:46
        Copyright (c) Microsoft Corporation
        Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    I have SQL 2008 R2 installed, as well as SQL Server Management Studio 2012. Why is SQL 2008 being picked up in my version of 2012? Does this have something to do with the services which are running in Configuration Manager?

    Any help would be appreciated, thanks.


    Tuesday, November 20, 2012 3:28 PM

Answers


  • The database 'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\ADVENTUREWORKS2012_DATA.MDF' cannot be opened because it is version 706. This server supports version 661 and earlier. A downgrade path is not supported.
    Could not open new database 'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\ADVENTUREWORKS2012_DATA.MDF'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

    I have SQL 2008 R2 installed,

    Hello,

    Your are trying to attach a SQL Server 2012 (=version 706) database to a SQL Server 2008R2, an older version; this don't work, you can't attach a database of a newer version.


    Olaf Helper

    Blog Xing

    Tuesday, November 20, 2012 3:32 PM

All replies


  • The database 'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\ADVENTUREWORKS2012_DATA.MDF' cannot be opened because it is version 706. This server supports version 661 and earlier. A downgrade path is not supported.
    Could not open new database 'C:\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL10_50.SQLEXPRESS\MSSQL\DATA\ADVENTUREWORKS2012_DATA.MDF'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

    I have SQL 2008 R2 installed,

    Hello,

    Your are trying to attach a SQL Server 2012 (=version 706) database to a SQL Server 2008R2, an older version; this don't work, you can't attach a database of a newer version.


    Olaf Helper

    Blog Xing

    Tuesday, November 20, 2012 3:32 PM
  • Hi Olaf

    Indeed -

    I suspect the database has been developed in SQL 2012, so I've ran SELECT @@VERSION in my version of SQL 2012, which returns:

    Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
        Apr  2 2010 15:48:46
        Copyright (c) Microsoft Corporation
        Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    I have SQL 2008 R2 installed, as well as SQL Server Management Studio 2012. Why is SQL 2008 being picked up in my version of 2012? Does this have something to do with the services which are running in Configuration Manager?


    Tuesday, November 20, 2012 3:37 PM
  • I have SQL 2008 R2 installed, as well as SQL Server Management Studio 2012.


    SSMS is just the tool; that version doesn't matter here. The version of your SQL Server is important and that is 2008R2.

    Olaf Helper

    Blog Xing

    Tuesday, November 20, 2012 3:40 PM
  • How do I ensure or update my version of SQL Server to 2012? Sorry, I was under the impression that installing the SSMS 2012 would automatically install the latest version of SQL Server - or perhaps it has and the wrong one is being picked up/defaulted to by SSMS 2012?
    Tuesday, November 20, 2012 3:52 PM
  • Then download and install SQL Server 2012 Express; you can get it here: http://www.microsoft.com/en-us/download/details.aspx?id=29062

    Olaf Helper

    Blog Xing

    Tuesday, November 20, 2012 3:56 PM
  • Thanks Olaf.
    Wednesday, November 21, 2012 11:26 AM
  • Is this still open, Olaf?

    I installed SQL 2012 management studio but still get the same error trying to attach a database created by VS 2012 Express VWD

    Regards, pitters

    Friday, May 17, 2013 12:21 PM
  • I installed SQL 2012 management studio

    Hello pitters,

    The version of SSMS doesn't matter, the version of the SQL Server database engine is important. Which version are you using? When you are connected to your SQL Server, you can query it with:

    SELECT ServerProperty('ProductVersion')
    SELECT @@Version


    Olaf Helper

    Blog Xing

    Friday, May 17, 2013 1:06 PM