Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem Setting up SQL Logshipping Monitor Serve Expand / Collapse
Author
Message
Posted Saturday, December 15, 2012 12:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 20, 2013 12:01 AM
Points: 1, Visits: 17
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.
Post #1396879
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse