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?
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.