Required Collation for RRC - SQL Server
Hello,
I have a customer that bought RRC, and we are in the installation phase. The customer doesn't want to install a new instance (money wise) and his existing collations are not the required (SQL_Latin1_General_CP437_CS_AS GO) Can he go on and install another collation? can this be defined only at the instance level? what are the implications? Thanks a lot. Asaf |
2 answers
Asaf
The information provided for SQL server db preparation for a CLM (or RRC) installation is located here: http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_sql.html With the brief information provided, I do not understand what issue you are encountering. The instructions we have provided in the above infocenter link is what we have available and what we have tested to work. The few items I gathered when searching for 'collation' are the following: !) The server is installed with case sensitive database collation selected as the default setting. 2) Change the collation of the Jazz Team Server database. For example, ALTER DATABASE jts COLLATE SQL_Latin1_General_CP437_CS_AS GO |
|
Hi Rosa
Thanks for your response! This is what I got from the DBA: changing database collation to be different than the server collation is a bad idea. a lot of the sql server internal processes are in front of the temp db, who should be in the same collation as the user database. What do you think? Comments Asaf, I do not have any further comment or thoughts on this matter. The instructions have been like this for quite some time. See this post: https://jazz.net/forum/questions/36959/the-collation-issue and this post: https://jazz.net/forum/questions/15200/changing-collation-on-users-db-during-sql-db-setup v301 infocenter SQL Server topic: http://pic.dhe.ibm.com/infocenter/clmhelp/v3r0m1/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_sql.html |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.