Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to configure SA login in SQL Server 2016. Many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

Tips: find the SQL Server 2016 configuration manager in win10, which is used to enable SQL Server network configuration and enable instance TCP/IP protocol and Name PiPe.

Windows 10:

To open the SQLServer configuration Manager, type SQLServerManager13.msc in the start Page (for SQLServer 2016). For earlier versions of SQL Server, replace 13 with a smaller number. Click SQLServerManager13.msc to open the configuration Manager. To dock the configuration manager to the start page or taskbar, right-click SQLServerManager13.msc, and then click Open File location. In Windows File Explorer, right-click SQLServerManager13.msc, and then click dock to start screen or dock to taskbar.

Step 1: login in windows mode. In the following node of object resource management, right-click Properties-Security and select mixed login of SQLServer and windows

Step 2: set the Sa login password in Security-Login name-Sa.

Part III: open the network protocol in tips in the configuration manager.

The above is the SQL Server 2016 configuration introduced by the editor.

PS: let's take a look at the solution to the failure to log in to SQL Server 2016 SA account.

It's always baffling when you can't log in to your sa account. In fact, the crux of the problem and the solution are as follows:

1. If you keep connecting for a short period of time, it will be mistaken for an attack by SQL SERVER, and this account will be

Lock.

To log in windows, type in the query analyzer:

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

2. Leave the password empty, and then restart the login.

3. Open "SQL Server configuration Manager", expand "SQL Server Network configuration", and turn on "TCP/IP" in "MSSQLSERVER Protocol".

4. Restart "SQLServer" service

After reading the above, do you have any further understanding of how SQL Server 2016 configures SA login? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.