Problem to create the database on SQL Server 2008 R2
2 answers
Here's the Setting up an SQL Server database section of the 4.0.2 information center
One of the steps is to run:
The CS near the end is what indicates the DB should be case sensitive. (CI would indicate Case Insensitive)
I'm pretty sure that value is available from a drop down list if you are creating the database from the GUI interface.
One of the steps is to run:
ALTER DATABASE jts COLLATE SQL_Latin1_General_CP437_CS_AS
The CS near the end is what indicates the DB should be case sensitive. (CI would indicate Case Insensitive)
I'm pretty sure that value is available from a drop down list if you are creating the database from the GUI interface.
Comments
I think Karl's answer is the most plausible. But I've also seen this exception when the JDBC connection string in the teamserver.properties file is incorrect. For example:
using:
//<host>:<port>;JTS=jts;<user>=name;password={password}
instead of:
//<host>:<port>;databaseName=jts;user=<name>;password={password}
