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.
In the log it is: Error: Success (0).
Error: Case sensitive database is not supported
ERROR installing/upgrading ArcSDE, Error = -460
Also do I have to do this for each database?
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:
"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."
Can you provide an example of the name of the database you are getting this error with?
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.
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).
Don't use Mixed case string.