Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/change-server-authentication-mode
- To change security authentication mode
- In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
- On the Security page, under Server authentication, select the new server authentication mode, and then click OK.
- In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.
- In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.
- To enable the sa login
- In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties.
- On the General page, you might have to create and confirm a password for the login.
- On the Status page, in the Login section, click Enabled, and then click OK.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement