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.