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
SQL Server 2022 brings powerful enhancements, but it’s important to align system requirements with your Appian environment. Make sure your hardware, OS, and SQL configurations meet the performance needs. Proper planning now can prevent issues during deployment and ensure smoother integration with Appian’s features. I’ve used a few services before, but none were as smooth as Academized. I went through https://academized.com/ and requested a paper on gender studies. The writer had deep knowledge of the topic and was happy to revise one paragraph I wanted tweaked. If you need an essay writing service that actually listens, this is the one to go for.