Language Compatibility Issues Turkish, Portuguese & Spanish

Solution

The best way to come around this will be to install the server operating system to English UK/US or change it to the English UK/US and do a restart of the server. 

Different solutions: 

Portuguese

SQL Server User with default language Portuguese does not support ISO 8601 Date Formats for SQL
(They have a valid YYYY-DD-MM format that can fail on the 13th - 31st of any month, and is wrong on the 1st-12th)

Spanish

SQL Server User with default language Spanish does not support ISO 8601 Date Formats for SQL
(They have a valid YYYY-DD-MM format that can fail on the 13th - 31st of any month, and is wrong on the 1st-12th)

Turkish

Windows User with Turkish Regional Settings fail at parsing SQL Server Connection Strings
https://garygregory.wordpress.com/2015/11/03/java-lowercase-conversion-turkey/
https://gist.github.com/anova/6902147
The issue encountered was that "I".ToLower() != "i" in Turkish

Common errors: 

1. 

2. 

Infotech.Data.DataComponents.DataCompException: Invalid column name 'tmcomponentjobid'.
Invalid column name 'componentjobid'.
Invalid column name 'tmjobid'.
Invalid column name 'jobid'.
Invalid column name 'tmcomponentjobintervalID'.
Invalid column name 'tmcomponentjobintervalID'.
Invalid column name 'componentid'.
Invalid column name 'tmcomponentid'.
Invalid column name 'tmjobhistoryid'.
The multi-part identifier "tmcomponentjobinterval.intervaltype" could not be bound.
The multi-part identifier "tmcomponentjobinterval.intervaltype" could not be bound. ---> System.Data.SqlClient.SqlException: Invalid column name 'tmcomponentjobid'.

3. 

Infotech.Data.DataComponents.DataCompException: Invalid column name 'isGreen'.
Invalid column name 'isGreen'. ---> System.Data.SqlClient.SqlException: Invalid column name 'isGreen'.
Invalid column name 'isGreen'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()