what all sqlserver configurations to be used with Jazz CLM 406 configuration
![]()
We plan to configure SQL Server 2008 R2 Edition to be used as a back-end with Jazz CLM 406 setup.
What we have done is created databases and login with dbo permission for that particular database.
You must manually set the static port to 1433 by using the SQL Server Configuration tool
During the JTS Setup proceeding with the step - Configure Database
Following Step 3:Create Database Tables - Got an error saying
An error occurred while creating database tables. Please try again.ID CRJAZ1571E
This looks like a permission issue. Could find lot of articles relating to this and did not help.
![]()
What is recommended at this stage
|
Accepted answer
![]() Hi Anoop, Based on the error message, the issue could be the permission. Check and verify the jtsDBuser user account has got the correct permission. Note: The user who creates the database table must be a member in the sysadmin fixed server role, or an owner of the database (dbo). Regards, Arun. anoop mc selected this answer as the correct answer
|
2 other answers
![]()
Hello,
did you follow
https://jazz.net/help-dev/clm/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.