...
During the database initialization performed on initial start-up, you could receive the following message:
Panel |
---|
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.
...
To check what default language a server has installed, use the following SQL command:
Panel |
---|
...
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:
Panel |
---|
...
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:
Panel |
---|
...
sp_configure 'default language', 0
reconfigure with override |
For further details, refer to this Microsoft Support page.