Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2012
    Posts
    108
    Provided Answers: 1

    Unanswered: Unable To Start SQL Server Agent

    Hi all,

    Using SQL Server Express 64-bit.
    Trying to Start Server Agent from Config Manager - both Server and Browser are running.

    I followed the steps in this post from cenkyurtseven http://www.dbforums.com/showthread.php?t=992722 to add Server Roles to NT Authority\System.

    But I still cannot start the Server Agent.

    The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details.
    My end-in-mind:
    I can do everything I need to do in SSE - so far
    I can link to table in SSE from Access
    I can create Access queries against those Linked Tables
    I cannot create a PivotTable in Excel against those queries
    I can create a PivotTable in Excel against standard Access Table/Query

    When I try to create a PivotTable against a Query that is based on a Linked Table, I receive this error:

    The query did not run, or the database table could not be opened.
    Check the database server or contact your database administrator. Make sure the external database is available and hasn't been moved or reorganized, then try the operation again.
    I appreciate any thoughts on this issue.

    thx
    w

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    and what does the error log report?
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    SQL Server Agent isn't included as part of the Express editions.
    George
    Home | Blog

  4. #4
    Join Date
    Feb 2012
    Posts
    108
    Provided Answers: 1
    Thanks guys,

    If SQL Server Agent is not incl. in SSE, do you have other ideas as to why I cannot create a PivotTable in Excel using the Query connected to the Linked Table as the Data Source?

    thx
    w

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •