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

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.

In the 64bit world (I am guessing) certain folders will not be searched if the user does not have security access to them (although, I am admin on this workstation). This was the case with the former MDF files. I manually scoured the Program Files and Program Files (x86) folders and found the older versions of the databases. I copied them to the new folder, attached them, and everything seems to be back in order.



The only item left that is still puzzling is the read-only flag on the StrataFlix database. I cannot clear it. I think it is a security issue, again.

Here is the error message I get when attempting to set the DB's read-only flag to false:

'Twas a permissions issue...I changed the permissions on the folder and all child objects to Full Access for my logon credentials. I can now change the read-only property.



Looks like that issue is all behind me, now.

Cool