Improve company productivity with a Business Account.Sign Up

x
?
Solved

How to change ownership of SQL Server 2005 maintenance tasks

Posted on 2013-01-22
3
Medium Priority
?
186 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 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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

595 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