i setup a TeamCity server on a WinXP SP3 machine today and then migrated the data to a SQL Server 2005 database.
When i start the services, i get an uncategorized SQLException for SQL [select MAX(build_id) from server]; SQL state [42S22]; error code ; Invalid column name 'build_id' error in the teamcity-server.log file. I attached the log files also. This exception leads to a cascade of Error creating bean with name 'xyz' errors but the problem starts with the error in that simple query.
I've checked the database and the column names in all tables are in UPPER_CASE. TeamCity throws this exception because it's using lower_case letters in the query and this leads to the database giving an error.
My first question is: Isn't Transact-SQL supposed to be case insensitive?
And my second question is: If TeamCity creates tables with column names in UPPER_CASE, why is it querying the database in lower_case?
I'm pretty sure i'm missing something or doing something wrong, but i followed the instructions in this page to the letter and i have no idea what the problem is.
I would appreciate if someone could help me with this.