Denial of permission while deleting SQL Server 2005 Express database file on Vista -
i using ms sql server 2005 dbms winforms app. data stored in encrypted archives containing .mdf , .log files. app running admin rights.
while app using given data file, .mdf , .ldf files extracted users temp folder , attached dbms. when file closed app menu, db detached , db files archived original archive file, , deleted users temp storage.
everything has been working fine on win7, xp , vista machines. on of clients vista machines denial of access errors logged, while app moving detached .mdf , .ldf files archive them. @ same time there no such errors on other machines, having same os (vista) , antivirus (avast)
the main things check are:
- be sure have admin rights. if pcs on different domain, check "administrator" gives rights think you'll get.
- sql server may still have database files open. may simple waiting few seconds after dismounting sure it's finished before start working on database files.
a better approach may ask sql server handle databases you: restore/backup database from/to archive , drop using sql calls, rather trying modify raw files yourself.
Comments
Post a Comment