Меню

Microsoft sql server ошибка 948

  • Remove From My Forums

  • Question

  • Hello

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

    TITLE: Microsoft SQL Server Management Studio
    ——————————

    Attach database failed for Server ‘WLKCNU11216XJSQLEXPRESS’.  (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 FILESMICROSOFT SQL SERVERMSSQL10_50.SQLEXPRESSMSSQLDATAADVENTUREWORKS2012_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 FILESMICROSOFT SQL SERVERMSSQL10_50.SQLEXPRESSMSSQLDATAADVENTUREWORKS2012_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.

Answers

  • The database ‘C:PROGRAM FILESMICROSOFT SQL SERVERMSSQL10_50.SQLEXPRESSMSSQLDATAADVENTUREWORKS2012_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 FILESMICROSOFT SQL SERVERMSSQL10_50.SQLEXPRESSMSSQLDATAADVENTUREWORKS2012_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

    • Marked as answer by

      Monday, November 26, 2012 1:26 AM

Источник

Yesterday I installed SQL Server 2008 on my laptop (Windows 7 64 bit), I need to attach a .mdf to the server, but when I try to do this, I get this error:

Attach Database failed for server ‘prince/sqlexpress’ (Microsoft.SqlServer.smo)

ADDITIONAL INFORMATION:
1.An Exception Occured while executing a Transact Sql statement or Batch (Microsoft.SqlServer.connectioninfo)

2.Unable to open the Physical file Operating system error 5: «5(Access is denied.)». (Microsoft SQL Server, Error: 5120)

With the help of Internet, I found some solution.

1.Start SQL Server manager as Administrator (right-click on the program, choose «Start as administrator»):

But I still got the same error.

That .mdf file does have have permission, so I moved into external drive (pendrive because my system have only C: drive, yet no partition I have done ) .

Then I got another error,

Attach database failed for Server ‘PrinceSQLEXPRESS’.
(Microsoft.SqlServer.Smo) ADDITIONAL INFORMATION:

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

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

I use the Query —

«select @@version;»

I got the Output as

«Microsoft SQL Server 2005 — 9.00.3042.00 (Intel X86) Feb 9 2007
22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition
on Windows NT 6.1 (Build 7600: )»

what shall i do? But i installed SQL Server 2008. how do i change that?
How to solve this error, please help out this problem, If you have any solution please post it.

Источник
  • Remove From My Forums

  • Question

  • TITLE: Microsoft SQL Server Management Studio
    ——————————

    Attach database failed for Server ‘DELL-ZAKWAN’.  (Microsoft.SqlServer.Smo)

    For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.37971.0&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 ‘MnrAccDBTR’ cannot be opened because it is version 904. This server supports version 869 and earlier. A downgrade path is not supported.
    Could not open new database ‘MnrAccDBTR’. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

    • Edited by

      Sunday, June 28, 2020 3:01 PM

Источник
  • Remove From My Forums

  • Question

  • TITLE: Microsoft SQL Server Management Studio
    ——————————

    Attach database failed for Server ‘DELL-ZAKWAN’.  (Microsoft.SqlServer.Smo)

    For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.37971.0&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 ‘MnrAccDBTR’ cannot be opened because it is version 904. This server supports version 869 and earlier. A downgrade path is not supported.
    Could not open new database ‘MnrAccDBTR’. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

    • Edited by

      Sunday, June 28, 2020 3:01 PM

Источник

TITLE: Microsoft SQL Server Management Studio
——————————

Attach database failed for Server ‘ABHINAV-PC’. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&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 ‘timtableso’ cannot be opened because it is version 655. This server supports version 611 and earlier. A downgrade path is not supported.
Could not open new database ‘timtableso’. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

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

——————————
BUTTONS:

OK
——————————
This error is shown every time when i’m trying to attach a database.
and this database is created in sql server 2008 and i’m also using sql server 2008,still it is giving an error.

It seems your database has been created with SQL Server 2008, but the actual version of SQL Server you are trying to attach it to is SQL Server 2005 (see Internal SQL Server Database Version Numbers[^]).

The help link shows to you may use SQL Server Management Studio 2008 R2 (10.50); are you sure that the instance you are trying to attach your database to is also a SQL Server 2008 R2 one? Because the error message states this instance is a SQL Server 2005 one.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject,
20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8
+1 (416) 849-8900

Источник

  • Hello dear!

    I am facing a problem with MS SQL Server 2008 R2 while attaching a database file, the error code is 948, I tried to solve it but still me getting same error so please help me to solve this critical problem

  • Gail Shaw

    SSC Guru

    Points: 1004494

    What are the error messages? I don’t have all of the error codes memorised.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • arzmohd2k8

    Old Hand

    Points: 306

    This error occurred while attaching database file:

    An exception was occurred while executing a-trasact SQL Statment or Batch

    (Microsoft.SqlServer.ConnectionInfo)

    Database connectivity cannot be opened because it is version 661. This server support version 655 and earlier

    A downgrade path is not supported.

    Could not open new database ‘connectivity’. CREATE DATABASE aborted. (Microsoft SqlServer, Error:948)

  • enriquemallon

    Ten Centuries

    Points: 1239

    The unit of work was initiated before DDF was started, and the application attempted to perform a distributed operation. The unit of work must be terminated by a rollback operation.

    An application that performs local database updates before DDF is started cannot perform distributed operations within the same unit of work. The current unit of work must be terminated by a rollback operation and a new unit of work must be initiated before any SQL operations can be performed.

  • Gail Shaw

    SSC Guru

    Points: 1004494

    enriquemallon (8/13/2014)

    The unit of work was initiated before DDF was started, and the application attempted to perform a distributed operation. The unit of work must be terminated by a rollback operation.

    An application that performs local database updates before DDF is started cannot perform distributed operations within the same unit of work. The current unit of work must be terminated by a rollback operation and a new unit of work must be initiated before any SQL operations can be performed.

    ??? Posted in the wrong thread by accident?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • Gail Shaw

    SSC Guru

    Points: 1004494

    arzmohd2k8 (8/13/2014)

    Database connectivity cannot be opened because it is version 661. This server support version 655 and earlier

    A downgrade path is not supported.

    You’re trying to attach a SQL Server 2008 R2 database to SQL Server 2008. They are different versions (like SQL 2012 and SQL 2014). You cannot downgrade databases.

    You’ll have to find a SQL Server 2008 R2 instance to attach this DB to.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • quackhandle1975

    SSChampion

    Points: 11055

    GilaMonster (8/12/2014)

    What are the error messages? I don’t have all of the error codes memorised.

    An expert would. 😉

    qh

    [font=»Tahoma»]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

  • Gail Shaw

    SSC Guru

    Points: 1004494

    quackhandle1975 (8/14/2014)

    GilaMonster (8/12/2014)

    What are the error messages? I don’t have all of the error codes memorised.

    An expert would. 😉

    Good thing I don’t claim to be an expert then, isn’t it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • quackhandle1975

    SSChampion

    Points: 11055

    GilaMonster (8/14/2014)

    quackhandle1975 (8/14/2014)

    GilaMonster (8/12/2014)

    What are the error messages? I don’t have all of the error codes memorised.

    An expert would. 😉

    Good thing I don’t claim to be an expert then, isn’t it.

    I think many on here (myself included, as I saw your presentation at Bits) see you as one. :satisfied:

    qh

    [font=»Tahoma»]Who looks outside, dreams; who looks inside, awakes. – Carl Jung.[/font]

Viewing 9 posts — 1 through 8 (of 8 total)

Источник

Message:

TITLE: Microsoft SQL Server Management Studio Express

——————————

Attach database failed for Server ‘MACHINENAMESQLEXPRESS’.  (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&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.Express.ConnectionInfo)

——————————

The database ‘Northwind’ cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.

Could not open new database ‘Northwind’. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

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

——————————

BUTTONS:

OK

——————————

Advanced Information:

===================================

Attach database failed for Server ‘MACHINENAME’.  (Microsoft.SqlServer.Express.Smo)

——————————

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

——————————

Program Location:

   at Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files, String owner)

   at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile.Attach()

   at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.SendDataToServer()

