Hi,
I am trying to get a maintenance plan on SERVER1 to backup to a UNC path on NAS1.
NAS1 is managed by a 3rd party who gives us a username and password to connect to our directory on the NAS.
I have created a matching username/pass on SERVER1 (WIN 2003 SP1). I can logon as that user and browse to the UNC path without being prompted for credentials. I can read, write, and delete files and directories. We'll call this user SERVER1\MyUser1
In SQL2005 I have done the following:
- Created a maintenance plan, BackupToNAS, that is supposed to backup all databases to the UNC path. Owner SERVER1\Administrator
- Created a SQL 2005 Credential, NASuser.
- Identity: SERVER1\MyUser1
- Created a proxy, NasProxy
- Credential name: NASuser
- Operating System(CmdExec) selected
- SQL Server Integration Services package selected
- Added SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRole pricipals
- On the BackupToNAS job properties:
- Owner: FDDB00\Administrator
- Step Properties (only 1 step):
- Run As NasProxy
- Logon to server set to user windows authentication
- SQL server and agent services run as SERVER1\Administrator
When I attempt to run the job I get the following error:
Message
Unable to start execution of step 1 (reason: Error authenticating proxy SERVER1\MyUser1, system error: Logon failure: unknown user name or bad password.). The step failed.
Please let me know if you have any advice or corrections on how to get this to work. Thanks!