从另一台计算机进行SQL备份时访问被拒绝
简介:
我正在用3台计算机运行本地网络
的VB.NET程序,我将每天备份使用当前的名称(所以,,,他们每周都会更换)。
问题:
当我从主机备份时
(服务器主机),它正常备份
,但是我尝试从另一台计算机
中备份,我得到“访问被拒绝”
(如下所示)错误。
我尝试过的内容:
- 更改我的默认备份文件夹安全选项,添加“所有人”和“ NT Service \ MSSQLSERVER”所有安全选项;
- 将备份字符串更改为
... disk = n'\\ 192.168.0.2 \ backup sistema \ noting.bak'
'',以及共享
该文件夹并将权限授予>
“ MSSQLSERVER”
和“所有人”
; - 试图将
中的SQL Server登录更改为我的主计算机用户名,但使用密码(??)[我的计算机没有任何密码];
- 花了几个小时在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:
- Change my default backup folder security options, adding "Everyone" and "NT Service\MSSQLSERVER" all security options;
- Changed backup string to
... DISK = N'\\192.168.0.2\Backup Sistema\MONDAY.bak'
and alsosharing
that folder and giving permissions to"MSSQLSERVER"
and"Everyone"
; - 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]; - 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:
Backup Folder Security Tab:
Shared Permissions:
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论