Tamil Amuthan Staff asked 4 years ago
SQL Authentication is the typical authentication used for diverse database systems, composed of a username and a password. Obviously, an instance of SQL Server can have a couple of such consumer accounts (the use of SQL authentication) with distinct usernames and passwords.SQL Authentication is the typical authentication used for diverse database systems, composed of a username and a password. Obviously, an instance of SQL Server can have a couple of such consumer accounts (the use of SQL authentication) with distinct usernames and passwords.
Change SQL Authentication mode with SSMS:
- In SQL Server Management Studio Object Explorer, right-click on the server, after which click Properties.
- On the Security page, below Server authentication, choose the brand new server authentication mode, after which click OK.