How to configure SA logon in SQL Server 2016, 2016sa

How to configure SA logon in SQL Server 2016, 2016sa

Tips:Find the SQL Server 2016 Configuration Manager in win10 to enable the SQL Server network configuration, and enable the instance TCP/IP protocol and Name PiPe.

Windows 10:

To open the SQL Server Configuration Manager, type SQLServerManager13.msc on the "start page" (applicable to SQL Server 2016 ). For earlier versions of SQL Server, replace 13 with a smaller number. Click "SQLServerManager13.msc" to open the Configuration Manager. To pin the Configuration Manager to the "start page" or "Taskbar", right-click "SQLServerManager13.msc" and click "open file location ". In "Windows File resource manager", right-click "SQLServerManager13.msc", and click "fixed to 'start' screen" or "fixed to Taskbar ".

Step 1: Log On in windows mode. Right-click the tracking node of object resource management and choose SQLServer and windows hybrid logon for security,

Step 2: Set the Sa logon password in security-Logon Name-Sa.

Part 3: enable the network protocol in tips in the Configuration Manager.

The preceding section describes the configuration of SQL Server 2016.

PS: Next, let's take a look at the solution for failing to log on to the SQL Server 2016 SA account.

The sa account cannot be logged on, which is confusing. In fact, the key and solution are as follows:

1. If the connection is not interrupted for a short period of time, it will be mistaken by SQL SERVER for attack.

Locked.

Log on to the analyzer in windows and enter:

ALTER LOGIN sa ENABLE ;GOALTER LOGIN sa WITH PASSWORD = '' unlock, check_policy = off,check_expiration = off ;GO

2. Leave the password blank and restart the logon.

3. Open "SQL Server Configuration Manager", expand "SQL Server network configuration", and enable "TCP/IP" in "MSSQLSERVER protocol ".

4. Restart the "SQLServer" Service

The SA logon tutorial is helpful to you. If you have any questions, please leave a message and the editor will reply to you in time. Thank you very much for your support for the help House website!