Problem Setting up SQL Logshipping Monitor Serve

• hamideh.rahmati

  Valued Member

  Points: 65

  More actions

  December 15, 2012 at 12:05 am

  #266251

  Hi

  I'm trying to set up log shipping between 3 SQL Server 2008R2 servers, where there is a Primary server and two secondary server. One secondary is in NORECOVERY mode and the other secondary is in STANDBY mode. I also consider a Monitor server.

  There is no problem up to here.

  When I get right to the end of the process and click the final OK, the process begins and every step is successful until the step of Monitor server which is the last step. I get the following message and I dont know what the problem is:

  TITLE: Microsoft SQL Server Management Studio

  SQL Server Management Studio could not save the configuration of 'X' as a Primary.

  ADDITIONAL INFORMATION:

  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

  There was an error configuring the remote monitor server. (Microsoft SQL Server, Error: 32055

  The SQL Server and SQL Server Agent service account on all 4 servers are started by a domain server which is a member of local Administrators Group and also has a role of sysadmin.