Forum Discussion

PeaceAz's avatar
PeaceAz
Copper Contributor
Oct 24, 2020

Cannot connect to Sql Server Database in SSMS. Error 26

Have you ever encountered this error? Please how do you fix it as I've tried to restart sql server on services but still not fixed

5 Replies

  • RayPorrata's avatar
    RayPorrata
    Copper Contributor

    Hi PeaceAz ,

     

    There may be several things you may try.

    We need to verify the access from your system to the server, the following steps may assist.

     

    1. Can you ping the server from your location? Just to ensure the path is clear you can get to the server

    2. Is there a firewall between you and the server?

    Blocked ports will prevent communications; check out https://docs.microsoft.com/en-us/sql/sql-server/install/configure-the-windows-firewall-to-allow-sql-server-access

    3. Which protocols are you using with Sql Server? This may be determined by what is being used on the server via the Sql Server Configuration Manager. Ensure your client side tool

    4. Are you using encryption in your environment? if so you may need to go to the advance tab on SSMS and ensure it is on.

     

    I hope one of these options work for you.

    Regards,

Resources