English

ArcGIS 10.5.1 (Desktop, Engine, Server) SQL Server Permissions Patch

Summary

This is a general cumulative maintenance patch for ArcGIS 10.5.1 clients connecting to SQL Server geodatabases.

Description

Introduction

Esri® announces the ArcGIS 10.5.1 (Desktop, Engine, Server) SQL Server Permissions Patch. This patch addresses permissions and other issues that may occur when connecting to SQL Server geodatabases. It deals specifically with the issue listed below under Issues Addressed with this patch.


Issues Addressed with this patch


  • BUG-000107499 - Spatial indexes are deleted in ArcMap while executing the Append tool as a sysadmin.
  • BUG-000107267 - Permissions granted at the schema level are not honored when permissions are cached during connection to SQL Server.
  • BUG-000106595 - ArcGIS Pro 2.0 and 10.5.1 Desktop require explicit object level select privileges for users to view SQL Server geodatabase data in the Catalog tree.
  • BUG-000106582 - Database Connection Fails to a Field Case Sensitive Database in ArcMap.
  • BUG-000105319 - Selecting over 10,000 features and opening attribute table for registered database view returns a warning message, "There was an error reading the table selection. Clear selection to correct. ODBC Driver Manager Invalid cursor state."
  • BUG-000104745 - The Register with Geodatabase tool fails in a database view if it contains null geometry.
  • BUG-000104225 - The session-based log file causes the reconciliation to hang with one particular SQL Server geodatabase.

Installing this patch on Windows


Installation Steps:


ArcGIS 10.5.1 Desktop, Engine or Server must be installed before installing this patch.

  1. Download the appropriate file to a location other than your ArcGIS installation location.

  2. ArcGIS 10.5.1   Checksum (Md5)
         
    ArcGIS Desktop
    Background Geoprocessing (64-bit)
    ArcGIS-1051-BGDT-SSP-Patch.msp A1189CF30AB70D5EC9B6C715DD90D024
         
    ArcGIS Engine
    Background Geoprocessing (64-bit)
    ArcGIS-1051-BGE-SSP-Patch.msp D2BAE05B1B734A42311F6389B9AC06EE
         
    ArcGIS Desktop ArcGIS-1051-DT-SSP-Patch.msp A7844915B75E652256AC6E66902ED4D5
         
    ArcGIS Engine ArcGIS-1051-E-SSP-Patch.msp BBE6B35335D5F9E5D9F8D54E60876FFE
         
    ArcGIS Server ArcGIS-1051-S-SSP-Patch.msp 3AF83EDE97B65462A5F67DE2834BBFEC
         

  3. Make sure you have write access to your ArcGIS installation location.

  4. Double-click ArcGIS-1051-<Product>-SSP-Patch.msp to start the setup process.

    NOTE: If double clicking on the MSP file does not start the setup installation, you can start the setup installation manually by using the following command:

    msiexec.exe /p [location of Patch]\ArcGIS-1051-<Product>-SSP-Patch.msp


Patch Updates

Check the Patches and Service Packs page periodically for the availability of additional patches. New information about this patch will be posted here.

How to identify which ArcGIS products are installed

To determine which ArcGIS products are installed, choose the appropriate version of the PatchFinder utility for your environment and run it from your local machine. PatchFinder will list all products, hot fixes, and patches installed on your local machine.

Getting Help

Domestic sites, please contact Esri Technical Support at 1-888-377-4575, if you have any difficulty installing this patch. International sites, please contact your local Esri software distributor.