title: Error authenticating proxy while running agent job
body: <p>I am trying to schedule a SSIS2014 package via SQL Server Agent job. Both SSIS and SSMS are running on my local machine in the same domain. I am running SSMS with the same user <code>Domain\Admin</code> which is the creator of the SSIS package. SSMS 32-Bit and SSIS 32-Bit are running on Windows 7 64-Bit machine. I can run the package within SSIS without problems.</p>
  
  <p>Using Microsofts KB article <a href="http://support.microsoft.com/kb/918760" rel="nofollow">http://support.microsoft.com/kb/918760</a> and tutorial video <a href="http://technet.microsoft.com/en-us/library/dd440760%28v=sql.100%29.aspx" rel="nofollow">http://technet.microsoft.com/en-us/library/dd440760%28v=sql.100%29.aspx</a> I tried a couple of methods (proxy, configuration file, EncryptSensitiveWithPassword) but none of them worked for me. </p>
  
  <p>When I use a proxy account to run the job step, the following message occurs:</p>
  
  <pre><code>Unable to start execution of step 1 (reason: Error authenticating proxy
  `Domain\Admin`, system error: Logon failure: unknown user name or bad password.). 
  The step failed.
  </code></pre>
  
  <p>The proxy account uses the credentials identity <code>Domain\Admin</code>. Since the password fields for credential properties in SSMS cannot be left blank, I typed any password although my corresponding windows account has no password. So as mentioned above it's the same user account that created the SSIS package since <code>Domain\Admin</code> is stated in the CreatorName property of the SSIS package.</p>
  
  <p>With this proxy, I tried to run SSIS jobs using the package ProtectionLevel's <code>EncryptSensitiveWithUserKey</code> and <code>EncryptSensitiveWithPassword</code>. Running the package manually within SSDT without problems, but from SSMS agent job the same error message appears. I tried the package sources "File System" and, after importing the package to MSDB, "SQL Server" and "SSIS Package Store". But exactly the same error message appears with each method.</p>
  
  <p>Task manager shows that SSMS is running in administrator mode. Using Windows Component Services I added DCOM permissions for <code>Domain\Admin</code> to start and activate "Microsoft SQL Server Integration Services 12.0" from local. But the same error message appears. So in my opinion it's a problem with SSMS user account permissions (???) but unfortunately I don't know what exactly to do here. I tried the following:</p>
  
  <p>In the system database MSDB (full path: <code>Databases / System Databases / MSDB / Security / Logins</code>) I assigned all available role memberships (Including db_ssisoperator, db_ssisltduser, db_ssisadmin) to <code>Domain\Admin</code>.</p>
  
  <p>In server security (full path: <code>Security / Logins</code>) I assigned all available server roles. In the tab User Mapping, I assigned the MSDB database.</p>
  
  <p>Still the same error message appears when I try to run the job. Does anybody have some ideas what I can try?</p>