今天有一个客户咨询,为什么我的ArcGIS10.2 for SQL Server 创建企业级地理数据库老是不成功,一直报Case sensitive database is not supported错误。
错误信息
GP错误
Executing:CreateEnterpriseGeodatabase SQL_Server localhost sde1 DATABASE_AUTH sa ***** SDE_SCHEMA sde *****# "c:\ArcGIS Server 10.1 none.ecp"StartTime:ThuJan2211:21:402015User has privileges required to create database objects.Database already exists.Geodatabase admin user created.Validated authorization file.User has required privileges for geodatabase setup.
XML support is enabled for the database instance.[Case sensitive database not supported.]See the setup log in the following location for additional error information:
C:\Users\Esri\AppData\Local\Temp\sde_setup.log
Couldnot create geodatabase tables and stored procedures.Failed to execute (CreateEnterpriseGeodatabase).Failed at ThuJan2211:21:432015(ElapsedTime:3.90 seconds)
sdesetup.log错误
[ThuJan2211:21:422015]<a href="http://www.iarcgis.com/?tag=error" title="查看更多关于 Error 的文章" target="_blank">Error</a>: Success (0).
[Thu Jan 22 11:21:42 2015] <a href="http://www.iarcgis.com/?tag=error" title="查看更多关于Error的文章" target="_blank">Error</a>: Case sensitive database is not supported
[Thu Jan 22 11:21:42 2015] ERROR installing/upgrading ArcSDE, <a href="http://www.iarcgis.com/?tag=error" title="查看更多关于 Error 的文章" target="_blank">Error</a> = -460
原因
通过该错误信息可以看出,这是因为SQL Server 实例使用所在计算机的默认排序规则。如果需要选择其他排序规则,请单击“排序规则”选项卡并更改“数据库引擎”语言,然后再继续。确保使用不区分大小写的排序规则,因为 ArcGIS 不支持区分大小写的排序规则。