Luis Zambrano 0 Posted January 11, 2017 Report Share Posted January 11, 2017 While installing the secondary node to complete the High Availability install and features, we are getting a frozen installation session. I have attached screenshots of the installation process ... Screenshot 1: test connection to database successful from server node 2. We selected the "connect to blank database" option Screenshot 2: after clicking NEXT, screen just stays frozen on "creating tables, please wait ..." Screenshot 3: database creation log Nothing occurs in the "creating tables, please wait" screen. I have confirmed that the database was created in mixed-mode. Also the database is accessible with no issues from server node #1. Quote Link to post Share on other sites
support 207 Posted January 11, 2017 Report Share Posted January 11, 2017 Hi Luis, Sorry your're having some issues with this, and I think I can see what the issue is. You are not meant to be using the 'Connect to Blank Database', because this process will actually create the tables for you - which is not the normal process for setting up the HA instance. The process is meant to be: Use the 'Create New database' tab which will create an empty database Then when you follow the rest of our HA Installation instructions, the SQL transactional replication will create all the tables and move the data across. You can find a copy of the HA install instructions here - https://www.clickstudios.com.au/downloads/version7/High_Availability_Installation_Instructions.pdf If the database already exists with tables and data in it, then you will need to do the following: Copy across the web.config file from your primary server to your HA server Modify the database connection string as appropriate and set the PassiveNode key to true We hope this helps. Regards Click Studios Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.