It's all about the answers!

Ask a question

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


anoop mc (74810166214) | asked 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 

Accepted answer


permanent link
Arun K Sriramaiah (3.2k12263) | answered 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

2 other answers



permanent link
Eric Jodet (6.3k5111120) | answered Sep 23 '14, 11:42 a.m.
JAZZ DEVELOPER
 Hello,
did you follow 
https://jazz.net/help-dev/clm/topic/com.ibm.jazz.install.doc/topics/t_s_server_installation_setup_sql.html

?

permanent link
anoop mc (74810166214) | answered 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.



Comments
anoop mc commented 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 to post your answer.