4 views

1 Answers

Open Microsoft SQL Server Management Studio. Connect to SQL Server as the 'SA' or an administrative user. Right-click on the Security folder > New > Login. Type in a login name. Check the bullet for SQL Server Authentication and type in a password. Click 'User Mapping' at the top left under 'Select a Page'. Check the database(s) to apply the user to, and type in the username for 'Default Schema'.

4 views