Telegram - . ? :)

3

SQL , :

A connection was successfully established with the server but then an error occurred during login process. (Provider: Shared Memory Provider, error: 0  No process is on the end of the pipe.) (Microsoft SQL Server, Error: 233).

, .


TCP/IP

, SQL 1433, TCP. TCP/IP Configuration Manager:

  1. SQL ;
  2. SQL Server Configuration Manager. SQL Server Network ConfigurationProtocols for %%;
  3. , TCP/IP (Enabled). , Enabled = Yes;
 SQL Error 233  TCP/IP

() SQL .


Named Pipes

Named Pipes ( ) , . , 233 :

  1. SQL ;
  2. SQL Server Configuration Manager. SQL Server Network ConfigurationProtocols for %%;
  3. , Named Pipes (Enabled). , Enabled = Yes;

TCP/IP, (. ).


*** !

, . . , , , , 233.

1433 . :

  1. WF.msc ( );
  2. Windows Firewall with Advanced Security, , Inbound Rules, New Rule ;
  3. Rule Type Port, Next;
  4. Protocol and Ports, TCP. Specific local ports 1433. Next;
  5. Action (, ?), Allow the connection, Next;
  6. Profile (Domain, Private, Public). ! - Public;
  7. , , Allow inbound SQL;
Windows Firewall Inbound Rule  SQL               -    Windows Firewall

. :

  1. SQL Server Management Studio ( SQL );
  2. ( , ), Properties;
  3. Connections. Allow remote connections to this server;
  4. OK;
SQL Server Management Studio  SQL Allow remote connections to this server

SQL, , ? :)


?