Post reply

issue with sql connectivity

  • September 11, 2019 at 6:35 am

    Go to Answer

    #3679020

    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

  • September 11, 2019 at 11:49 am

    Answer

    #3679082

    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

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • September 11, 2019 at 1:36 pm

    #3679121

    Thank you very much Sir.

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

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