issue with sql connectivity

  • vsamantha35

    SSChampion

    Points: 11077

    Hi Experts,

    This is more of a generic question on sql connectivity.

    Under what circumstances, users will not be able to connect to sql server instance. The services are up and running though.

    Firewall is open. TELNET is working and still users are complaining that there app's are unable to connect to sql server.

    What could possible reasons for users unable to connect to SQL Server and what could be done / what tests / checklist to be followed during that time.

    sample error msg

    connection err

    Thanks,

    Sam

  • Grant Fritchey

    SSC Guru

    Points: 395586

    It could be any number of things. The port is blocked for them. The DNS doesn't recognize the name. The IP address is wrong. Wrong password (sql login, which it looks like what you have). Incorrect permissions for the application (I know, the developers said it's perfect, they always do). Permissions on the server. Permissions on the database. No matter how often you hear that everything is configured perfectly, when stuff like this comes up, something is misconfigured, guaranteed.

    I'd start with a simple ping. Can you ping the IP address of the server from the client? Next, ping with a port. Here's a decent article on some other steps you could take.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • vsamantha35

    SSChampion

    Points: 11077

    Thank you very much Sir.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply