06-16-2015 07:45 AM
Our DBA has questions about what Hyland recommends as far as setting up our SQL 2012 with Availability Groups (AG). We read through the Hyland OnBase Database Reference Guide but did not see answers to specific questions. Here are three questions:
1) What type of AG does the product need? Does it need a listener for full failover properties, and if so synchronous rather than async.? Does Hyland want bilateral read/write, or will one side be transactional and the other read only?
2) What type of access is needed; once put a db into production DBO privileges can be provided, but SA privileges on shared DB servers are not given out to vendor products – unless its segregated into a “vendor product only” instance. This is because anyone with SA privileges can – without knowing – hose the environment for other applications.
3) We need assurance that however it is configured, it will not invalidate our warranty.
06-17-2015 12:22 PM
Hello and thank you for using Community!
I believe you can find the specific answers to your questions about Availability Groups on MSDN: https://msdn.microsoft.com/en-us/library/ff877884(v=sql.110).aspx
We do not have any rules or recommendations on how to setup the Availability Group. Below is taken from the article above:
In terms of access, the sysadmin server role is required to create the availability group. Once it is created the security settings on the primary replica are persisted to the secondary database. OnBase does not require SA privileges so it is up to the customer to manage those privileges as needed.
Using Availability Groups does not void the Hyland maintenance agreement. The software is modifying the primary database and then those modifications are being propagated to the secondary replica which is allowed. Any direct database modification without Hyland approval can result in a voided maintenance agreement.
Let me know if you have any additional questions.
Carly Tatnall
Database Support Specialist
06-17-2015 12:22 PM
Hello and thank you for using Community!
I believe you can find the specific answers to your questions about Availability Groups on MSDN: https://msdn.microsoft.com/en-us/library/ff877884(v=sql.110).aspx
We do not have any rules or recommendations on how to setup the Availability Group. Below is taken from the article above:
In terms of access, the sysadmin server role is required to create the availability group. Once it is created the security settings on the primary replica are persisted to the secondary database. OnBase does not require SA privileges so it is up to the customer to manage those privileges as needed.
Using Availability Groups does not void the Hyland maintenance agreement. The software is modifying the primary database and then those modifications are being propagated to the secondary replica which is allowed. Any direct database modification without Hyland approval can result in a voided maintenance agreement.
Let me know if you have any additional questions.
Carly Tatnall
Database Support Specialist
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.