小白不太懂，具體情況如下，怎么回事呢？怎么解決這個問題呢？
-- 增量備份
--開啟xp_cmdshell
EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'xp_cmdshell', 1;
RECONFIGURE;
DECLARE @sql VARCHAR(500)
SELECT @sql = '\\192.168.1.200\dbbak\AES-DB\AES_omedb' + '_FULL_'
+ CONVERT(VARCHAR(10), GETDATE(), 112)
+ '.bak'
EXEC master..xp_cmdshell 'net use \\192.168.1.200\dbbak\AES-DB\AES 123456 /user:192.168.1.200\dbbak'
BACKUP DATABASE omedb TO DISK=@sql
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
Configuration option 'xp_cmdshell' changed from 1 to 1. Run the RECONFIGURE statement to install.
Msg 15121, Level 16, State 21, Procedure xp_cmdshell, Line 1
An error occurred during the execution of xp_cmdshell. A call to 'CreateProcess' failed with error code: '5'.
Msg 3201, Level 16, State 1, Line 14
Cannot open backup device '\\192.168.1.200\kf2b\AES-DB\AES_omedb_FULL_20210329.bak'. Operating system error 5(拒絕訪問。).
Msg 3013, Level 16, State 1, Line 14
BACKUP DATABASE is terminating abnormally.
uj5u.com熱心網友回復：
你的SQL SERVER服務是用什么賬號登錄的，設定成“本地系統帳戶”登錄，然后再試試。uj5u.com熱心網友回復：
sqlserver在 192.168.1.199 用的 sa 賬號， 備份到 1.200uj5u.com熱心網友回復：
我指的是SQL SERVER的服務
uj5u.com熱心網友回復：
這個sql server是英文版的比較煩，我看了一下 sql server configuration manager 里的 sql server services 下的 sql server(mssqlserver) log on as 是 localsystem 應該是本地系統賬戶的意思吧，看了一下屬性選的是 built-in account ，local system 另外還有2個選項是 local service 和 network service轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/270125.html
標籤：基礎類
上一篇：關于自動匹配的問題