I am an SQL Server Database Administrator and I will be migrating the Appian database from a stand alone SQL 2019 server to a clustered SQL 2022 server that has Always On Availability Group. The Availability Group will be stretched across two subnets and will employ a listener for the application to connect.
My question are:
A: Do you see any problems with the configuration I am proposing for the SQL server set up - SQL AG and listener
B: What features do I need to have installed on the SQL Server.
C: Do I need the Client Tools SDK feature installed on my SQL server - I found it installed on the existing server
D: What SQL Database permission are required for the Appian user that connects the app to the SQL server. I like to work on the least privilege concept
Please if you have the answers to these question or if you have a document that illustrates my SQL settings I would appreciate it
I look forward to hearing from you
Jeffrey
Discussion posts and replies are publicly visible
Hi Jeffrey, hopefully these documents will be useful. It depends on whether you are a cloud or on prem Appian installation for some of this to be relevant, but hopefully it gets you started ...
https://docs.appian.com/suite/help/25.1/Microsoft_Azure_DB_Integration_Appian_Cloud.html
https://docs.appian.com/suite/help/25.1/Configuring_Relational_Databases.html#sql-server
It helped me, Thank you so much for the info.