Post reply

LOG SHIPPING ERROR WHEN ADDING MONITOR

  • June 15, 2010 at 1:20 am

    #223802

    Hi Experts,

    I am getting erro while configuring log shipping with monitor server.

    Msg 32055, Level 16, State 2, Procedure sp_add_log_shipping_primary_database, Line 252

    There was an error configuring the remote monitor server..

    I create the same log shipping configuration without monitor server and its wotrking fine

    Please help

    TIA

  • June 16, 2010 at 1:13 am

    #1180789

    Hi,

    Might be this server is not in the same network.

    Try to ping to server and find if it is traceable.

  • June 16, 2010 at 1:53 am

    #1180802

    Thanks for the reply.

    I am able to ping the server without any issues...but still am getting the same error

  • June 16, 2010 at 2:04 am

    #1180804

    Now, kindly check the does remote connection is allowed for that server or not ( proposed Monitor Server).

    Check that you are mentioning correct server name / instance name with correct port number.

    Check if you have login permission on that server or not.

  • June 17, 2010 at 3:50 am

    #1181432

    Yes to all three questions

  • June 22, 2010 at 4:34 am

    #1183206

    Try domain account to connect , the domain account should be added to the admin group of the monitoring server.

    "More Green More Oxygen !! Plant a tree today"

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

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