Go back to the root Databases folders and expand the Security folder, which should be just below it. Once there, do the following:
- Right-click on the Logins subfolder and choose New Login.
- In the modal window that appears, set the login name to WorldCities.
- From the radio button list below the login name, select SQL Server Authentication and set a suitable password with decent strength (such as MyVeryOwn$721—we're going to use this one for the code samples and screenshots from now on).
- Be sure to disable the User must change the password at next login option (which is checked by default); otherwise, Entity Framework Core will be unable to perform the login later on.
- Set the user's Default Database to WorldCities.
- Review all of the options, then click on OK to create the WorldCities account.
If we want a simpler password, such as WorldCities or Password, we might have to disable the enforce password policy option. However, we strongly advise...