SQL Server not found or unable to access server problem solved, Server not found

SQL Server not found or unable to access server problem solved, Server not found

Problem information: "network-related or instance-specific errors occur when you establish a connection with SQL Server. The server is not found or cannot be accessed. Verify that the Instance name is correct and SQL Server is configured to allow remote connection. (Provider: named pipeline provider, error: 40-unable to open the connection to SQL Server )".

Solution:

1. Open the Configuration Manager

2. Open the Configuration Manager and start the SQL Server service. The final result is as follows:

Now, the problem is solved.

Sputation: After encountering this problem, I rummaged over the webpage and read more than a dozen so-called solution articles. What are the results? These dozens of articles talk about dianyao cloud, which cannot solve the problem at all. Even more irritating is that many people, regardless of the content of the article, are so crazy to reprint it that these articles are all online ......

When connecting to the SQL database with ASPNET, the system prompts that the server is not found or cannot be accessed. Why?

Can I connect directly to the database? Whether your database is set to the hybrid login mode and whether the login name has the permission to log on. You need to restart the database (not disconnect) after setting ). I used to set up and didn't restart the database. Hope to help you

The installed SQL Server R2 cannot connect to the local data, and the system prompts that the local data is not found or cannot be accessed by the server.

The related services are not enabled after installation, right?
Do you use "SQL Server Authentication" or "Windows Authentication" during installation "?
To install and use "SQL Server Authentication", follow these steps:
1. Microsoft SQL Server 2008-> Configuration tool-> SQL Server Configuration Manager-> SQL Server service, start the SQL Server (MSSQLSERVER) service and SQL Server proxy (MSSQLSERVER) service.
2. SQL Server network configuration-> MSSQLSERVER protocol, start TCP/IP.