Select to view content in your preferred language

Do Registered Data Store Authentications (Username/Password) expire for ArcGIS Portal/Server connections?

206
1
06-04-2025 12:41 PM
CameronLacelle
Frequent Contributor

Our team noticed this morning that some layers on our ArcGIS Enterprise internal applications were coming up with "data is inaccessible" errors with ERROR 001487. I looked into this error and it seemed to be something related to it can't find the corresponding dataset/data source on the server side. So I went into our server manager and restarted a few of the services, which worked for some, but not others to resolve their issues on the application/portal side.

 

Then I went into ArcGIS Pro to the "Manage Registered Data Stores" pane from the Share tab, and went into several of our registered data stores that connect to SQL databases, Enterprise Geodatabases (also SQL-based), and went in, re-entered the password in the connection window, re-validated, and saved this. Then went into the server manager and restarted the remaining services that were causing errors and this fixed every single one. So I am led to believe it was some sort of authentication thing where the password for the data store connection needed to be entered again.

 

Just wondering if anybody else has experienced this type of thing and whether this is an expected function where authentications to registered data stores need to be re-authenticated and validated like an expired token or something. Or perhaps if this is not directly Esri-related, if it may be something else I should chat with my IS team about.

0 Kudos
1 Reply
sxw_eaglegis
Esri Contributor

Hi there,

I have a feeling it's more on the SQL server side or something network related. Are the connections using SQL server authentication? with no password policy enforced? 

Can you tell when the connections stop working from the ArcGIS Server logs? just wondering if there is a maintenance task causing the issue.

Maybe the connections are getting dropped, what are the instance settings for the services (i.e. shared instances or dedicated?) Is it all services that connect to data in SQL Server or just specific ones that stop working?

And what version of ArcGIS Enterprise? 

Might just have to do a bit of investigation to try and figure it out unfortunately. I have seen this issue occur randomly, but was many years ago and only occurred once every couple of years or so.

0 Kudos