laptop and a wrench

Bug

Creating a SQL Server database connection in ArcGIS Insights fails if the database user is not granted the db_datareader role.

Last Published: April 17, 2020 ArcGIS Insights
Bug ID Number BUG-000129928
SubmittedApril 6, 2020
Last ModifiedJune 5, 2024
Applies toArcGIS Insights
Version found2020.1
Operating SystemWindows OS
Operating System Version2016 64 Bit
Version Fixed2021.1
StatusFixed

Workaround

Assign the db_datareader database role to the user and make a connection to SQL Server. Once the connection is successful, revoke the db_datareader database role if it is not needed for the user.

Steps to Reproduce

Bug ID: BUG-000129928

Software:

  • ArcGIS Insights

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options