[SMSS]How can i fix this?

Results 1 to 3 of 3
  1. #1
    Apprentice worranyccup is offline
    MemberRank
    Apr 2021 Join Date
    13Posts

    sad [SMSS]How can i fix this?

    Subject: Connecting to Server ------------------------------ 127.0.0.1.1433 could not be reached. ------------------------------ Additional Information: A network related or instance related error occurred while connecting to SQL Server. The server cannot be found or cannot be accessed. Make sure the instance name is correct and that SQL Server is configured to allow remote connections. (Provider: Named Pipe Provider, Error: 40-Could not open connection to SQL Server.) (Microsoft SQL Server, Error: 1231)
    Last edited by worranyccup; 08-04-21 at 02:54 PM.


  2. #2
    Proficient Member memvoicam is offline
    MemberRank
    Nov 2014 Join Date
    JapanLocation
    179Posts

    Re: [SMSS]How can i fix this?

    check port 1433 of SQL Server.
    Last edited by memvoicam; 09-04-21 at 12:18 PM.

  3. #3
    Apprentice Nitetime is offline
    MemberRank
    Dec 2018 Join Date
    21Posts

    Re: [SMSS]How can i fix this?

    Quote Originally Posted by worranyccup View Post
    Subject: Connecting to Server ------------------------------ 127.0.0.1.1433 could not be reached. ------------------------------ Additional Information: A network related or instance related error occurred while connecting to SQL Server. The server cannot be found or cannot be accessed. Make sure the instance name is correct and that SQL Server is configured to allow remote connections. (Provider: Named Pipe Provider, Error: 40-Could not open connection to SQL Server.) (Microsoft SQL Server, Error: 1231)
    Try changing 127.0.0.1.1433 to 127.0.0.1:1433



Advertisement