Failure to connect to the database network or log in to the database

SQL Server failed to connect to the Server

The solution

1. Open the SQL Server Configuration Manager. The SQL Server configuration manager is displayed

Note: If you can’t find it, it may be in the file. The SQL Server configuration manager for many computers after Windows 10 is often placed in a file that can be searched on the Web.

2. Enable SQL Server network configuration

Select the protocol for SQLEXPRESS.

3. Enable TCP/IP, access properties, change the IP address, and enable the IP address to 127.0.0.1

4. Change port number to 1433. The dynamic data port does not need to be changed

5. Apply and save

6. Restart SQL SQL Server configuration Manager

7. Start the computer service and restart SQL EXPRESS

8. Close and restart Microsoft SQL Server Management Studio 2017

Unable to use a custom login name

Other information: The connection to the server was successfully established, but an error occurred during login. (Provider: Shared Memory Provider, error: 0 – There is no process on the other end of the pipe

The solution

The login name created in the database needs to change the permission, you can change according to the requirements.

Sql Server cannot log in to the database

The connection to the server was successfully established, but an error occurred during login. Provider: shared memory provider, error: 0

The solution

Right-click the Server, in Security, and select SQL Server and Windows authentication modes

On the server, go to “Security “-> Login name -> Select SA login account (right click)-> Status -> Login change to Enable

Scan the QR code to obtain

More wonderful

Internet of Things knowledge

This article uses the article synchronization assistant to synchronize