===================================

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

——————————

Program Location:

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)

   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)

   at Microsoft.SqlServer.Management.Smo.Server.AttachDatabaseWorker(String name, StringCollection files, String owner, AttachOptions attachOptions)

   at Microsoft.SqlServer.Management.Smo.Server.AttachDatabase(String name, StringCollection files, String owner)

===================================

The database ‘Northwind’ cannot be opened because it is version 655. This server supports version 612 and earlier. A downgrade path is not supported.

Could not open new database ‘Northwind’. CREATE DATABASE is aborted. (.Net SqlClient Data Provider)

——————————

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

——————————

Server Name: MACHINENAMESQLEXPRESS

Error Number: 948

Severity: 20

State: 1

Line Number: 1

——————————

Program Location:

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

Источник

0 0 голоса
Рейтинг статьи
Подписаться
Уведомить о
guest

0 комментариев
Старые
Новые Популярные
Межтекстовые Отзывы
Посмотреть все комментарии

А вот еще интересные материалы:

  • Яшка сломя голову остановился исправьте ошибки
  • Ятрогенная патология врачебные ошибки
  • Ясность цели позволяет целеустремленно добиваться намеченного исправьте ошибки
  • Ясность цели позволяет целеустремленно добиваться намеченного где ошибка
  • Microsoft sql server ошибка 9001

    • ➤