Solved

Fixing permissions for SQL Jobs

Posted on 2009-05-08
4
297 Views
Last Modified: 2012-05-06
Below is there error message I get when trying to run a SQL Job. I have an idea of what the problem is but can seem to find the palce to change the username and password.

I am trying to run a legacy DTS package in a scheduled job but the job fails due to an invalid password. I checked the server configuration Manager and Surface Area Configuration but the account in the error message below is not listed as the SQL Server Agent account.

I'm running SQL Server 2005 and I have my SQL Agent setup to run as a domain admin account instead of the default local service. Everything worked fine until this morning when the domain admin account password expired and I had to change it. I'd like to change the domain acount that is used by SQL server but I can find where to change the account and password.





Date            5/8/2009 10:36:58 AM
Log            Job History (Job Name)

Step ID            1
Server            TIC-BAAN
Job Name            Job name
Step Name            Execute DTS
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 Domain\User, system error: Logon failure: unknown user name or bad password.).  The step failed.
0
Comment
Question by:ticgums
  • 3
4 Comments
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
ID: 24337323
0
 

Author Comment

by:ticgums
ID: 24337518
Thanks for the suggestion, I tried changing the owner of the job but that didn't work. Still get the same error.

The links you included are for SQL 2000, I am running SQL 2005.
0
 

Author Closing Comment

by:ticgums
ID: 31579499
Will post a comment explaining why I said partially.
0
 

Author Comment

by:ticgums
ID: 24338632
Changing the owner of the SQL Job was not what needed to be done but it made me rethink the job process and how the steps run. Each step of the job was set to "run as" a specific user (custom credential) So I changed the "run as" option for the first step and it worked. I then went in to the security credentials and update the custom credential that I created to use an AD service account that did not have an expiring password.

Thanks for getting me on the right track.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
A short film showing how OnPage and Connectwise integration works.

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now