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
Thank you, but this document did not answer my questions.
The article does not tell which features of the SQL Server installation are required, if Appian supports SQL Always on Availability Group, if I need the Client Tools SDK or what permissions are required for the account that connects the application server to my SQL Server.
I have an additional question
Can the Appian web server connect to my SQL Server using an Active Directory Account or must it use the SQL Login.
I look forward to hearing from you.
Just two quick question for you before I dig out some other info ...
1. Is this an on premise installation of Appian or Cloud,
2. Are there any patterns currently in your organisation for use of SQL Server as an RDBMS for a web application or is this the first?