Hey Guys,

Thanks alot for your feeback I really appreciate it. I talked to Info Sec regarding the roaming profile and they said it usually happens on unsuccessful logins. I said ok , so I go and try logging in under "What I thought was being used as the start up account" and I logged on successfully.

Finally! We noticed that the builtin\administrator group was removed because we had no control on who is local admin on the servers so the id was not being authenticated. We noticed that there has been obviously a change and we added the account back in and changed the start up account unders sql agent and it worked fine.

WAIT !! KEEP READING.....

SQL Agent is working fine now but why was sql server still running before then? It uses the same login ....Twlight Zone!

Another time another dollar...:) Thanks again.