July 15, 2002 at 2:57 pm
Hi all,
In order for me to work with the scheduler in MS SQL server 7.0, i need to have the SQL AGENT SERVICE up and running. However, when i go to services and click on start, it gives me an error saying unable to start sql service agent, windows 4.0 internal error. Then i click on startup to see the profile and the login says domainname\sqlservice, this seems to be fine. Since this is the same login for MSSQL SERVER service. So i am short of ideas..can you guys help me with this?
July 15, 2002 at 3:04 pm
Check the event log or the sql server agent log.
Steve Jones
July 15, 2002 at 3:11 pm
Hey this is what i get from sql server agent log
7/15/02 4:46:37 PM - ? [129] SQLServerAgent starting under Windows NT service control
7/15/02 4:46:37 PM - ! [298] SQLServer Error: 18456, Login failed for user 'sa'. [SQLSTATE 28000]
7/15/02 4:46:37 PM - ! [000] Unable to connect to server; SQLServerAgent cannot start
7/15/02 4:46:37 PM - ? [098] SQLServerAgent terminated (normally)
can this tell you something??
July 15, 2002 at 3:15 pm
steve,
i got it, i had changed the sa password previously and forgot to change it in the EM sql agent. I changed it now. Works fine.
thanks for your help
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply