By Terry Bottorff - 9/16/2008
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? TIABuffie
|
By Dustin Taylor - 9/16/2008
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.
|
By Terry Bottorff - 9/16/2008
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?
|
By Guillermo Vilas - 9/16/2008
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
|
By Terry Bottorff - 9/17/2008
How did you check the read only attribute of the database? TIA.
|
By Trent L. Taylor - 9/17/2008
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.
|
By Terry Bottorff - 9/17/2008
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!
|
By Trent L. Taylor - 9/17/2008
Glad you got it going.
|
By Charles R Hankey - 9/23/2008
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.
|