During the Database Replication process you may occasionally receive an alert such as the one below when attempting to start a replication, or when testing the configuration. If you were able to open the Replication Wizard at all, this indicates that the SQL Server is in fact running. This alert may be resolved in several ways.
1. Export the Server Configuration
To ensure that the IP address and port number in use for replication are correct, it is recommended that you export the server configuration much like you would have done in the Initial Setup. As such, please navigate to File > Maintenance & Reports > Administrator and select the Create Data Copy Script button while holding the Alt/Option key. In this window, select the ‘Export the Server Configuration’ button and you will be prompted that the replication settings have been saved. You can select OK on this alert, then close the Replication Settings window, as well as the Maintenance & Reports window. Navigate to File > Quit to exit Genie Client. Once complete, you may try to perform the replication again.
2. Restart the SQL Server
Although the SQL Server is running, it may need a restart in order to perform database replication. The SQL Server can be restarted through Genie Client while users are accessing Genie Client. This should not be performed if any other users are actively performing database replication during this time. Follow the steps below to restart the SQL Server.
- Launch and log in to Genie Client as normal.
- Navigate to File > Maintenance & Reports > Server Admin Window.
- Select the SQL Server tab at the top of the screen and the State should be Started, as in the example below.
- Select the Stop SQL Server button. You will note that the State will change to Stopped.
- Wait 10 seconds, then select the Start SQL Server button. The Uptime counter should begin.
- Close the Server Admin window and attempt to perform the replication again.
Comments
0 comments