SQL Server 2022 Requirements

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

Parents Reply
  • 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. 

Children