Change sql authentication mode after installation

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Feedback will be sent to Microsoft: By pressing the submit button, your feedback will be used to improve Microsoft products and services. Privacy policy. Applies to: SQL Server all supported versions.

After installation, you can change the authentication mode at any time. If Windows Authentication mode is selected during installation, the sa login is disabled and a password is assigned by setup. If you later change authentication mode to SQL Server and Windows Authentication mode , the sa login remains disabled. The sa account is a well known SQL Server account and it is often targeted by malicious users. Do not enable the sa account unless your application requires it.

It is important that you use a strong password for the sa login. The encrypted SQL Server Authentication login password, must be passed over the network at the time of the connection. Some applications that connect automatically will store the password at the client. These are additional attack points. Allows SQL Server to support environments with mixed operating systems, where all users are not authenticated by a Windows domain.

Allows users to connect from unknown or untrusted domains. For instance, an application where established customers connect with assigned SQL Server logins to receive the status of their orders. Allows software developers to distribute their applications by using a complex permission hierarchy based on known, preset SQL Server logins. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info.

Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? Type regedit and press Enter. Ready to try or buy? All Rights Reserved. Password Recovery Bundle.