SQL - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

In combination with MS SQL Server you might get this error while setting up the schema

To avoid confusion in situations where different date formats are used around the world, including MM/dd/yyyy and dd/MM/yyyy, it is recommended to change the default language of MS SQL Server in SSMS.

To do this, follow these steps:

1. Open SSMS and go to the Security section.

2. Right-click on the username of the user who runs the queries.

3. Select Properties and navigate to the General tab.

4. Ensure that the default language at the bottom of the dialog is set to English or American format.

By changing the default language, you can ensure consistent date formatting and prevent any potential issues with the database driver.