Select to view content in your preferred language

Enterprise DB Connection Best Practice?

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


2 Replies
MVP Frequent Contributor

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

0 Kudos
Esri Regular Contributor

You can see the database connection best practices on my 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 | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov