Differences

This shows you the differences between two versions of the page.

--- mssql_alwayson_groups [2019/11/05 15:41] – [Configuration] andonovj
+++ mssql_alwayson_groups [2019/11/09 19:58] (current) – external edit 127.0.0.1
@@ Line 4: / Line 4: @@
 In order to configure a AlwaysOn Group in SQL Server you firstly must configure:
-  * Failover Windows Cluster
+  * Failover Windows Cluster (You can check how in the windows section: [[windows_advanced_failover|Failover Cluster Config]] )
   * 2 SQL Stand-alone Binary installations
@@ Line 58: / Line 58: @@
 The result of the configuration should be something like that:
-{{ :alwaysonconfigurationdone.jpg?400 |}}
+{{ :alwaysonconfigurationdonedb2.jpg?400 |}}
-You can use also the following script for manual configuration:
+You can use also the following script for manual configuration in the Appendix.
+After all that you should have all databases selected throughout the configuration in restoring mode ON the second machine:
+{{ :alwaysonconfigrunning.jpg?400 |}}
+I know that from security point of view, this isn't the best, but I try to make it working and later will improve security, I promise.
+=====Fixing Issues=====
+There were couple little problems, as always.
+====Wrong Service User====
+The default user didn't have right to access the DCOM, therefore I had to change the user which was used from Local user to SQLDOM\Administrator.
+====AlwaysOn Group Listener====
+The listener, I have decided to create it after I create the AlwaysOn group. So be sure to enable it after the creation if you didn't do it during.
+====Not Synchronizing====
+After the initial creation, the replicas were fine, but the database wasn't synching. So don't forgot to join the database to the group after that
+=====Appendix=====
+Manual AlwaysOn Script
 <sxh bash>
 --- YOU MUST EXECUTE THE FOLLOWING SCRIPT IN SQLCMD MODE.
@@ Line 136: / Line 161: @@
 GO
 </sxh>
-After all that you should have all databases selected throughout the configuration in restoring mode ON the second machine:
-{{ :alwaysonconfigurationdonedb.jpg?400 |}}
 =====Disable/Enable Jobs on Primary=====
 <sxh bash>