Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2008
    Posts
    23

    Unanswered: Cant see maintenance plan icon in mgmt studio

    hi guys,

    i have 2 instances of MSSQL 2005 installed on 1 machine. 'MSSQLSERVER' and 'SQL'.
    On 'MSSQLSERVER', i can see the sql agent and its services is running. but on 'SQL', i cant see the sql agent and the maintenance plans.

    Is there a need to re-install the sql server again? else i cant create maintenance plans for my 'SQL' instance'


    Appreciate any help.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Is SQL Agent enabled (see surface area config) for this instance?
    George
    Home | Blog

  3. #3
    Join Date
    Mar 2008
    Posts
    23

    ---closed---

    hi..i found the answer. 1 of the instances is in express edition, therefore there is no sql agent for that...thanks alot for the help.


    ---CLOSED---

Posting Permissions

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