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

Popular posts from this blog

python - Scipy curvefit RuntimeError:Optimal parameters not found: Number of calls to function has reached maxfev = 1000 -

c# - How to add a new treeview at the selected node? -

java - netbeans "Please wait - classpath scanning in progress..." -