Hey All,

If you run into the problem fulltext search below it is most likely because your SQL server has not been setup correct. The problem is caused by the COLLATE being set wrong. Your should review the guide for setting up SQL databse and run the following command:



ALTER DATABASE jazz COLLATE SQL_Latin1_General_CP437_CS_AS
GO

Rational Jazz Team Server - Enterprise
CRJAZ1363I Loading configuration from "file:conf/jazz/teamserver.properties".
CRJAZ1365I Attempting Initial Database Connection Using
Db Name/Location: //W86671:1433;databaseName=RTC_POC;user=xxxxxxxx;password=xx
xxxxxx;
CRJAZ1364I Initial database connection successful
Db Product Name: Microsoft SQL Server
Db Product Version: 9.00.3200
Db URL: jdbc:sqlserver://W86671:1433;xopenStates=false;trustServerCertificate=
false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=a
daptive;packetSize=8000;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encr
ypt=false;disableStatementPooling=true;databaseName=RTC_POC;applicationName=Micr
osoft SQL Server JDBC Driver;
Jdbc Driver Name: Microsoft SQL Server JDBC Driver 2.0
Jdbc Driver Version: 2.0.1803.100
CRJAZ8192I: Fulltext Index Location: D:\APP\IBM\JazzTeamServer\server\workitemin
dex\fulltext_index
CRJAZ8190E: The fulltext index location property (indexLocation) should point to
an absolute directory but is currently set to 'workitemindex'
Creating the tables for the database "//W86671:1433;databaseName=RTC_POC;user=xx
xxxxxx;password=xxxxxxxx;" with indices.
The database is not set to support case-sensitivity in string comparison operati
ons
The database tables were not created.