Register SQL Server database using operating system authentication

Scott-Shavnore · ‎09-24-2024

Unable to register a SQL Server database as a registered data store with ArcGIS Server federated with Portal using operating system authentication. Using SQL Server authentication the registration is successful. The error returning when using Windows service account is:

The connection property set was missing a required property or the property value was unrecognized. Underlying DBMS error[[Microsoft][ODBC Driver 18 for SQL Server]SSPI Provider: No credentials were supplied, or the credentials were unavailable or inaccessible. No Kerberos credentials available (default cache: DIR:) No extended error.], The connection property set was missing a required property or the property value was unrecognized. Underlying DBMS error[[Microsoft][ODBC Driver 18 for SQL Server]SSPI Provider: No credentials were supplied, or the credentials were unavailable or inaccessible. No Kerberos credentials available (default cache: DIR:) No extended error.]

Deployed ArcGIS Enterprise 11.1 on Linux - SUSE Enterprise 15.

SQL Server 2019 running on Windows 2022. ODBC driver version 18 installed on AGS server.

Using a service account on the same domain as the servers.

Asrujit_SenGupta · ‎09-24-2024

Connect to Microsoft SQL Server from ArcGIS

Does the service account have access to the SQL Server instance?

From the link above:

If you use operating system authentication or Entra Integrated authentication to connect, ensure that SQL Server or Azure SQL Database can authenticate the ArcGIS Server account.

Tip:
Ensure the account used for the connection has the appropriate privileges on the data that the account needs to access. If the connection uses operating system authentication and you will publish web services using this connection, ensure that the ArcGIS Server account has the appropriate privileges on the data included in the web service. See Privileges for geodatabases in SQL Server and Privileges for using ArcGIS with a SQL Server database for more information.

Scott-Shavnore · ‎09-24-2024

Thank you for the response.

Yes, the service account has access to the instance with elevated privileges. I am able to connect to the SQL Server instance using the service account from ArcGIS Pro and then publish data as a hosted feature layer.