How to create SQL Server Authentication Username and Password?

To create a SQL Server authentication username and password, follow these steps:

Connect to SQL Server: Open SQL Server Management Studio (SSMS) and connect to your server using an account with sufficient privileges.

Expand Security and Create Login:

In Object Explorer, expand the "Security" folder, then right-click on "Logins" and select "New Login...".

Enter Login Details:

In the Login - New window, under "General", enter the desired username in the Login name field.

Select "SQL Server authentication" and enter the desired password.

Configure Password Options:

Optionally, uncheck "Enforce password policy" if you don't want to enforce complexity rules.

Assign Roles:

Under "Server Roles", assign roles like sysadmin, db_owner, or other appropriate permissions.

Click OK: After configuring, click OK to create the new SQL Server authentication login.

This creates a SQL Server authentication login that can be used to connect to the database with a username and password.