?
Solved

How to change ownership of SQL Server 2005 maintenance tasks

Posted on 2013-01-22
3
Medium Priority
?
179 Views
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.
0
Comment
Question by:Jack Seaman
[X]
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
3 Comments
 
LVL 1

Expert Comment

by:goldykhurmi
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.

Regards,
Goldy Khurmi
0
 
LVL 14

Accepted Solution

by:
Emes earned 2000 total points
ID: 38807229
use this command

ALTER AUTHORIZATION ON yyyyy TO xxxxx;

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

Author Comment

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

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