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

Source: Internet
Author: User
Tags mssqlserver

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.

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.