SQL using Windows Service Account

crystaltaggart57 · November 4, 2015, 8:18pm

Hi there-
Is there a way to configure DF to use a Windows Service account for authentication instead of a username/password for MS SQL?

Thanks!

formerstaff · November 4, 2015, 8:27pm

we don’t currently support windows service account authentication for ms sql, only sql server authentication.

crystaltaggart57 · November 9, 2015, 9:18pm

Does DreamFactory encrypt the passwords in the database?

formerstaff · November 10, 2015, 3:16pm

Yes. Service usernames and passwords are stored encrypted. Admin users, and roles that you have given access to the system/service portion of the API have access to decrypt this information.

Topic		Replies	Views
Enduser Authentication - Restriction to sql Data Authentication & Security	1	1704	January 26, 2016
SQL Connection to Google Cloud SQL using SSL Connecting to SQL	3	3851	November 7, 2016
Using SQL for default Dreamfactory database Schema & Data	1	2063	October 30, 2014
About the Connecting to SQL category Connecting to SQL	0	4154	May 7, 2014
Lessons Learned with MS SQL Server Connecting to SQL	1	2775	June 7, 2022

SQL using Windows Service Account

Related topics