Page Comparison

...

During the database initialization performed on initial start-up, you could receive the following message:

<pre>
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:

<pre>
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:

<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:

<pre>
sp_configure 'default language', 0
reconfigure with override
</pre>

For further details, refer to this Microsoft Support page.