Jason L's Activity
Jason L added a article in Recurring non-Version Specific IssuesMSSQL: Conversion data type 'char' into 'datetime' resulted in a datetime value out of range.MSSQL server determines a DATETIME format based on the login user's default language and/or regional settings. If you are receiving the following error:
"Conversion data type 'char' into 'datetime' resulted in a datetime value out of range."
This is likely due to the board's SQL user login not having a default language of English. To change this you must log into the Microsoft SQL Server Management Studio and locate the board's SQL login account from the Server > Security > Logins section. From within that user's properties find the Default language drop down and change it to English.
- 0 replies
- 2,450 views