Access from the SQL server is not allowed. access from the SQL Server
I remember that I added sqlservr.exe to the internal access table of the firewall, and telnet can also be connected,
However, SSMS cannot be connected, and the instance name is correct.
The study found that the SQL browser is not added to the firewall's internal access table. It needs to open the UDP1434 port and add the UDP1434 to the firewall's internal access table,
SSMS can be connected.
SQL server cannot access the server
I also encountered this problem yesterday. After half a day, I checked it online, which is a problem with IIS permissions.
Solution
1. First, check which application pool your website uses
2. Set application pool options
You only need to select LocalSystem or NetworkService to solve the problem.
SQL cannot connect to the local server
This type of failure is often because you have changed the default Instance name when installing SQL Server, or you are not allowed to connect to the MPs queue when optimizing the system, it is also possible that you have disabled the Named Pipe in "server network utility. Solution: In start-run, type services. msc press enter to see what is behind MSSQLSERVER, such as MSSQL $ PC17. If $ Instance name is followed, the format of the connection is 127.0.0.1 \ Instance name. If it is caused by optimization, it is called the person who optimizes the system, because he is too smart! In the third case, Open start-Program-Microsoft SQL Server-Server network utility-to enable the MPs queue.