hi everyone, In microsoft windows 2003 server, i do run teh ssis and ssrs packages. I tried automating it. But the sql server is in stopped state. I have tried it with local and network systems. But unsuccessful. and i have disabled the VIA protocol. still the server agent is not working. Can anyone please help me, as i tried my best and i am not able to find the solution. regards raghu

raghu Any entries in ERROR.LOG, SQLAGENT.OUT,EventViewer? Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hi Dimant, I have checked through the SQLAGENT.OUT and found the following error. 2011-01-12 14:34:59 - ! [298] SQLServer Error: 17750, Could not load the DLL xplog70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [SQLSTATE 42000] (ConnCacheSubsystems) 2011-01-12 14:34:59 - ! [449] Failed to enumerate subsystems (reason: Could not load the DLL xplog70.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). [SQLSTATE 42000] (Error 17750)) 2011-01-12 14:34:59 - ? [432] There are 0 subsystems in the subsystems cache 2011-01-12 14:34:59 - ! [000] Failed to load any subsystems. Check errorlog for details. 2011-01-12 14:34:59 - ? [098] SQLServerAgent terminated (normally) raghu