Solved

How to change ownership of SQL Server 2005 maintenance tasks

Posted on 2013-01-22
3
174 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
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 500 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

856 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