Latest Contributions by George_Thompson

My guess is that if they are DBO then they have permissions to connect regardless if you have the option selected: The geodatabase administrator can always make a connection to the geodatabase regardless of how this property is set. Prevent geodatabase connections—Help | ArcGIS Desktop  Manage connections in SQL Server—Help | ArcGIS Desktop  ... View more

ksjosh82‌ are the connections that are reconnecting using the SDE users as their connection properties in the GP tools? ... View more

Hi Joe, What version is the geodatabase in? Is this a file geodatabase or an enterprise geodatabase (eGDB)?     If using an eGDB, answer the following questions: What is the RDBMS version and OS that it is running on? Is the data versioned? That will give some more information that may be needed. ... View more

Connection support for SQL Server 2008 stopped at the 10.4 release. Mainstream support for SQL Server 2008 R2 ended on July 8, 2014 (over 2 1/2 years ago) and only extended support is available, gives limited support on the platform. Here is a Problem: Connections from ArcGIS 10.4.1 or ArcGIS Pro 1.3 to SQL Server 2008 or 2008 R2 fail  technical article. Extended Support The Extended Support phase follows Mainstream Support for business, developer, and desktop operating system products. At the supported service pack level, Extended Support includes: Paid support 4 Security update support at no additional cost Nonsecurity related updates requires Extended Hotfix Support to be purchased (per-fix fees also apply). 5 Extended Hotfix Support is not available for desktop operating system consumer products. More details are available https://support.microsoft.com/kb/2702286here. NOTE: Microsoft will not accept requests for warranty support, design changes, or new features during the Extended Support phase Extended Support is not available for consumer, consumer hardware, or multimedia products Enrollment in a maintenance program may be required to receive these benefits for certain products 4 Limited complimentary support may be available (varies by product). 5 Microsoft Lifecycle policy permits the creation and broad distribution of certain nonsecurity updates during the Extended Support phase. For example, it may be necessary to provide a nonsecurity update that enables continued connectivity and servicing through the Automatic Update or Windows Server Update service. Geodatabase‌ Enterprise GIS‌ ... View more

Adding to some other groups for better visibilty: Geodatabase‌ https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=308de7cf-313e-4d30-823c-f9fcd37a7e3c&searchIndex=1‌ ... View more

An "instance" in SQL Server is a installation of SQL Server. Within that SQL Server instance, you can have multiple databases (as long as they do not have the same name). I think what Asrujit SenGupta‌ is saying is to restore to the new SQL Server instance. Example: Machine1\SQLServer to Machine2\SQLServer Database Engine Instances (SQL Server)  ... View more

I include_system Indicates whether statistics will be gathered on the states and state lineages tables. Note: You must be the geodatabase administrator for this option to be activated. This option only applies to geodatabases. If the input workspace is a database, this option will be ignored. NO_SYSTEM —Statistics will not be gathered on the states and state lineages tables. This is the default. SYSTEM —Statistics will be gathered on the states and state lineages tables. Analyze Datasets—Help | ArcGIS Desktop  here is the help documentation on the tool. Verify that you are using the correct user connection (SDE) for the SYSTEM tables and the DATA owner for the other tables. ... View more

This map be helpful: ColorBrewer: Color Advice for Maps  They have some colorblind safe color ramps. Not sure about section 508c. ... View more

I am not sure that you can use PostgreSQL with Workgroup. The limitations on SQL Server Express are all on the MS side. Esri only limits the # of concurrent connections Microsoft limits the use of SQL Server Express to one CPU (or core within a socket) and 1GB of RAM. The maximum database size for SQL Server 2005 or 2008 Express is limited to 4GB. The maximum database size for SQL Server 2008 Express R2 is 10GB. (Consult your Esri license agreement for specific information on the instance size limitations for your implementation.) You may need to contact your account manager and upgrade to ArcGIS Enterprise licensing. ... View more

What level of ArcGIS Enterprise are you using? You cannot use PostgreSQL with Workgroup level license: Types of geodatabases—ArcGIS Help | ArcGIS Desktop  ArcGIS Enterprise Workgroup also includes ArcSDE support for SQL Server Express. With this level of ArcSDE, you can use SQL Server Express for up to 10 simultaneous Windows desktop users and editors (users of ArcGIS Desktop Basic, Desktop Standard, Desktop Advanced, a custom ArcGIS Engine application, AutoCAD, MicroStation, and so on) plus any number of additional server connections from Web applications. (Consult your license agreement for specific information on the number of connections for your implementation.) If you do not have ArcGIS Enterprise (Standard or Advanced) licenses the switch may not work. Also confirm that you are running PostgreSQL on a supported O/S, which it looks like you are: PostgreSQL database requirements for ArcGIS 10.5—Help | ArcGIS Desktop  Hope this points you in the correct direction. https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=4256ba13-6288-4d4c-aa5e-45fceb82edc9&searchIndex=0‌ ... View more

Here is the documentation on permissions needed for SQL Server: Privileges for geodatabases in SQL Server—Help | ArcGIS Desktop  Create an enterprise geodatabase in SQL Server—Help | ArcGIS Desktop   This is good information to review also. https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=76b48361-22c0-4ae7-81ce-2f452dffe90e&searchIndex=0‌ ... View more

https://community.esri.com/groups/geodatabase?sr=search&searchId=496bc3a3-05d0-4fad-b2d5-2939a5f5592d&searchIndex=0‌ https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=2791cb4a-8585-40ad-b0a8-a1eb3a4e8681&searchIndex=0‌  ... View more

I have done the manual deletion before in a database, but I had a verified backup and tested the process many times. It is a very SPECIFIC per database workflow. I would not think that it may be the same in all cases like this. ... View more

This may point you in the correct direction: Domains in a geodatabase in DB2—Help | ArcGIS Desktop  System tables of a geodatabase in DB2—Help | ArcGIS Desktop  You are probably going to have to join some of the GDB_ tables to get the desired output. Here is a SQL sample for Oracle, you will want to verify the table names, etc. select i.name “Domain Name”, t.name “Domain Type” from gdb_items i, gdb_itemtypes t where i.type = t.uuid and  t.name like '%Domain%' order by t.name,i.name asc; ... View more

If you have another raster that "works" then you could find all the information for that one and delete the other one. Otherwise it may be very risky to delete other files. You mention that you only have 2 rasters in the GDB. ... View more