nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL Server - Windows Authentication - Different User than logged onto client

EricMahaffey1

Is there a way to create a windows authenticated connection to SQL Server using a different account that is logged onto the client? I'm trying to build a map service that connects to data in SQL Server which has windows authentication only. A domain service account is the preferred choice for connecting to the data rather than using my personal domain account. I was hoping to use the "Create Database Connection" tool/script, however it doesn't allow me to enter domain account credentials when generating the connection file. Any ideas?

Find more posts tagged with

Accepted answers

AdamZiegler1

If you author the map to use windows authentication, that will carry through to the service creation. As long as the account running ArcGIS Server has access to the SQL Server instance/data the service will render. You will need to register the OS Authentication to the database as a registered database in ArcGIS Server.

Adam Z

All comments

EricMahaffey1

It worked like a champ once I added the GIS Server account to the DB, and defined select permissions. Thanks again for the clarification Adam

EricMahaffey1

Thanks for the quick response Adam. I'll give that a try. I was just assuming that the initial account used to make the DB connection would transfer when publishing the service. It makes sense that the account running ArcGIS Server would make the connection once published.

AdamZiegler1

Adam Z

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.