Solved

How to change ownership of SQL Server 2005 maintenance tasks

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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sql Permission 6 74
Urgent help needed! Unable to to paste in query designer 29 55
Getting max record but maybe not use Group BY 2 36
SSMS Imprt data from Excel 7 28
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

730 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