StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » Read Only StrataFlic MDF

Read Only StrataFlic MDF

Terry Bottorff — Tue, 23 Sep 2008 19:02:13 GMT

I have installed the new version of strataframe and I have installed the strataflic samples. I go to Sql Server Management and tried to attach the Strataflic mdf. It tells me it is read only? I have turned off UAC in Vista, I have signed on as ADMIN and run as ADMIN when I have tried installing the sample too no avail. Any ideas? TIA

Buffie

RE: Read Only StrataFlic MDF

Charles R Hankey — Tue, 23 Sep 2008 19:02:13 GMT

I ran across this with Vista and SQL2008 RC. The solution is to run SSMS as administrator :

Just right-clicked on the SSMS icon, chose Run as Administrator and when I attached the DB to the SQL 2008 server it behaved exactly as I wanted with the DB attaching normally and NOT read-only.

This is on a box where I am already the admin account, but running SSMS as administrator to avoid the attaching as read only seems to be a different matter.

Hope that helps.

RE: Read Only StrataFlic MDF

Trent L. Taylor — Wed, 17 Sep 2008 20:42:01 GMT

Glad you got it going. :)

RE: Read Only StrataFlic MDF

Terry Bottorff — Wed, 17 Sep 2008 18:44:07 GMT

I run Strataframe on my laptop (Vista) and my desktop (XP) and the Strataflix data was working fine on the desktop so I just copied the data out to a thumb dirve and copied it onto my laptop and then tried attaching it. It worked fine. I am not sure why the original problem but all seems well now....... Yea!

RE: Read Only StrataFlic MDF

Trent L. Taylor — Wed, 17 Sep 2008 09:40:27 GMT

More than likely it is just the extraction of the mdf and ldf that is read-only versus the internal definitions of the database. Just select eh StrataFlix.mdf and StrataFlix.ldf files, right-click, then go to properties. ENsure that they are not set to read-only.

RE: Read Only StrataFlic MDF

Terry Bottorff — Wed, 17 Sep 2008 08:31:37 GMT

How did you check the read only attribute of the database? TIA.

RE: Read Only StrataFlic MDF

Guillermo Vilas — Wed, 17 Sep 2008 03:07:30 GMT

I had the same issue yesterday when updating the StrataFlix application under Windows Vista (no issue under XP), and what I did to fix it was make sure the read only database where detached, then check to see if a read only attribute is applied to it and last attach the database again.

Regards

RE: Read Only StrataFlic MDF

Terry Bottorff — Tue, 16 Sep 2008 16:57:29 GMT

I have tried that also? Nothing I do shows anything that it is read only but Sql Server Management thinks it is. UG! Any other ideas?

RE: Read Only StrataFlic MDF

Dustin Taylor — Tue, 16 Sep 2008 16:01:30 GMT

It probably just came out of the archive as read-only for some reason. Try navigating to the physical MDF file on disk and editing the file properties (right click on the file and select properties.) If the "read-only" check box is checked then that is your problem :). Just uncheck it, click OK, and give it another shot.