SQL Express备份和写入权限 [英] SQL Express Backup and write permissions

问题描述

我已经将基于MSDE的WinApp C#应用程序迁移到了SQL Express2005.该应用程序可以使用SQL DMO进行数据库备份和还原.问题是使用SQL Express时出现错误，这似乎是SQL Express使用的用户帐户没有对该文件夹的写权限.

我需要解决这个问题，但是方法是什么?
-使用SQL SMO是否可以解决问题?
-我应该在安装(WIX)期间以某种方式授予权限吗?
-我应该在安装过程中创建一个特殊文件夹并授予其权限吗?
-其他?

请注意，我无法在客户端计算机上进行任何手动操作，因为这是分布在CD上的应用程序.

感谢您的帮助，

Francesc

Hi,
I''ve migrated a WinApp C# application based on MSDE to SQL Express 2005. The application can do DB backups and restores using SQL DMO. The problem is that with SQL Express I get an error, which seems to be that the user account that SQL express uses doesn''t have write permission to the folder.

I need to solve that, but what''d be the approach?
- Would using SQL SMO fix the problem?
- Should I grant permissions somehow during installation (WIX)?
- Should I create a special folder and grant permissions to it during installation?
- other?

Note that I can''t do any manual manipulation on the client machine, as this is an application distributed on a CD.

Thanks for your help,

Francesc

推荐答案

我已将SQLACCOUNT ="NT AUTHORITY \ SYSTEM"添加到SQL Express安装命令行中，并解决了该问题.本地系统帐户具有写入磁盘权限.

I''ve added SQLACCOUNT="NT AUTHORITY\SYSTEM" into the SQL Express installation command line and it fixed the problem. The Local System account has write to disk permissions.

这篇关于SQL Express备份和写入权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！