Has any setup an AD SQL Server connection with ACF...
# adobej
Justin Hinden
03/25/2022, 4:19 PMHas any setup an AD SQL Server connection with ACF? I found an old article on Stack Overflow. I was just wondering if anyone has done it and has any suggestions or tips. Thanks
c
cfvonner
03/25/2022, 4:21 PMDo you mean connecting using the Windows Integrated security? So you don't have to pass a username/password to make the DB connection?
👍 1
cfvonner
03/25/2022, 4:27 PMIf so, you need to run your ColdFusion service as an AD account, and then add that AD account to SQL Server as a login to the server and a user to the database, then grant that user the appropriate role/permissions on the database.
j
Justin Hinden
03/25/2022, 5:26 PMThat was my understanding of how it worked. Are there known issues when you run the ColdFusion service as the AD account? For example giving read/write access to folders within cfusion?
c
cfvonner
03/25/2022, 6:00 PMYes. I'd look at the Lockdown guide for your release of ColdFusion, as it has good discussions of folder permissions that need to be set. I think maybe the Lockdown guides actually recommend running CF as a Windows account.