By Keith Gordijn - 8/27/2009
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
|
By Trent L. Taylor - 8/28/2009
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.
|
By Bill Cunnien - 2/25/2010
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
|
By Dustin Taylor - 2/25/2010
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.
|
By Bill Cunnien - 3/1/2010
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
|
By Bill Cunnien - 3/1/2010
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.
|
By Trent L. Taylor - 3/1/2010
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. 
|
By Bill Cunnien - 3/1/2010
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
|
By Trent L. Taylor - 3/1/2010
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.
|
By Bill Cunnien - 3/1/2010
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.
|
By Bill Cunnien - 3/1/2010
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.
|
By Bill Cunnien - 3/1/2010
Here is the error message I get when attempting to set the DB's read-only flag to false:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Alter failed for Database 'StrataFlix'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1045+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Unable to open the physical file "C:\Program Files (x86)\MicroFour\StrataFlix\StrataFlix.mdf". Operating system error 5: "5(Access is denied.)".
Unable to open the physical file "C:\Program Files (x86)\MicroFour\StrataFlix\StrataFlix_Log.LDF". Operating system error 5: "5(Access is denied.)".
Database 'StrataFlix' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 5120)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
|
By Bill Cunnien - 3/1/2010
'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.
|
By Trent L. Taylor - 3/1/2010
Cool 
|