Out-of-Range Value during Database Initialization
Problem
During the database initialization performed on initial start-up, you could receive the following message:
The conversion of a varchar data type to a datetime data type of the value is out of range.
The problem likely is that the database was created in SQL SERVER Management Studio with a user that has other than English as the default language.
Solution
Verify the installed default language and set the language to U.S. English.
To check what default language a server has installed, use the following SQL command:
sp_configure 'default language'
If the resulting value is not 0, the default language is not U.S. English. Run the following SQL command to find the installed default language setting and date format used:
select name ,alias, dateformat from syslanguages where langid = (select value from master..sysconfigures where comment = 'default language')
To set the default language to U.S. English, use the following SQL statements:
sp_configure 'default language', 0 reconfigure with override
For further details, refer to this Microsoft Support page.