DX Unified Infrastructure Management

  • Private Community
 View Only

  • 1.  SQL Server Probe Connection Error

    Posted Jul 31, 2020 08:46 AM
    Hi,

    While configuring SQL Server probe, we are not able to make connection with the SQL Database. We are using Windows Authentication via Domain Account, it is able to detect domain automatically. However, while testing the connection, it is giving error " Connection to Server "xxxxx" failed with: Domain Logon failed".

    We tried to login the server with same credential and it is successful then we connect to database using SQL Server Management Studio and windows authentication, which is also successful.

    Then we telnet port 1433, which is working fine, checked local firewall, rules are allowing port 1433 and sqlservr.exe program (Nimsoft Path).

    As part of troubleshooting, we then disable firewall, Robot service authentication is working, however, windows authentication is not working, giving same error "Connection to Server "xxxxx" failed with: Domain Logon failed"."

    Please suggest any other thing that needs to be checked or a possible solution if any.

    Thanks,

    Regards,
    Sagar


  • 2.  RE: SQL Server Probe Connection Error

    Broadcom Employee
    Posted Jul 31, 2020 09:17 AM

    I would suggest unchecking the auto-detect and use the format for domain\user.
    What version of the probe are you using?
    Is it local to the database?
    Is TLS 1.2 enabled?
    Try logging into the machine with the probe as the user in the profile and see if you can create an odbc connection using windows auth.



    ------------------------------
    Gene Howard
    Principal Support Engineer
    Broadcom
    ------------------------------

    Original Message


  • 3.  RE: SQL Server Probe Connection Error

    Posted Jul 31, 2020 09:24 AM
    Hi Gene,

    Tried unchecking the auto detect option, still getting the same error. Probe Version is 5.42
    Yes it is deployed on the same server where sql db is running.
    TLS 1.2 is not enabled.

    Same user is able to log in to the server and can authenticate to the sql db via windows authentication.

    Regards,
    Sagar
    Original Message


  • 4.  RE: SQL Server Probe Connection Error

    Broadcom Employee
    Posted Jul 31, 2020 09:19 AM
    HI Sagar,

    Sound like your sqlserver probe is remote. Are you checking Studio from the same server you are running probe from? Try toggling the Encryption check box in the connection screen.
    Original Message


  • 5.  RE: SQL Server Probe Connection Error

    Posted Jul 31, 2020 09:25 AM
    Hi Gregg,

    SQLServer probe is local. Yes I am checking the studio from the same server where probe is running.

    Regards,
    Sagar
    Original Message


  • 6.  RE: SQL Server Probe Connection Error
    Best Answer

    Broadcom Employee
    Posted Jul 31, 2020 09:32 AM
    open a support case and ask for sqlserver_5.42T5

    ------------------------------
    Gene Howard
    Principal Support Engineer
    Broadcom
    ------------------------------

    Original Message


  • 7.  RE: SQL Server Probe Connection Error

    Broadcom Employee
    Posted Jul 31, 2020 09:32 AM
    You can get into Studio so you should be able to check the SQLServer Logs. See what SQL Server is saying about your login attempts.
    Original Message