SQL Server 2005作业备份报错解决办法

SQL SERVER 2005计划备份报错

Executed as user: TAOBAO-HZ\super. Cannot open backup device '\\192.168.0.2\back\2008-12-04 14.17.06.bak'. Operating system error 5(拒绝访问。). [SQLSTATE 42000] (Error 3201)  BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013).  The step failed.

类似于NT AUTHORITY\SYSTEM权限不够的问题，请在服务管理中将SQL Server (MSSQLSERVER) 和 SQL Server Agent (MSSQLSERVER).的两个服务的登录（Log On）改为在 192.168.0.2上有权限的域帐号

 

 

额外关注一点，远程备份，不能用机器名，仅能用ip