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

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.

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?

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

------------------------------------------------------------------------
I would like to change the world, but they don´t give me the source code.
MS Windows 7 Ultimate 64-Bit
Intel(R) Core(TM)2 Quad CPU Q9300 2.50 GHz
6.00 GB of RAM, NVIDIA GeForce 9800 GT

MacBook Pro i5 OSX Lion

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

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.

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!

Glad you got it going.

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.