dbTalk Databases Forums  

changing SQL Agent 'Logon as' to move backups off same drive,jobs

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts changing SQL Agent 'Logon as' to move backups off same drive,jobs

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss changing SQL Agent 'Logon as' to move backups off same drive,jobs in the microsoft.public.sqlserver.dts forum.



Reply
Page 5 of 5 < 1 2 3 4 5
 
Thread Tools Display Modes
  #41  
Old   
Russell Fields
 
Posts: n/a

Default Re: changing SQL Agent 'Logon as' to move backups off same drive,j - 05-01-2008 , 07:43 AM





Pat,

What rights does your new domain account for SQL Server Agent have on the
SQL Server? (I trust that it is a sysadmin, but if not then it should be.)
Could you give us the exact text of the message about having "nothing to
do"?

Here are a couple of posts on a similar problem:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=101304 missing ODBC
Registry keys
http://www.dbforums.com/showthread.php?t=768589 (SBS / Sharepoint issues
with SQL Agent - registry again)

RLF


"Pat M - City of Reno" <PatMCityofReno (AT) discussions (DOT) microsoft.com> wrote in
message news:8A8FD061-E3C4-4D94-8A79-6B06C3411E62 (AT) microsoft (DOT) com...
Quote:
Russel, I changed all my jobs to run under a domain account and all jobs
are
running fine. Last night I stopped MSSQLServer and SQLServerAgent and
changed
the Logon account to the domain account. SQLServerAgent would not start
saying it had nothing to do so I put the services back to a local account
til
I could find the problem. Any ideas? I am going to look at permissions on
the
SQL Server but thought I'd run it by you. Thanks for your help before.
--
Regards,
Pat


"Russell Fields" wrote:

Pat,

You should be able to simply update the owner of the jobs if you are a
sysadmin. (Or get a sysadmin to do the work for you, if you are not.)
In
SSMS open the job and choose a new Owner. Or you could script a change
to
the affected jobs to use.

EXEC sp_update_job @job_name = 'Job Name', @owner_login_name =
'Domain\Login'

An additional note, I always run my SQL Servers under a domain account,
not
local system.

RLF

"Pat M - City of Reno" <PatMCityofReno (AT) discussions (DOT) microsoft.com> wrote
in
message news:1503AEDC-23B9-422D-BA12-1B85B7B7EAA9 (AT) microsoft (DOT) com...
Since a local system account doesn't allow backing up to another drive,
I
made a new domain account so we could backup to a different drive than
where
SQL Server 2005 resides. What happened then was all the jobs created
under
the other account would not run. Do we have to recreate the jobs to run
under
the new account or is there a way to repoint these jobs for running
under
the
new account. Is it as simple as I need to add this account as sysadmin
on
sql
server?
--
Regards,
Pat



Reply With Quote
Reply
Page 5 of 5 < 1 2 3 4 5

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top