Community

Underlying DBMS error...Privileges User List error

775
3
04-30-2019 08:22 PM
EliasMartinson
by
New Contributor II
‎04-30-2019 08:22 PM

When I click "Add" in the Privileges window, instead of receiving the list of users, I receive the error below. If I click "OK", I can type in a user. I have been unable to find any help online.

0 Kudos
3 Replies
leomonterol
by Esri Contributor
Esri Contributor
‎05-01-2019 06:11 AM

Hi Elias

What version of ArcGIS Desktop and SQL Server are you working with?

Regards,

Leo

EliasMartinson
by
New Contributor II
‎05-01-2019 08:11 AM

I apologize for not including that initially. I am using ArcGIS Desktop 10.7 and SQL Server 2012. This has been an ongoing problem through 10.6 and 10.6.1, all with SQL Server 2012.

0 Kudos
leomonterol
by Esri Contributor
Esri Contributor
‎05-01-2019 08:26 AM

Hi Elias

Thank you for sending that information.

Just to confirm. Is that a SQL Server 2012 with no Service Pack? If yes, this may be a version compatibility issue. I've seen this behavior before and it is solved by upgrading the DBMS to a supported version. 

If you are using an ArcGIS Desktop 10.7 client, the earliest version of SQL Server you can connect to is Microsoft SQL Server 2014 SP3 (64-bit). See all SQL Server supported versions for ArcGIS Desktop 10.7 here.

 

If you are using an ArcGIS Desktop 10.6.x client, the earliest version of SQL Server you can connect to is Microsoft SQL Server 2012 SP3 (64-bit). See all SQL Server supported versions for ArcGIS Desktop 10.6.x here.

 

Regards,

Leo

0 Kudos