Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

what all sqlserver configurations to be used with Jazz CLM 406 configuration

Questions
Tags
Users
Badges
anoop mc
(748●11●200●221) Sep 23 '14, 9:07 a.m.
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
  1. pen Programs > Microsoft SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager
  2. From the Microsoft SQL Server Configuration Manager navigation pane, expand SQL Server Network Configuration > Protocols for < instance name >, and then double-click TCP/IP.
  3. In the TCP/IP Properties dialog box, click the IP addresses tab.
  4. For each IP address listed, ensure that the TCP Dynamic Ports field is blank. If the TCP Dynamic Ports field contains a value of 0, that IP address is using dynamic ports. Since CCMDB requires Microsoft SQL Serverto listen on a static port, this field must be blank.
  5. For each IP address listed, enter  1433  for the TCP Port field.
  6. Click OK.
  7. From the SQL Server Configuration Manager navigation pane, click SQL Server Services.
  8. Right-click SQL Server (< instance name >) and then click Restart, to stop, and restart Microsoft SQL Server.
  9. Verify the Microsoft SQL Server instance is running, and then close SQL Server Configuration Manager.

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.

db_create_table_err


What is recommended at this stage 

0 votes

3 answers
4,916 views
0 votes

Accepted answer

Permanent link
Arun K Sriramaiah
(3.2k●2●36●77) Sep 27 '14, 12:14 p.m.

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

1 vote

2 other answers

Permanent link
Eric Jodet
JAZZ DEVELOPER (6.3k●5●111●120) Sep 23 '14, 11:42 a.m.
 Hello,
did you follow 
https://jazz.net/help-dev/clm/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_sql.html

?

1 vote

Permanent link
anoop mc
(748●11●200●221) Sep 29 '14, 2:21 a.m.
 Hi Arun,

Thanks for the answer. Even after granting the user dbo permission on the specific databases (eg: Assign dbo for jtsDBuser on jts database) and also executing the below commands against each database helped to setup the database. 

ALTER DATABASE jts COLLATE SQL_Latin1_General_CP437_CS_AS 
GO
	
ALTER DATABASE jts SET READ_COMMITTED_SNAPSHOT ON
GO
Then after testing the connection to the database from https://localhost:9443/jts/setup wizard.

Clicking the button Create Tables button will automatically populate with the required data.


0 votes

Comments
anoop mc
Sep 29 '14, 2:22 a.m.

 https://jazz.net/help-dev/clm/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_sql.html&scope=null

Your answer

Register or log in to post 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.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 7,494

Question asked: Sep 23 '14, 9:07 a.m.

Question was seen: 4,916 times

Last updated: Sep 29 '14, 2:22 a.m.

Confirmation Cancel Confirm