Community
Select to view content in your preferred language

Enterprise DB Connection Best Practice?

932
2
07-20-2023 05:36 AM
by Anonymous User
Not applicable
‎07-20-2023 05:36 AM

...

2 Replies
BillFox
by MVP Frequent Contributor
MVP Frequent Contributor
‎07-20-2023 08:28 AM

many different ways; depends on the workflows, versioning/reconcile/post and authentication options in use

0 Kudos
MarceloMarques
by Esri Regular Contributor
Esri Regular Contributor
‎07-20-2023 08:51 AM

You can see the database connection best practices on my community.esri.com blog.

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.

I recommend to not use the domain account to own data in the SQL Server Geodatabase.

For more best practices see my Production Mapping database guide book for SQL Server in the link below.

Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices

I hope this helps.

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |