Patches and updates
ArcSDE 9.2 SP 6 SQL Server 2000 Permissions Patch
Summary
Description
ESRIĀ® announces the ArcSDE 9.2 SP 6 SQL Server 2000 Permissions Patch. This patch fixes an issue with SQL Server 2000 users who are members of database or server roles not being able to see data that they do not own. We recommend that anyone using ArcSDE 9.2 SP 6 with SQL Server 2000 download and install this patch at their earliest convenience. It deals specifically with the issues listed below under Issues Addressed with this Patch.
Issues Addressed with this Patch
- NIM045639 - Users who are members of database or server roles like sysadmin or db_datareader cannot see data that they do not own.
- Description: After applying the ArcSDE 9.2 Connection Performance and Geodatabase Repair Patch, the ArcSDE 9.2 SP6 Memory Allocation Patch, or the ArcSDE 9.2 SP6 Compress with Concurrent Editors Patch, users who inherit permissions from membership in SQL Server roles such as sysadmin (DBO), db_owner, or db_datareader can no longer see data that they do not own and have not been explicitly granted SELECT permission on. This affects SQL Server 2000 only. Applying the Permissions patch will resolve this problem, allowing users to see data correctly again.
Files Installed in this Patch
- ArcSDE\bin folder:
- giomgr.exe
- gsrvr.exe
- gsrvrsql92.dll
- sde.dll
- sdegdbrepair.exe
- sdesqlsrvr92.dll
ArcSDE\lib folder:
- jsde92_sdk.jar
ArcSDE SDK/Client:
- bin\gsrvrsql92.exe
- bin\sde.dll
- bin\sdesqlsrvr92.dll
- lib\jsde92_sdk.jar
- giomgr.exe
Installing this Patch
Since this Patch replaces 9.2 Service Pack 6 files, you must have ArcSDE 9.2 Service Pack 6 installed before you can install this Patch.
- Install this Patch using an administrator account. Make sure you have write access to the ArcSDE installation folder, and that no one is using ArcSDE.
- Download the appropriate file to a location other than your ArcSDE installation location.
ArcSDE Server sde92SP6-sqlpatch-sql-win.EXE 3 MB ArcSDE Server SDK sde92SP6-sqlpatch-sdk-win.EXE 3 MB - Double-click sde92SP6-sqlpatch-sql-win.EXE or sde92SP6-sqlpatch-sdk-win.EXE to start the install process.
- When Setup starts, follow the instructions on your screen.
- Server Only: As the ArcSDE administrative user, run the following command to restart the ArcSDE service:
c:\sdemon -o start
ESRI products connecting to ArcSDE (application server and direct connections)
-
- If you connect to ArcSDE 9.2 SP 6 using ArcGIS 9.2 SP 6, ArcIMS 9.2 SP 6, or ArcInfo Workstation 9.3, please follow the steps below to install this Patch to your ArcGIS 9.2 SP 6, ArcIMS 9.2 SP 6, or ArcInfo Workstation 9.3 installation folder:
- Before you start, make sure you have write access to the installation folder, then download the zip file to that location:
- ArcIMS only, stop the ArcIMS Tasker, ArcIMS Monitor, ArcIMS Application Server (in that order).
- Extract the new files from sde92SP6-sqlpatch-esri-win.zip to the appropriate installation folder, see list below:
- ArcGIS Desktop, Server, Engine, Reader, or ArcView 9 - <installation-folder>\arcgis\bin
- ArcGIS Workstation - <installation-folder>\arcexe9x\bin
- Depending on the ArcIMS Setup features installed, SDE client files could be located in one or more of the following locations:
- C:\Program Files\ArcGIS\bin
- C:\Program Files\ArcGIS\ArcIMS\IndexBuilder
- C:\Program Files\ArcGIS\ArcIMS\Metadata\Commands
- C:\Program Files\ArcGIS\ArcIMS\Server\bin
- C:\Program Files\ArcGIS\bin
- ArcIMS only, restart ArcIMS Application Server, ArcIMS Monitor and ArcIMS Tasker (in that order).
- If you connect to ArcSDE 9.2 SP 6 using ArcGIS 9.2 SP 6, ArcIMS 9.2 SP 6, or ArcInfo Workstation 9.3, please follow the steps below to install this Patch to your ArcGIS 9.2 SP 6, ArcIMS 9.2 SP 6, or ArcInfo Workstation 9.3 installation folder:
Patch Updates
Check Online Support Center periodically for the availability of additional patches. New information about this Patch will be posted here.
August 3, 2009: Changed instructions on how to identify patched files for Windows.
How to identify which Patch is installed
To check for the presence of a Patch, for each file examine the File version information (right click, properties, version tab). With only a few exceptions, all files modified as part of a Patch distribution can be uniquely identified in this manner. The File version for this Patch should read:
- 9.2.6.1298
Getting Help
Domestic sites, please contact ESRI Technical Support at 1-888-377-4575, if you have any difficulty installing this Service Pack. International sites, please contact your local ESRI software distributor.
Download ID:1531
Get help from ArcGIS experts
Download the Esri Support App