Open SQL Server Management Stduio and connect to the database server as a sysadmin. This can be done by logging on locally using Windows Authentication, or externally by using the ‘sa’ credentials.
Right-click on “Database” and select “New Database“. Enter the name of your database and click OK to create the database.
Right click on “Security” in the left pane, and select “New“, then “Login“.
Enter the desired user name, and select “SQL Authentication“, then enter the desired user password. Ensure to uncheck the “Enforce password expiration” option.
Select your new database as the Default database, and click on User Mapping on the left side. Click the check box next to your database, and click the check box next to “db_owner“.
Lastly, click OK to create the login and database user.