Luis Zambrano Posted January 11, 2017 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. Link to comment Share on other sites More sharing options...
support Posted January 11, 2017 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now