从另一台计算机进行SQL备份时访问被拒绝

发布于 2025-02-02 20:33:22 字数 1678 浏览 2 评论 0原文

简介:

我正在用3台计算机运行本地网络的VB.NET程序,我将每天备份使用当前的名称(所以,,,他们每周都会更换)。

问题:

当我从主机备份时服务器主机),它正常备份,但是我尝试从另一台计算机中备份,我得到“访问被拒绝”(如下所示)错误。

我尝试过的内容:

  1. 更改我的默认备份文件夹安全选项,添加“所有人”和“ NT Service \ MSSQLSERVER”所有安全选项;
  2. 将备份字符串更改为... disk = n'\\ 192.168.0.2 \ backup sistema \ noting.bak''',以及共享该文件夹并将权限授予> “ MSSQLSERVER”“所有人”;
  3. 试图将中的SQL Server登录更改为我的主计算机用户名,但使用密码(??)[我的计算机没有任何密码];
  4. 花了几个小时在Foruns进行搜索和尝试。

注意:当我尝试通过网络进行备份(使用\ 192.168.0.2 ...)时,它说它无法登录到主机/访客用户。

我的连接字符串:

Data Source=MYCOMPUTER;Initial Catalog=master;Integrated Security=False;Persist Security Info=False;User Id=admin;Password=123456

我的备份字符串:

BACKUP DATABASE Sistema_DB TO DISK = 'MONDAY.bak' WITH INIT;

错误消息:

“错误消息”

备份文件夹安全表:

共享权限:

“共享权限”

Introduction:

I'm running my VB.NET program in local network with 3 computers, I make daily backup's with current day name (so, they get replaced every week).

Problem:

When I backup from my main machine (which is server host), it backups normally, but when I try to backup from another machine, I get "Access Denied" (as shown below) error.

What I've tried:

  1. Change my default backup folder security options, adding "Everyone" and "NT Service\MSSQLSERVER" all security options;
  2. Changed backup string to ... DISK = N'\\192.168.0.2\Backup Sistema\MONDAY.bak' and also sharing that folder and giving permissions to "MSSQLSERVER" and "Everyone";
  3. Tried to change SQL Server logon in "Services" to my main machine username but didn't have success with the password (??) [My computer doesn't have any password];
  4. Spent some hours searching in foruns and trying.

Note: When I try to make the backup over network (with \192.168.0.2...), It says It couldn't logon into main machine/guest user.

My connection String:

Data Source=MYCOMPUTER;Initial Catalog=master;Integrated Security=False;Persist Security Info=False;User Id=admin;Password=123456

My backup String:

BACKUP DATABASE Sistema_DB TO DISK = 'MONDAY.bak' WITH INIT;

Error Message:

Error Message

Backup Folder Security Tab:

Permissions

Shared Permissions:

Shared Permissions

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文