Post reply

Can not create a maint plan on 64 Bit

  • January 9, 2007 at 10:26 am

    #122224

    Hi,

    I have a new install for SQL 2005 on 64 Bit, set up a mirror to another server and I can not create a maint plan on the Principal.

    - I am logged to LOCAL server. Just in case also tried connecting to the local server by name in Management Studio

    - Management tools including Management Studio, Profiler etc are installed. The installation has a mix of BINN directories (by default) under C:\Program Files)\Microsoft SQL Server\90\Tools\Binn   C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn  C:\Program Files\Microsoft SQL Server\80\Tools\Binn   C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn

    Is the server get confused between the directories?

    - Error message when clicking on New Maintenance Plan:

    ===================================

    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. For more information, see "How to: Install SQL Server 2005 (Setup)" in SQL Server 2005 Books Online, or find the article on MSDN at  http://go.microsoft.com/fwlink/?LinkID=57083 . (ObjectExplorer)

    ------------------------------

    For help, click: http://go.microsoft.com/fwlink/?LinkID=57083

    ------------------------------

    Program Location:

       at Microsoft.SqlServer.Management.DatabaseMaintenance.MaintDesignerMenuHandler.Invoke()

    Regards,Yelena Varsha

  • January 9, 2007 at 11:12 am

    #682115

    Figured it out: it was Integration Services that was not installed.

    Regards,Yelena Varsha

  • January 9, 2007 at 3:33 pm

    #682220

    Hehe ... I was biten by that too


    * Noel

  • January 9, 2007 at 4:12 pm

    #682242

    Don't you love error messages about Management Tools?

    Regards,Yelena Varsha

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

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