How to change ownership of SQL Server 2005 maintenance tasks

Posted on 2013-01-22
Medium Priority
Last Modified: 2013-04-29
I recently had to have my windows login name changes.  I have many SQL server 2005 maintenance jobs setup with my windows authenication name.  Now, I've noticed that they have failed for obvious reasons.  How do I change ownership quickly.
Question by:Jack Seaman
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 38807107
Go to Control panel -> Administrative tools -> services
then click properties of the sql server instance. There you will find Log On at second tab of dialog box where you can update your new windows login and password.

Goldy Khurmi
LVL 14

Accepted Solution

Emes earned 2000 total points
ID: 38807229
use this command


to find the ON I would have a select statement on the sysobjects.

Author Comment

by:Jack Seaman
ID: 38812122
I've been able to change it thru the GUI.

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

770 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