StrataFlix attach database failed.

StrataFrame Forum

Back

StrataFlix attach database failed.

Author	Message
Keith Gordijn	Keith Gordijn posted 16 Years Ago HOT Topic Details Share Topic
Group: Forum Members Posts: 35, Visits: 2.6K	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 Attachments attachdatabase.png (288 views, 20.00 KB)
	Reply Like 0
Replies
Bill Cunnien	Bill Cunnien posted 15 Years Ago Post Details Share Post
Group: Forum Members Posts: 785, Visits: 3.6K	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.
	Reply Like 0
Trent Taylor	Trent Taylor posted 15 Years Ago Post Details Share Post
Group: StrataFrame Developers Posts: 6.6K, Visits: 7K	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.
	Reply Like 0
Bill Cunnien	Bill Cunnien posted 15 Years Ago Post Details Share Post
Group: Forum Members Posts: 785, Visits: 3.6K	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
	Reply Like 0
Trent Taylor	Trent Taylor posted 15 Years Ago Post Details Share Post
Group: StrataFrame Developers Posts: 6.6K, Visits: 7K	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.
	Reply Like 0
Bill Cunnien	Bill Cunnien posted 15 Years Ago Post Details Share Post
Group: Forum Members Posts: 785, Visits: 3.6K	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.
	Reply Like 0
Bill Cunnien	Bill Cunnien posted 15 Years Ago Post Details Share Post
Group: Forum Members Posts: 785, Visits: 3.6K	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.
	Reply Like 0
Bill Cunnien	Bill Cunnien posted 15 Years Ago Post Details Share Post
Group: Forum Members Posts: 785, Visits: 3.6K	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 ------------------------------
	Reply Like 0
Bill Cunnien	Bill Cunnien posted 15 Years Ago Post Details Share Post
Group: Forum Members Posts: 785, Visits: 3.6K	'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.
	Reply Like 0
Trent Taylor	Trent Taylor posted 15 Years Ago Post Details Share Post
Group: StrataFrame Developers Posts: 6.6K, Visits: 7K	Cool
	Reply Like 0