SQL Agent Uses Default User profile

• scott wallace-352100

  SSC Veteran

  Points: 278

  More actions

  February 5, 2007 at 10:10 pm

  #176697

  Hi,

   

  I am having an issue whereby I have a SQL Server Agent job that has a step that needs to execute as a particular user (for which I have set up credentials and a proxy in SQL Server). This user has details in their profile that need to be accessed by the job.

   

  The job executes fine, but does not find the details in the user profile. I created a small bat script to debug and can see that the user is logged in OK (using whoami), but the %USERPROFILE% variable is set to "Default User". This does not happen when the required user is logged in to the machine at the time of execution.

   

  Is there some configuration or security setting I am missing?

   

  any help is much appreciated.

   

  scott.

• Sugesh Kumar

  One Orange Chip

  Points: 27311

  More actions

  February 5, 2007 at 11:21 pm

  #687917

  i think u need to execute a job with someother user. otherr than the owner of the job. try to use the "execute as user" in the execute step and try if it fixes ur problem.

  Cheers,
  Sugeshkumar Rajendran
  SQL Server MVP
  http://sugeshkr.blogspot.com

• Amit Kumar

  SSChasing Mays

  Points: 614

  More actions

  February 6, 2007 at 12:30 am

  #687923

  Hi

  You need to change MSSQLSERVER Agent service logon in windows control panel. Instead of default user, mention domain or workgroup user and password and then re-start agent service.

  Amit

• scott wallace-352100

  SSC Veteran

  Points: 278

  More actions

  February 6, 2007 at 4:12 am

  #687976

  Hi,

  Thanks for replies...

  The agent service doesnt run as Default User, but as a domain account (myDomain\SqlSvc). If I set the Job step to 'run as' SQL Server agent service, the correct profile is loaded (ie for SQLSvc). I believe this is because the Agent is in fact already running as this user.

  scott