none
Cannot read SQL Server 2008 database ,it is version 661. This server supports version 655 and earlier

    Question


  • used to have sql 2005 then i uninstall it , and install sql 2008

    now Im trying to open a visual studio project , when i want to open the DB included with

    i get :

    Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
    Common reasons for this problem include that the server is not installed, the service is not started or the server is upgrading your database.  If an upgrade is in process, you will be able to connect to the database when the upgrade is complete.

    then i get : 

    The database 'C:\USERS\BSH\DESKTOP\IREAD\IREAD\APP_DATA\IREAD.MDF' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported.
    Could not open new database 'C:\USERS\BSH\DESKTOP\IREAD\IREAD\APP_DATA\IREAD.MDF'. CREATE DATABASE is aborted.
    An attempt to attach an auto-named database for file C:\Users\bsh\Desktop\iRead\iRead\App_Data\iread.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

    ** the DB i want to open is SQL 2008


    • Edited by bsh123 Sunday, March 17, 2013 4:47 PM
    Sunday, March 17, 2013 4:46 PM

Answers

  • 661 version refers to : sql server 2008R2 and 655 version refers to sql2008, r2 is higher version and you cannot attach higher version database to lower version. Either install higher version or install sql 2008 and script out all your objects to the lower version.

    To know the internal database version, run this...

    DBCC TRACEON(3604);

    DBCC DBINFO('MyDatabase')

    DBCC TRACEOFF(3604); in     result, you will see the dbi_version


    Hope it Helps!!


    Sunday, March 17, 2013 5:29 PM

All replies

  • 661 version refers to : sql server 2008R2 and 655 version refers to sql2008, r2 is higher version and you cannot attach higher version database to lower version. Either install higher version or install sql 2008 and script out all your objects to the lower version.

    To know the internal database version, run this...

    DBCC TRACEON(3604);

    DBCC DBINFO('MyDatabase')

    DBCC TRACEOFF(3604); in     result, you will see the dbi_version


    Hope it Helps!!


    Sunday, March 17, 2013 5:29 PM
  • thank u do much 

    very helpful

    i'm going to try it 

    Sunday, March 17, 2013 6:25 PM
  • DBCC TRACEON(3604)

    DBCC DBINFO('IREAD')

    DBCC TRACEOFF(3604)

    >>  dbi_version = 661

    that means the Db is 661 so every thing should be ok ! 

    and my SQL is 2008r2 
    • Edited by bsh123 Sunday, March 17, 2013 6:41 PM
    Sunday, March 17, 2013 6:38 PM
  • DBCC TRACEON(3604)

    DBCC DBINFO('IREAD')

    DBCC TRACEOFF(3604)

    >>  dbi_version = 661

    that means the Db is 661 so every thing should be ok ! 

    no. that means the database is 2008R2 version not sql2008. 2008r2 and 2008 are different editions but you are trying to open it with sql 2008  version installed on your box.

    refer this http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/a3fe38da-50d8-4dc9-853c-21f7ddc8b1de


    Hope it Helps!!



    • Edited by Stan210 Sunday, March 17, 2013 6:54 PM
    Sunday, March 17, 2013 6:41 PM
  • i remembered that i had 2008 before installing 2008r2 i think this is the problem, I'm going to uninstall 2008 an try again  

    thank u so much for helping

    Sunday, March 17, 2013 6:55 PM
  • the q is : if i have 2008 and 2008r2 it directly uses 2008 " lower verion" , right ? 
    Sunday, March 17, 2013 6:59 PM
  • It will use the version you're connecting to.

    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    Sunday, March 17, 2013 7:08 PM
  • how can i know the version i'm connecting to??

    how can i connect to the version i want, if i have more than version ??

    **i'm opening my DB from visual studio.

    thank u so much.

    Sunday, March 17, 2013 8:09 PM
  • In Visual Studio you need to connect to the right instance of SQL Server.

    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog

    Sunday, March 17, 2013 8:25 PM
  • how can i do that please ? 
    Wednesday, March 20, 2013 11:52 AM