Hello. This error pops up when installing Management Server Configuration from Symantec (in the second image). Because of it, installation is no longer possible. The link suggested by this error (Please Click here for more information) offers two solutions, but I myself cannot understand what needs to be done. I ask smart people to explain on the fingers. Perhaps this is important: SQL 2014, downloaded from the official Microsoft website. SQLEXPR32_x86_RUS file.

I copy the text of the proposed solution:

There are two problems that can be caused. Network connectivity between the Microsoft SQL Server and the Microsoft SQL Server is unavailable. Ensure that the SQL Server's IP address is entered. Use the ping command to determine whether the network traffic can flow between the manager and the SQL server. Microsoft SQL Server is not a protocol in this case, it enables Microsoft SQL Server TCP / IP protocol. To enable TCP / IP, Microsoft SQL Server 2000: Microsoft SQL Server 2000: In SQL Server Network Utility, add TCP / IP to the Enabled protocols list. Microsoft SQL Server 2005 or 2008: In SQL Server Configuration Manager, go to the SQL Server Network Configuration> Protocols for MSSQLSERVER, and enable TCP / IP protocol. Once you enable the TCP / IP protocol, restart the SQL Server service.

More specifically, I realized that TCP / IP must be enabled in the SQL server configuration. I did this. But the error is the same. Help me figure out what's what, please.

Manager Server Configuration Wizard

enter image description here

  • Try specifying Database server ip address. - Andrew Hobbit
  • Thanks for the advice, but something does not help. Or am I using the wrong address? The site 2ip.ru shows my address: 212.42.51.131. I enter it in the Database Server field, but this does not solve the problem. - Pavel Dereviansky

1 answer 1

Could win this problem by:

  1. SQL Server Configuration Manager> SQL Server Network Configuration> enable the TCP / IP protocol, also in the protocol properties in the IP Address tab, we add 1433 to the TCP Port. Reboot the SQL Server service.
  2. Adding rules to the firewall (specify your IP): netsh advfirewall firewall add rule name = "SQL Srv_Open static 1433" dir = in action = enable protocol = TCP localport = 1433 enable = yes profile = ANY remoteip = 192.168.1.1 interfacetype = lan
  3. In the Manadgement Server Configuration Wizard: Database server (specify IP), SQL server port 1433, Server user name (user through. \)