• - Win. (8/17/2010)


    Hi,

    It was failed when server was rebooted. And we updated the domain account and password and tried restarting the services, but still it failed.....

    Please find the below error log.

    2010-06-25 02:52:33 - ? [100] Microsoft SQLServerAgent version 9.00.4035.00 (x86 unicode retail build) : Process ID 5172

    2010-06-25 02:52:33 - ? [101] SQL Server REDMOND\XXXX version 9.00.4035 (0 connection limit)

    2010-06-25 02:52:33 - ? [102] SQL Server ODBC driver version 9.00.4035

    2010-06-25 02:52:33 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is REDMOND\XXXX

    2010-06-25 02:52:33 - ? [310] 8 processor(s) and 4096 MB RAM detected

    2010-06-25 02:52:33 - ? [339] Local computer is REDMOND\XXXX running Windows NT 5.2 (3790) Service Pack 1

    2010-06-25 02:52:33 - ? [432] There are 11 subsystems in the subsystems cache

    2010-06-25 02:52:35 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent

    2010-06-25 02:52:35 - ? [129] SQLAgent$REDMOND\XXXX starting under Windows NT service control

    2010-06-25 02:52:35 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect

    2010-07-05 11:49:16 - ? [130] SQLAgent$REDMOND\XXXX stopping because of Windows shutdown...

    2010-07-05 11:49:23 - ! [165] ODBC Error: 0, Driver's SQLAllocHandle on SQL_HANDLE_ENV failed [SQLSTATE IM004]

    2010-07-05 11:49:23 - ! [382] Logon to server 'REDMOND\XXXX' failed (SaveAllSchedules)

    2010-07-05 11:49:32 - ! [359] The local host server is not running

    2010-07-05 11:49:32 - ? [098] SQLServerAgent terminated (normally)

    Does mssql service also running under this account??? just for testing purpose change the srvice account to local or add the service account to local admin (although its not recommended) but this will confimr if this is due to any permissions issues.... secondly have u added this new domain login for having "log on as service" rights??

    Tell me if this helps.

    Rohit