It's all about the answers!

Ask a question

Cannot connect to Repository


Mumshad Ali (632) | asked Jan 07 '11, 7:49 p.m.
Hello,

I have recently installed requirements composer both server and clients. I have SQL Server 2005 running. Using the query analyzer I created the rrc database with user name and password.

Now when I click on get started and fill in the appropriate fields with a name for the repository, the default url was in the box already "https://localhost:9443/rdm/"
i provided the rrcDBuser for user name and rrcDBpswd for password

Importantly I don't see the validate url option

it gives an error of some java exception

Any help would be highly appreciated

Regards

3 answers



permanent link
Stef van Dijk (2.0k179) | answered Jan 07 '11, 11:19 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
Hi,

One thing I couldn't quite determine from your post is whether you are installing a 2.x version of RRC or the 3.0 beta. Based on the "validate url" bit you mentioned, it sounds like you're trying to use the 2.x desktop application so I'll go from that assumption.

I also wasn't clear on whether you configured the server by going to the url https://localhost:9443/rdm/setup first. Did you complete that step before starting the client? As part of the server setup, you should also create a user via the User Management web page. That would be the user and password you provide when connecting to the repository from the client, and not the database user and password (that is strictly used by the RRC server to communicate with the database).

As for the validate url option, that checkbox was removed recently and no longer exists.

If none of this helps or makes sense, then please provide the details of the java exception you are seeing.

permanent link
Mumshad Ali (632) | answered Jan 08 '11, 12:12 a.m.
Hi,

One thing I couldn't quite determine from your post is whether you are installing a 2.x version of RRC or the 3.0 beta. Based on the "validate url" bit you mentioned, it sounds like you're trying to use the 2.x desktop application so I'll go from that assumption.

I also wasn't clear on whether you configured the server by going to the url https://localhost:9443/rdm/setup first. Did you complete that step before starting the client? As part of the server setup, you should also create a user via the User Management web page. That would be the user and password you provide when connecting to the repository from the client, and not the database user and password (that is strictly used by the RRC server to communicate with the database).

As for the validate url option, that checkbox was removed recently and no longer exists.

If none of this helps or makes sense, then please provide the details of the java exception you are seeing.



Hello,

I got that resolved I did used the /setup which you mentioned, now I am stuck on how to configure the SQL database named rrc.

I did created the database in sql server with rrcDBUser and rrcDBpswd
I also set the SQLSERVER_ABSPATH to the sqljdbc.jar file located on my system
I have downloaded the SqlJdbc driver too.

i am using the following syntax to give pwd for jdbc as shown in the help system for rrc

i have given password for the database while specifying for jdbc pwd

//myserver:1433;databaseName=rrc;user=rrcDBuser;password={password}

I am bit confused on how to give the port #, and the password is not in {}

Error i get is :CRJAZ0808I The driver "com.microsoft.sqlserver.jdbc.SQLServerDriver" could not be loaded and registered. Support for some database vendors requires that the JDBC driver JAR be provided in a path configured by the server scripts. If you are experiencing problems changing the database vendor, refer to the product setup instructions for more information.
Thanks

permanent link
Stef van Dijk (2.0k179) | answered Jan 08 '11, 1:13 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
While it sounds like you've probably done this, please make sure you've followed the specific steps for using SQL Server found here:

https://publib.boulder.ibm.com/infocenter/rpcmpose/v2r0/index.jsp?topic=/com.ibm.rational.rrc.install_upgrade.doc/topics/t_setup_sql.html

Next, be sure you are following the instructions for configuring the server by starting here and following the Custom Setup path as well as the link specifically for SQL Server databases:

https://publib.boulder.ibm.com/infocenter/rpcmpose/v2r0/index.jsp?topic=/com.ibm.rational.rrc.install_upgrade.doc/topics/t_run_rrc_config.html

Note specifically that when setting the JDBC location that you enter "{password}" exactly like that. With the {} and the word "password" - do NOT type your specific password here. It will be substituted in from the value you entered in the JDBC Password field above.

Hope that helps.

Your answer


Register or 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.