Attach database failed for TheBeerHouseVB

Topics: Developer Forum
Oct 12, 2009 at 8:15 AM

error attaching database to MSSQL 2005 with service pack 3.

The database 'TheBeerHouseVB' 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 'TheBeerHouseVB'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948).

Is there no SQL script that I can run to create this database?

Thanks for any help.

 

Coordinator
Oct 12, 2009 at 2:55 PM

You need to install SQL 2008

Oct 26, 2009 at 12:52 AM

I have SQL 2008 installed and when attaching the ASPNETDB.MDF file, I get a similar error, except it indicates that the DB is version 655 and this server supports 639 and earlier. Is there some patch to SQL 2008 that is required?

Thanks

Brian

Nov 6, 2009 at 7:17 PM

Would it be possible simply to provide a SQL Server 2005 compatible version of the file? Or is the application too dependent on things like the new Date type and other such?

Nov 9, 2009 at 4:32 AM

Hi,

Can anyone please solve my problem. When i try to attach the database the following error comes

"The database 'TheBeerHouseVB' cannot be opened because it is version 655. This server supports version 611 and earlier".

i have gone through some blog and come to know that this .mdf has been created in sqlserver 2008. But i have sqlserver2005

can anyone please make a script with data for sqlserver2005 and send my mail id shekhar.manna@live.com.

Or do you have any better solution can you please share with me.

Thanks

Shekhar 

Nov 28, 2009 at 6:27 PM

I have tried a number of things to get the database working. The MDF won't attach to either of SQL2005 developer version, or SQL2008 developer version. 

I understand it's SQL database version 655, which I believe is SQLServer Express 2008. This is not compatible with Developer SQL 2005 or 2008... I've even had someone load it to their SQL Express 2008, then back it up and send me the BAK file to restore. A SQL Express 2008 BAK won't restore to SQL2008 Developer...

Is there some script that could be used to build the DB??  

I must be missing somethings; this shouldn't be this difficult. 

Thanks,