Hi All,



I have just tried to install the latest StrataFlix sample but when I try to attach the database to my MS SQl Server 2005 I get the attached error saying I cannot attach a 655 versioned database to a 612 version SQL Server version.



Is there some way the database can be created in a version that I can attach?



Cheers,

Keith

Is it possible for you to load SQL Server 2008 Express on your machine.  That alone should resolve the issue (I think).  Since SQL Server Express is a free download hopefully this will be an avenue that you can take.  Thanks.

Let me know if this doesn't work for you. 

I just ran into this same situation. I have SQL Server 2008 Express on my machine but I am receiving the same error message as Keith. What can I do to get the StrataFlix database attached?



Thanks,

Bill

Are you sure you are loading to a SQL 2008 instance, not a SQL 2005 one? If so, are you sure it is the same error message?

Sorry to ask silly questions, but Keith's error message basically said that "this database is newer than the version of SQL server you are running". The StrataFlix DB was exported from a SQL 2008 server, so if you are on SQL 2008 and it is still giving you that message, I'm not sure what it would be.

I have 2008 installed. When I went to install it, thinking that I did not, it was detected and the installer would not proceed. Here the text from the error message:



TITLE: Microsoft SQL Server Management Studio

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



Attach database failed for Server 'CUNNIEN\SQLEXPRESS'. (Microsoft.SqlServer.Smo)



For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&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 'StrataFlix' 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 'StrataFlix'. 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

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



I'll keep working on it.

Bill

I am going to force SSE2K8 to be reinstalled (even though my system thinks it is). The SSMS is showing that v9 is installed rather than v10.

Bill,



If SSMS is showing version 9, then most likely that is what is actually installed for that instance. I have never seen that show an erroneous message before. So once you get on SQL 2008, I am sure that this issue will be resolved. If not, let us know and we will go from there.

I uninstalled SQL Server Express 2005 and installed SQL Server Express 2008. It appears that ALL databases have been destroyed. What did I do wrong?



Silver lining...I was able to attach the StrataFlix db without error.



Thanks,

Bill

They are most likely still there and you just need to re-attach them. I have never seen SQL Server uninstall any custom databases. Just the server, but the MDFs are still on disk and all you should have to do is re-attach them.

In an attempt to get back to normal, I decided to reinstall StrataFrame. That may not have been a good idea. I searched the hard drive and found no other pertinent MDF files to attach. They were gone. I'll see if I can restore them from a backup.



Major, major ouch, here.