Post reply

Can't create Maintenance Plan in SQL 2005 Cluster

  • December 26, 2008 at 1:10 pm

    #128772

    Hi all,

    When I try to create maintenance plain in s sql 2005 cluster, I got this message:

    The action you attempted to perform on a remote instance of SQL server has failed because the action requires a SQL server component that is not installed on the remote computer. To proceed, install SQL server 2005 management tools on the remote computer, and then try again.

    But I have SQL server 2005 management tools installed on the remote computer. so it's strange. Any idea?

    Thanks a lot

  • December 26, 2008 at 1:25 pm

    #917916

    Are all nodes and the client at the same patch level?

  • December 26, 2008 at 1:27 pm

    #917918

    I think so but do you know how to check that?

    Thanks a million!

  • December 26, 2008 at 4:46 pm

    #917950

    Run the following statements on all nodes and compare the same.

    Select serverproperty('productlevel')

    go

    Select serverproperty('productversion')

    MJ

  • December 26, 2008 at 8:49 pm

    #917973

    Ran on both nodes, all came back with:

    sp2

    9.00.3282.00

    Any thoughts? thanks in advance

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

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