Access from the SQL server is not allowed. access from the SQL Server

Source: Internet
Author: User

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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.