DX Infrastructure Manager

  • 1.  SQL SERVER probe 4.95v issue

    Posted 03-27-2017 10:54 AM

    Hi ,

     

    We are using sql server probe 4.95v to monitor sql servers.

    For some windows servers like 2003 and 2008..we are not able to make connection to the database via the probe.
    For some we are able to establish the connection.

     

    Please let us know what can be the solution and how we can proceed.

     

    Thanks



  • 2.  Re: SQL SERVER probe 4.95v issue

    Broadcom Employee
    Posted 03-27-2017 11:38 AM

    Set the probe for log level 5, reproduce the problem, and see what details on the failure the log has. The sql server side can also be checked at the same time to see if it sees the connection attempt from the probe.



  • 3.  Re: SQL SERVER probe 4.95v issue

    Posted 03-27-2017 01:11 PM

    Hi,

     

    We are getting this connection error.

     

     

    Profile: test connection profile/test connection checkpoint/Connect - COM Error: Code=0x80004002 Source=(null) Description=(null)

     

    Thanks



  • 4.  Re: SQL SERVER probe 4.95v issue

    Broadcom Employee
    Posted 03-27-2017 02:56 PM

    Based on past cases there could be a few things causing this.

    The first thing to do is deploy sqlserver 5.10 and retest all the failing profiles.

    There are cases where it was a failure at the OS level and resolved via installing the OS service pack for Windows 2008 R2.

    The other thing known to cause the problem is a basic communication problem.

    telnet can be used to test connectivity, and Wireshark is the tool for capturing network traffic.



  • 5.  Re: SQL SERVER probe 4.95v issue

    Posted 03-28-2017 05:43 AM

    Okay will try to deploy 5.10 and try to test.

    One more query ..is there any thing as such that sqlserver probe 4.95v does not support windows 2003 server or windows 2008 servers??

     

    Thanks



  • 6.  Re: SQL SERVER probe 4.95v issue
    Best Answer

    Broadcom Employee
    Posted 03-28-2017 05:56 AM

    Dear ayushs

     

    as such, the probe support is listed in this document:

    https://support.nimsoft.com/downloads/doc/Platform_Support_Availability_current.pdf 

     

    However, as David pointed out that there could be issues for the SQL server connections specifically, if you run Win2003 or Win2008 without a Service Pack. The example he mentioned is discussed here:

    https://support.microsoft.com/en-us/help/2517589/an-ado-application-does-not-run-on-down-level-operating-systems-after-y… 

     

    Kind Regards,

     

    Martin Fink

    CA Tech Support