on Apr 2, 2014Installing IT PAM version 4.2 . Installed JDK 1.7.0.45 version. But while configuring with database its showing error. "Test Not Successful, Please Check the database settings"
Attached is the screenshot.
Is this a fresh install? Does "Create Database" work? Are you sure you can connect from that machine?
Yes, It is a fresh install. No , While clicking upon Create Database button same error appearing., Yes I had Ping the machine its pinging but I have also put IP Address but with IP Address same error coming
Can you telnet to 1433? Are there errors displayed in server\c2o\installation.log?
Derek-
Thanks Derek for your response. Yes I checked by pinging 1433 port it is not pinging and showing message "Connecting To 1433...Could not open connection to the host, on port 23: Connect
failed"
Also Log file showing the below error line
<ERROR 2014-04-02 22:36:17,501 TestDatabaseListener::error> Test not successful. Please check database settingsI guess it is related to the portWill revert you back once resolvedThanks,MohitBased on the first message i'd recommend trying Telnet again using "telnet <servername> 1433" If it says "Could not open connection to the host, on port 1433" then check the firewall and also verify that SQL is properly installed on the database server.
Derek-
well I have checked the telnet <servername> 1433. Its showing the error message could not open the connection with the host 1433 . Well I have also checked with the sql its properly insalled
Likely. Though you may want to do the same test on the database server itself. If it doesn't toss an error then it's definitely firewall. If it does then SQL isn't installed / configured properly.
Well I Ping the datavase server itself telnet <servername> 1433 and its showing same error could not open connection to host. Seems firewall restrictions from Network side need to open port for that. Right ?
You can't Ping a port. You can Telnet to one providing it is open on the destination server. If you are on the destination server and the Telnet still fails then it is not a firewall issue. It means that SQL is either not installed or configured properly.
Thanks Derek and Tom.
Issue is resolved. Yes it is related to the SQL. Actually the port of SQL was different which is 5441. This port is listening through telnet not the defaul port 1433.
Viewed the port under TCP/IP of Sql configuration manager. It is Dynamic port. Where as default port for Sql Client was same which is 1433
Thanks,
Mohit
Thanks Derek and Tom.
Issue is resolved. Yes it is related to the SQL. Actually the port of SQL was different which is 5441. This port is listening through telnet not the defaul port 1433.
Viewed the port under TCP/IP of Sql configuration manager. It is Dynamic port. Where as default port for Sql Client was same which is 1433
Thanks,
Mohit