Hello.

I start Microsoft SQL Server Management Studio, I want to connect to the server, this error gives:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, ошибка: 2)

What to do?

Microsoft SQL Server 2008.

  • rather, for all of you, either the server is not running or it does not have TCP / IP listener running. try to do telnet <ip> 1433 (standard port) if it does not connect, then rather it is for everything. google "MS SQL enable tcp listening" - jmu
  • Thanks for the answer. I tried it all, it still did not start, but the problem was solved, the new package downloaded and everything was fine, the installation was OK and the problem started after the package. - Hamo

0