...
During the database initialization performed on initial start-up, you could receive the following message:
Panel | |
---|---|
Html bobswift | The conversion of a varchar data type to a datetime data type of the value is out of range.
</pre> |
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 | |
---|---|
Html bobswift | sp_configure 'default language'
</pre> |
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 |
---|
<pre>
select name ,alias, dateformat
from syslanguages
where langid =
(select value from master..sysconfigures
where comment = 'default language')
</pre> |
...
To set the default language to U.S. English, use the following SQL statements:
Panel | |
---|---|
Html bobswift | sp_configure 'default language', 0
reconfigure with override
</pre> |
...
For further details, refer to this Microsoft Support page.