Re: How can I start SQL Server Agent?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: JD (joeydba_at_yahoo.com)
Date: 12/27/04

  • Next message: Sunny: "Re: How can I start SQL Server Agent?" 
    Date: Mon, 27 Dec 2004 16:24:22 -0600

    Sunny,
        What type of errors are you getting when trying to start the agent? How
    are you trying to start it now? Do you have access to the event viewer for
    the system that SQL Server is installed on? If so, looking at that will give
    you some indications as to why the server agent won't start.

    JD

    "Sunny" <sunny_1178@hotmail.com> wrote in message
    news:%23qFDwFG7EHA.2600@TK2MSFTNGP09.phx.gbl...
    > SQL 2k is installed on Win2k server. I am not in admin group on Win2k
    > server. I am managing SQL server through Enterprise Manager on my Win2K
    > client and I have sys admin rights. My SQL server Agent is not running and
    > its not allow me to start server agent. How can I start it?
    >
    > Thanks.
    >
    >

  • Next message: Sunny: "Re: How can I start SQL Server Agent?"

    Relevant Pages

    • Re: Data reader / Serverside cursor
      ... Hitchhiker's Guide to Visual Studio and SQL Server ... When the first few rows are found, the agent tells the client that there is a resultset available to process. ... To "lock down" the rows, you're going to need a Transaction with a "repeatable read" option set. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Network traffic with transactional replication with immediate updates (SQL 2005)
      ... publisher/distributor running on the main office and a subscriber at the ... This is a new SQL Server 2005 behaviour, ... the agent should execute them (maybe the agent just ... I cannot find a way to explain why Distributor Agents are to ...
      (microsoft.public.sqlserver.replication)
    • Re: Network traffic with transactional replication with immediate updates (SQL 2005)
      ... publisher/distributor running on the main office and a subscriber at the ... the agent should execute them (maybe the agent just launches ... Looking for a SQL Server replication book? ... I cannot find a way to explain why Distributor Agents are to ...
      (microsoft.public.sqlserver.replication)
    • Re: SQL Server 2005 replication monitor questions
      ... >> To get to the agents expand SQL Server Agent jobs, ... click on your publication in Enterprise ... >> bottom half you will see your snapshot and distribution agent. ... >> monitor it there (through replication monitor). ...
      (microsoft.public.sqlserver.replication)
    • Re: Server CE 2.0 Merge Replication
      ... This morning I am not able to access sscesa20.dll both from the emulator nor ... To change your connection settings, ... > your first goal should be to access the server agent from Pocket IE ... >> My SQL Server instance name be YYY ...
      (microsoft.public.sqlserver.ce)