Post reply

URGENT - SQLAgent not autostarting

  • May 8, 2002 at 7:50 am

    #58164

    Hi All,

    We're using MSSQL 2000 on W2K. When we change the the autostart to "Allow service to interact with desktop" is opens a command box. I've attached a picture..

    If I unclick the "Allow service to interact with desktop" it works just fine.

    Has anyone seen this before or know how to fix this?

    Sandy Schaefer


    Sandy Schaefer

  • May 8, 2002 at 7:51 am

    #428702

    Oh yeah, one more thing. If we close the box the service doesn't start.

    Sandy Schaefer


    Sandy Schaefer

  • May 8, 2002 at 8:42 am

    #428712

    The service shouldn't need to interact with the desktop. Question: are the binaries for SQL Server stored on a drive local to the computer?

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • May 8, 2002 at 8:49 am

    #428715

    We're trying to run an .exe from a SQLAgent job. The exe hangs when we use cmdshell but doesn't with it's through a DTS package. However, for the DTS package to run the service seems to be need to be set to interact with the desktop. Otherwise it completely bombs. Sorry to have to ask this but what are "binaries for SQL Server"?

    Sandy Schaefer


    Sandy Schaefer

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply