Settings on SQL Server Management Studio and SQL Server Configuration Manager

Open SSMS (SQL Server Management Studio) and under Object Explorer, expand Security

Right click on Logins, create a New Login and enter a username and a password

Beneath General, located in the left bar, select Server Roles and enable public

Create a new database by right-clicking on Databases. Name it planet9 (keep all options on default)

Create a new user under planet9 from Database > Security > Users and give the user that was created in the above steps:

Under Owned Schemas, set the following parameters:

Under Membership, set the following:

Create a new Schema under the planet9 database and name it planet9:

Search for Schema owner. In the below picture we are adding the same user that we created under Databases:

Set the Server Authentication :

Restart the server