SQL Server Performance Forum – Threads Archive

Windows Scheduled task

Hi Well this is for sure not appropriate forum to ask this question, but still I hope someone might be able to help. I have scheduled task that was running for years. It doesn’t run anymore reporting status :could not start ,but Last result 0x0. And error log says logon failure. Well login I use in "Run as" is for sure valid (Administrator group) Then I’ve read in this article suggestion to remove this "Run as" login at all.Tried this<img src=’/community/emoticons/emotion-2.gif’ alt=’:d’ />idn’t work.Something I am doing wrong? http://www.onlinetoolworks.com/docs/winTaskSched.doc</a>

Check: http://support.microsoft.com/default.aspx?scid=kb;en-us;308558 Is for XP, but you never know….
Luis Martin
Moderator
SQL-Server-Performance.com The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.

I just noticed that after windows reboot (and we have a task to do this daily)
some services and some scheduled task will not start because password incorrect
Why would that be?

Did you change something in Windows,ie: promote domain? Luis Martin
Moderator
SQL-Server-Performance.com The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.

I defenetely don’t.
But you just said what I keep thinking for a couple of days.
I keep thinking about some policy that might have been changed.

I think they are dependent on some account for starting up and the password for the account has changed. Gaurav
Moderator
Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.

Ensure the login used for MSSQLServer & SQLAgent services is secure and specified correctly when its used anywhere else. To know the status of this job refer to SQLAgent log and can take help of PROFILER to track the activity. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

They do depend on user acount but it didn’t changed.
And even if it did, I am reentering this login everytime to start the services.
But every other reboot service reporting "cannot start because of login failure"
I also login into computer with the same username and password that being used
for this services and scheduled tasks that cannot start after reboot.

What is the reason behind rebooting the Server every now and then?
Are there any recent changes to the windows & SQL? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>