Breckar


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:
  1. Created a maintenance plan, BackupToNAS, that is supposed to backup all databases to the UNC path. Owner SERVER1\Administrator
  2. Created a SQL 2005 Credential, NASuser.
    1. Identity: SERVER1\MyUser1
  3. Created a proxy, NasProxy
    1. Credential name: NASuser
    2. Operating System(CmdExec) selected
    3. SQL Server Integration Services package selected
    4. Added SQLAgentUserRole, SQLAgentReaderRole, SQLAgentOperatorRole pricipals
  4. On the BackupToNAS job properties:
    1. Owner: FDDB00\Administrator
    2. Step Properties (only 1 step):
      1. Run As NasProxy
      2. Logon to server set to user windows authentication
  5. 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!





Re: Error authenticating proxy when attempting to run Job

Satya SKJ


Have you tried connecting to NAS using SQLServer services account, using Run as from windows.





Re: Error authenticating proxy when attempting to run Job

Breckar

I'm not sure what you are referring to here, sorry.





Re: Error authenticating proxy when attempting to run Job

Satya SKJ

You said you can connect to NAS using your login credentials, as same can you try connecting to NAS using the account privileges of SQL SErver services account.




Re: Error authenticating proxy when attempting to run Job

Breckar

Hi and thank you for your replies!

If you mean can I connect to the NAS using SERVER1\Administrator (the account the SQL services use) the answer is no, I can not.

Thanks!

 edit: by the way, according to the error message, it almost looks as though the user can not even start the job so I'm not sure I'm hitting the UNC path yet.






Re: Error authenticating proxy when attempting to run Job

Satya SKJ

Then it is the privileges problem from the account, do you get any error while it is attempting to start the job. First thing to check on SQLAgent logs for more information.




Re: Error authenticating proxy when attempting to run Job

Breckar

We're talking about 2 accounts here:

SERVER1\MyUser1 - proxy account & account that has access to the NAS

SERVER1\Administrator - account to run services

Which are you saying has privlege problems Here is all of the error that I recieve:

-----

Date 2/12/2007 5:14:50 PM
Log Job History (BackupToNAS)

Step ID 1
Server SERVER1
Job Name BackupToNAS
Step Name BackupToNAS
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

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.

-----






Re: Error authenticating proxy when attempting to run Job

Satya SKJ

Logon failure: unknown user name or bad password.).---

Might test enabling the MyUser1 with Admin privieges and see.