Versions Compared

Old Version 9

changes.mady.by.user Rashmi Likhite

Saved on

compared with

New Version Current

changes.mady.by.user Rashmi Likhite

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Celoxis JDBC Probe is a java program that helps to understand connection issues with your database server. 

...

Understanding the Error Messages

Common errors for Oracle

ERROR MESSAGEPOSSIBLE CAUSES
The Network Adapter could not establish the connection
  • The host name cannot be resolved by the DNS server.
  • Database server is not running on the host.
  • The database port on the database server is inaccessible because of a firewall 
Invalid username/password; logon deniedUsername or password is incorrect
Connection refused(DESCRIPTION=(TMP=) (VSNNUM=153092352)(ERR=12505) (ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
  • The database name is incorrect
  • The user doesn't have privileges to logon to the database

FAILURE: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor. [java.sql.SQLException]

One of the parameter you are passing is incorrect or the database does not exist on the connection properties you are specifying.


Common errors for MSSQL

ERROR MESSAGEPOSSIBLE CAUSES
Error establishing socket.
  • The host name cannot be resolved by the DNS server.
  • Database server is not running on the host. 
  • The database port on the database server is inaccessible because of a firewall
Login failed for userUsername or password is incorrect.
Cannot open database requested in login
  • The database name is incorrect.
  • The user doesn't have privileges to logon to the database
Not Associated with a trusted SQL Server ConnectionThis occurs typically when Microsoft Sql Server installation is configured to use only Windows authentication and not SQL Server authentication. To solve the problem: Change the Authentication change the authentication mode to sql server authentication. 
The TCP/IP port is disabled or not accepting connections
  • Go to Microsoft SQL Server 2008, 2012, 2014> Configuration Tools > SQL Server Configuration Manager
  • In the SQL Server Configuration Manager select the node SQL Server Network Configuration > Protocols for MSSQLSERVER
  • Right-click on the TCP/IP node and select Enable
  • Restart the SQL Server (SQLEXPRESS) service (In Control Panel > Adminstrative Tools > Services, right-click on the SQL Server (SQLEXPRESS) service and select Restart)

Also, check that the firewall is not blocking the connection.

...