StrataFlix attach database failed.


Author
Message
Keith Gordijn
Keith Gordijn
StrataFrame Novice (97 reputation)StrataFrame Novice (97 reputation)StrataFrame Novice (97 reputation)StrataFrame Novice (97 reputation)StrataFrame Novice (97 reputation)StrataFrame Novice (97 reputation)StrataFrame Novice (97 reputation)StrataFrame Novice (97 reputation)StrataFrame Novice (97 reputation)
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 (365 views, 20.00 KB)
Replies
Bill Cunnien
Bill Cunnien
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
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.
Bill Cunnien
Bill Cunnien
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
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

------------------------------



Bill Cunnien
Bill Cunnien
StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)StrataFrame VIP (1.2K reputation)
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.



w00t

Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Cool Cool
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Keith Gordijn - 17 Years Ago
Trent L. Taylor - 17 Years Ago
Bill Cunnien - 16 Years Ago
Dustin Taylor - 16 Years Ago
Bill Cunnien - 16 Years Ago
Bill Cunnien - 16 Years Ago
                     Bill,

If SSMS is showing version 9, then most likely that...
Trent L. Taylor - 16 Years Ago
                         :sick:

I uninstalled SQL Server Express 2005 and installed...
Bill Cunnien - 16 Years Ago
                             They are most likely still there and you just need to re-attach them....
Trent L. Taylor - 16 Years Ago
                                 In an attempt to get back to normal, I decided to reinstall...
Bill Cunnien - 16 Years Ago
                                     In the 64bit world (I am guessing) certain folders will not be...
Bill Cunnien - 16 Years Ago
                                         Here is the error message I get when attempting to set the DB's...
Bill Cunnien - 16 Years Ago
                                             'Twas a permissions issue...I changed the permissions on the folder...
Bill Cunnien - 16 Years Ago
                                                 Cool :cool:
Trent L. Taylor - 16 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search