topic Re: Case sensitive database not supported error in ArcGIS Enterprise Questions https://community.esri.com/t5/arcgis-enterprise-questions/case-sensitive-database-not-supported-error/m-p/197327#M7777 <HTML><HEAD></HEAD><BODY><P>On the case sensitive error, Enterprise Geodatabases are only supported with a case-insensitive name. The reason for this is that ArcGIS does not delimit any objects in SQL Server, other than user names:</P><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/enterprise-geodatabase-limits.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/enterprise-geodatabase-limits.htm">Enterprise geodatabase size and name limits—Help | ArcGIS for Desktop</A>&nbsp;</P><P><EM>"<SPAN style="color: #4d4d4d; background-color: #fefefe;">However, ArcGIS does not delimit object names. Do not create any tables, feature classes, databases, users*, roles, or other object names that require delimiters if you will be using it with ArcGIS. The object will be created in the database, but you cannot access it from ArcGIS."</SPAN></EM></P><P></P><P><SPAN style="color: #4d4d4d; background-color: #fefefe;">Can you provide an example of the name of the database you are getting this error with?</SPAN></P><P></P><P><SPAN style="color: #4d4d4d; background-color: #fefefe;">On your question about running this tool for all databases, the answer is yes. Creating a geodatabase must be done on each database that requires ArcGIS Geodatabase functionality. However, if you have a large number of them, this can be done via Python.</SPAN></P><P><SPAN style="color: #4d4d4d; background-color: #fefefe;"><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/setup-geodatabase-sqlserver.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/setup-geodatabase-sqlserver.htm">Set up an enterprise geodatabase in SQL Server—Help | ArcGIS for Desktop</A>&nbsp;</SPAN></P><P></P><P></P></BODY></HTML> Thu, 29 Sep 2016 15:22:21 GMT ChristianWells 2016-09-29T15:22:21Z Case sensitive database not supported error https://community.esri.com/t5/arcgis-enterprise-questions/case-sensitive-database-not-supported-error/m-p/197326#M7776 <HTML><HEAD></HEAD><BODY><P>I am trying to enable enterprise geodatabases for the databases i have created in SQL Server 2014. The first one was fine but I now get this error message.</P><P>In the log it is: &nbsp; &nbsp;Error: Success (0).<BR />Error: Case sensitive database is not supported<BR />ERROR installing/upgrading ArcSDE, Error = -460</P><P></P><P>Also do I have to do this for each database?</P></BODY></HTML> Thu, 29 Sep 2016 13:51:28 GMT https://community.esri.com/t5/arcgis-enterprise-questions/case-sensitive-database-not-supported-error/m-p/197326#M7776 WilliamLuscombe 2016-09-29T13:51:28Z Re: Case sensitive database not supported error https://community.esri.com/t5/arcgis-enterprise-questions/case-sensitive-database-not-supported-error/m-p/197327#M7777 <HTML><HEAD></HEAD><BODY><P>On the case sensitive error, Enterprise Geodatabases are only supported with a case-insensitive name. The reason for this is that ArcGIS does not delimit any objects in SQL Server, other than user names:</P><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/enterprise-geodatabase-limits.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/enterprise-geodatabase-limits.htm">Enterprise geodatabase size and name limits—Help | ArcGIS for Desktop</A>&nbsp;</P><P><EM>"<SPAN style="color: #4d4d4d; background-color: #fefefe;">However, ArcGIS does not delimit object names. Do not create any tables, feature classes, databases, users*, roles, or other object names that require delimiters if you will be using it with ArcGIS. The object will be created in the database, but you cannot access it from ArcGIS."</SPAN></EM></P><P></P><P><SPAN style="color: #4d4d4d; background-color: #fefefe;">Can you provide an example of the name of the database you are getting this error with?</SPAN></P><P></P><P><SPAN style="color: #4d4d4d; background-color: #fefefe;">On your question about running this tool for all databases, the answer is yes. Creating a geodatabase must be done on each database that requires ArcGIS Geodatabase functionality. However, if you have a large number of them, this can be done via Python.</SPAN></P><P><SPAN style="color: #4d4d4d; background-color: #fefefe;"><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/setup-geodatabase-sqlserver.htm" title="http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-sql-server/setup-geodatabase-sqlserver.htm">Set up an enterprise geodatabase in SQL Server—Help | ArcGIS for Desktop</A>&nbsp;</SPAN></P><P></P><P></P></BODY></HTML> Thu, 29 Sep 2016 15:22:21 GMT https://community.esri.com/t5/arcgis-enterprise-questions/case-sensitive-database-not-supported-error/m-p/197327#M7777 ChristianWells 2016-09-29T15:22:21Z Re: Case sensitive database not supported error https://community.esri.com/t5/arcgis-enterprise-questions/case-sensitive-database-not-supported-error/m-p/197328#M7778 <HTML><HEAD></HEAD><BODY><P>Hi&nbsp;</P><P>Thanks for the information, I have used underscore in my database names so this must be the issue, i.e. World_Mapping.</P><P>In fact all the names have an underscore.</P></BODY></HTML> Fri, 30 Sep 2016 07:33:47 GMT https://community.esri.com/t5/arcgis-enterprise-questions/case-sensitive-database-not-supported-error/m-p/197328#M7778 WilliamLuscombe 2016-09-30T07:33:47Z Re: Case sensitive database not supported error https://community.esri.com/t5/arcgis-enterprise-questions/case-sensitive-database-not-supported-error/m-p/197329#M7779 <HTML><HEAD></HEAD><BODY><P>I think the use of underscore is valid. But all the alphabets in Database Name should be either in upper case or lower case (e.g. world_mapping or WORLD_MAPPING).</P><P>Don't use Mixed case string.</P></BODY></HTML> Fri, 30 Sep 2016 07:45:37 GMT https://community.esri.com/t5/arcgis-enterprise-questions/case-sensitive-database-not-supported-error/m-p/197329#M7779 JayantaPoddar 2016-09-30T07:45:37Z Re: Case sensitive database not supported error https://community.esri.com/t5/arcgis-enterprise-questions/case-sensitive-database-not-supported-error/m-p/197330#M7780 <HTML><HEAD></HEAD><BODY><P>Does that include the Filegroups too?</P></BODY></HTML> Fri, 30 Sep 2016 08:06:38 GMT https://community.esri.com/t5/arcgis-enterprise-questions/case-sensitive-database-not-supported-error/m-p/197330#M7780 WilliamLuscombe 2016-09-30T08:06:38Z Re: Case sensitive database not supported error https://community.esri.com/t5/arcgis-enterprise-questions/case-sensitive-database-not-supported-error/m-p/197331#M7781 <HTML><HEAD></HEAD><BODY><P>I changed the name to all lowercase but still getting the same error.</P></BODY></HTML> Fri, 30 Sep 2016 09:44:18 GMT https://community.esri.com/t5/arcgis-enterprise-questions/case-sensitive-database-not-supported-error/m-p/197331#M7781 WilliamLuscombe 2016-09-30T09:44:18Z Re: Case sensitive database not supported error https://community.esri.com/t5/arcgis-enterprise-questions/case-sensitive-database-not-supported-error/m-p/197332#M7782 <HTML><HEAD></HEAD><BODY><P>Got an old&nbsp;whitepaper on "Case Sensitivity in SQL Server Geodatabases".</P><P><A href="http://downloads.esri.com/support/whitepapers/other_/CS_Whitepaper_June2007.pdf">http://downloads.esri.com/support/whitepapers/other_/CS_Whitepaper_June2007.pdf</A></P><P>Check if it helps.</P></BODY></HTML> Fri, 30 Sep 2016 09:53:07 GMT https://community.esri.com/t5/arcgis-enterprise-questions/case-sensitive-database-not-supported-error/m-p/197332#M7782 JayantaPoddar 2016-09-30T09:53:07Z