Troubleshooting SQLServer2008 Express Remote connection error [error:1326 ERROR]

The Sqlserver2008 Express version defaults to a native test connection and cannot be accessed by other clients because the Express version of the database is connected by default TCP/IP snooping is turned off, and we can do some setup to implement our remote connection. Here are some of the more detailed remote connection report 1326 error Solutions I summarized:

1. Confirm that the SQL Server database service is started, if it is not started, to start it, including the browser service and the SQL Server service

2. Verify that the network of the remote client to the database server is unblocked and can be detected in cmd with a ping command.

3. Check whether TCP/IP snooping is turned on for express version.

　　

4. Check if "Allow remote connections to servers" is checked in the connection of database instance properties

　　

5. Check that the network firewall is turned off, and of course you can set exceptions.

If these settings are successful, you should already be able to connect.

Troubleshooting SQLServer2008 Express Remote connection error [error:1326 ERROR]