Could not retrieve backup settings for primary ID in Log shipping
- by user1723139
I am doing log shipping between two Amazon EC2 instances running Windows Server 2008 R2 with SQL Server 2008 R2 standard edition.
Both the instances are in the same domain and I can access the shared folders between the instances. The SQL server service account, agent service account are all running under a domain account.
When I activate log shipping (with stand by mode restore in secondary server), the initial backup gets restored on the secondary.
After that the backup operation is getting failed and i get the following error message:
*** Error: Could not retrieve backup settings for primary ID 'xxxxxx-xxxx-xxxx-xxxx-4d772cd7337e'.(Microsoft.SqlServer.Management.LogShipping) ***
*** Error: Failed to connect to server IP-0A7653F2.(Microsoft.SqlServer.ConnectionInfo) ***
****** Error: A network-related or instance-specific error occurred while establishing a connection to SQL Server.********
**The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)(.Net SqlClient Data Provider) ***
**----- END OF TRANSACTION LOG BACKUP -----****
Any ideas?