https://community.esri.com/t5/arcgis-enterprise-questions/enterprise-db-connection-best-practice/m-p/1310089#M36587 <P>You can see the database connection best practices on my community.esri.com blog.</P><UL><LI><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId--1336696408" target="_blank" rel="nofollow noopener noreferrer">Database Connections Best Practices</A></LI></UL><P>You can use a domain account to run the ArcGIS Server Windows Service and add the same domain account in the SQL Server database and grant read-write access.</P><P>I recommend to not use the domain account to own data in the SQL Server Geodatabase.</P><P>For more best practices see my Production Mapping database guide book for SQL Server in the link below.<BR /><BR /><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351" target="_blank" rel="noopener">Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices</A><BR /><BR />I hope this helps.</P> Thu, 20 Jul 2023 15:52:12 GMT MarceloMarques 2023-07-20T15:52:12Z https://community.esri.com/t5/arcgis-enterprise-questions/enterprise-db-connection-best-practice/m-p/1309986#M36584 <P>...</P> Mon, 25 Mar 2024 13:02:44 GMT https://community.esri.com/t5/arcgis-enterprise-questions/enterprise-db-connection-best-practice/m-p/1309986#M36584 Anonymous User 2024-03-25T13:02:44Z https://community.esri.com/t5/arcgis-enterprise-questions/enterprise-db-connection-best-practice/m-p/1310077#M36585 <P>many different ways; depends on the workflows, versioning/reconcile/post and authentication options in use</P> Thu, 20 Jul 2023 15:28:13 GMT https://community.esri.com/t5/arcgis-enterprise-questions/enterprise-db-connection-best-practice/m-p/1310077#M36585 BillFox 2023-07-20T15:28:13Z https://community.esri.com/t5/arcgis-enterprise-questions/enterprise-db-connection-best-practice/m-p/1310089#M36587 <P>You can see the database connection best practices on my community.esri.com blog.</P><UL><LI><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351#toc-hId--1336696408" target="_blank" rel="nofollow noopener noreferrer">Database Connections Best Practices</A></LI></UL><P>You can use a domain account to run the ArcGIS Server Windows Service and add the same domain account in the SQL Server database and grant read-write access.</P><P>I recommend to not use the domain account to own data in the SQL Server Geodatabase.</P><P>For more best practices see my Production Mapping database guide book for SQL Server in the link below.<BR /><BR /><A href="https://community.esri.com/t5/mapping-and-charting-enterprise-databases/mapping-and-charting-solutions-mcs-enterprise/ba-p/893351" target="_blank" rel="noopener">Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices</A><BR /><BR />I hope this helps.</P> Thu, 20 Jul 2023 15:52:12 GMT https://community.esri.com/t5/arcgis-enterprise-questions/enterprise-db-connection-best-practice/m-p/1310089#M36587 MarceloMarques 2023-07-20T15:52:12Z