ID CRJAZ2654E error with sql database while JDBC connection
hi,
I am configuring CLM 4.0.3 with SQL server 2008 database. Followed the installation guide for setting up the database.
Installed SQL 2008 server with SQL mixed windows authentication and downloaded the sqljdbc4.jar file and set the system variable.
TCPIP is enabled and port number is checked (i.e 1433).
Created the databases for jts,ccm,qm,dw database through command line.
Created the user and associated the user with the database jtsDBuser->jts, ccmDBuser->ccm, qmDBuser->qm....
when iam registering the application, while connecting to the database through JDBC followed the below syntax
Verified the database properties and user properties , ensured that users are having db owner permission.
SQL database with JDBC connection
" /win-abceg6k76dr:1433;databaseName=jts;user=jtsDBuser;password={password} "
//any thing wrong in syntax or authentication ?
Below is the error ...
The configuration test resulted in errors. Resolve the errors to continue. For information about why the configuration did not pass the validity test and how to provide a valid configuration, see the other messages that are provided with this message. For more information, open the help and search for "Running the setup wizard".ID CRJAZ1579E hide details
The server was unable to connect to the database because the database connection syntax is invalid. Verify the syntax in your teamserver.properties file. See the Jazz Team Server log for more information.ID CRJAZ2654E
The server was unable to connect to the database because the database connection syntax is invalid. Verify the syntax in your teamserver.properties file. See the Jazz Team Server log for more information.ID CRJAZ2654E
Kindly guide us to resolve this.
Regards
Ashwath
4 answers
In the connection string you have just one leading slash:
/win-abceg6k76dr:1433;databaseName=jts;user=jtsDBuser;password={password}
I believe there are supposed to be two:
//win-abceg6k76dr:1433;databaseName=jts;user=jtsDBuser;password={password}
/win-abceg6k76dr:1433;databaseName=jts;user=jtsDBuser;password={password}
I believe there are supposed to be two:
//win-abceg6k76dr:1433;databaseName=jts;user=jtsDBuser;password={password}
Comments
Hi ,
I had a similar issue while running the jts setup and configuring the SQL Server Database:
Observation in JTS Log:
- CRJAZ2654E The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 08S01, SQLCODE: 0). Verify the connection settings in your teamserver.properties file. See the Jazz Team Server log for more information.
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host, port 1433 has failed. Error: "Connection refused: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234)
at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:285)
at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2431)
at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:656)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServer
Steps to resolve:
- CRJAZ2654E The server was unable to connect to the database because the database connection settings are invalid or because database is unreachable (SQLSTATE: 08S01, SQLCODE: 0). Verify the connection settings in your teamserver.properties file. See the Jazz Team Server log for more information.
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host, port 1433 has failed. Error: "Connection refused: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234)
at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:285)
at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2431)
at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:656)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServer
Steps to resolve:
1)Make sure the Database User name and Password are correctly configured.
2)Check for the Port restrictions on the firewall and ensure that port 1433 is allowed
3)Check whether the hostname of the db is reachable.. if not for the hostname, try with the ipaddr of the db server.
2)Check for the Port restrictions on the firewall and ensure that port 1433 is allowed
3)Check whether the hostname of the db is reachable.. if not for the hostname, try with the ipaddr of the db server.