StrataFlix attach database failed.

StrataFrame Forum

Back

StrataFlix attach database failed.

Author	Message
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: 6.9K	Cool
	Reply Like 0