New Item Data Store Database Relational DB Error

Question

Hello,

I am getting the following error when trying to create a new Data Store from the Portal. "The site must have access to the connection or location you specified in the previous step."

I get a similar error from the ArcGIS Pro client side:
"The connection property set was missing a required property or the property value was unrecognized.  Underlying DBMS error [[Microsoft][ODBC Driver 17 for SQL Server]SSPI Provider: No credentials were supplied, or the credentials were unavailable or inaccessible.  No Kerberos credentials available (default cache: KCM:) No extended error.

The error occurred creating a Data Store with newly issued database connection using Authentication Type: Operating System Authentication (from Windows).

Old Data Stores with database connections using Authentication Type: Database authentication work just fine (were created without errors).

The Enterprise deployment is on a Linux backend.

Any thoughts on what might be happening here and how to fix?

Thank you,
Tyler
Enterprise 11.3 LTS

TylerT · Answer

Esri Support does not believe this is supported, so let me ask about a workaround.

Does a publisher necessarily have to be the creator of the datastore?  The genesis of the original issue was when I proceeded to publish a layer using my Win Auth created feature class (schema table) and Win Auth SDE.  ArcGIS prompted the need to create a data store, even though we already have data stores created by DBO.  Is there any way to use the DBO data store from the Win Auth user?

Thank you,

Tyler
Enterprise 11.3

George Thompson · Answer

It does seem possible, but you will have to add the ArcGIS Server account to the SQL instance and allow access: https://enterprise.arcgis.com/en/server/11.3/manage-data/linux/connect-sqlserver.htm

DQT · Answer

Jake, thank you for the reply, wanted to answer on Tyler's behalf as we are working on this issue. The arcgis server service account does not have access to the enterprise geodb. Since our environment is mixed (ArcGIS Enterprise entirely running Linux) and the relational database MSSQL Server is running on Windows Server, we were able to get the connection working via dbauth mode.  Our database administrator wants to move off of dbauth permissions to use Windows Integrated authentication for more security.  I guess the question is if it is possible to use Windows auth (OS system authentication) in a mixed environment such as ours to create the datastore via portal?

V,r

-Eddie