Cannot add a data source if the repository resides on a named instance. (NETIQKB53996)

  • 7753996
  • 02-Feb-2007
  • 08-Aug-2011

Environment

NetIQ AppManager Performance Profiler 4.x
NetIQ AppManager 6.x
NetIQ AppManager 7.0.x

Situation

Cannot add a data source if the repository resides on a named instance.
Error: 'java.sql.SQLException: 'Unable to get information from SQL Server.'

Resolution

To correct this issue, verify that SQL Server is running using TCP/IP and that port 1434 is open on the SQL Server that hosts the named instance for the repository.

Cause

The exception that is being received is usually caused by a timeout. Connection timeouts occur when there is no server listening on the port. Typically, this is the result of port 1434 being closed between the AppManager Performance Profiler server and the AppManager repository server.

The Tomcat service handles the process when you add a data source. Tomcat uses JDBC drivers to query and access the SQL Server where the AM Repostory is located.  Tomcat queries the SQL Server for a list of named instances via SQL Port 1434.  Once the list is received from SQL Server, JDBC switches to the port value that you manually entered into the Add Data Source tool.

Additional Information

Formerly known as NETIQKB53996