(if you don’t want to provide a complex password for the sa account, you can uncheck this option. By default, the Enforce password policy is checked.
Specify a complex password for the sa account. Right-click on the sa account and go to Login Properties.
#Windows 10 look up password for sql studio install#
You can see the sa account is disabled when you install SQL Server using Windows Authentication mode.ģ. Connect to the SQL Server instance using SSMS and go to Security. After restarting the SQL Server, the authentication mode will be changed to SQL Server and Windows Authentication mode. Once you clicked on the Ok button, we will get the following screen:Īs discussed earlier, we need to restart the SQL Server service to make this change effective. Click on the radio button next to SQL Server and Windows Authentication mode, and click on OK to close the Server Properties page.ģ. On the Server Properties page, Click on Security. Right-click on the database instance, and go to Properties.Ģ.
Login to the SQL server instance using SQL Server Management Studio. You need to remember that, the SQL Server service needs to restart to make this change effective.ġ. To Change the Authentication Mode:įollow the steps mentioned below to change the authentication mode from Windows Authentication to SQL Server and Windows Authentication. You need to change the authentication mode for SQL server from Windows Authentication Mode to SQL Server and Windows Authentication Mode to use the sa account. Sometimes, due to users/customers request, you may need to enable the sa account. When you install the SQL Server using Windows Authentication mode, by default, the “ sa” account is disabled.
0 kommentar(er)
