"Access denied" when backing up to a Network Attached Storage (NAS) device.
说明
Access denied when backing up to a Network Attached Storage (NAS) device. LiteSpeed backs up successfully to the local drive. The SQL Server Agent does not have a login to the NAS.
解决办法
RESOLUTION: 1. Begin a SQL Profiler Trace, with the standard profile, and using the LiteSpeed Enterprise Console, browse to the NAS (where the Access denied message appears). This will display the account running the directory read. 2. Begin a LiteSpeed backup to the NAS using native SQL Server using a UNC path to the NAS. The SQL Profiler Trace will display the account running the process. Note: The Windows user must be the one that starts SQL Server and must have read/write/modify permissions on that drive. For scheduled jobs, the job�s owner is the creator, by default. The Job Step �Run as� user and the owner must be sysadmin and have permission to run the SQL Server Agent.
