topic Re: Underlying DBMS error...Privileges User List error in Geodatabase Questions

Underlying DBMS error...Privileges User List error

EliasMartinson — Wed, 01 May 2019 03:22:10 GMT

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.

Re: Underlying DBMS error...Privileges User List error

leomonterol — Wed, 01 May 2019 13:11:20 GMT

Hi Elias

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

Regards,

Leo

Re: Underlying DBMS error...Privileges User List error

EliasMartinson — Wed, 01 May 2019 15:11:20 GMT

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.

Re: Underlying DBMS error...Privileges User List error

leomonterol — Wed, 01 May 2019 15:26:19 GMT

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