Creating the database
About this task
Use the MS SQL management studio to complete the following steps:
Note: During the installation of MS SQL, mixed mode authentication
should have been set up.
Procedure
- Click Connect.
- Right-click the server tree and click properties.
- Select security.
- Ensure that SQL server and authentication mode is selected.
- Expand the server tree.
- Right-click databases.
- Select Create New Database.
- Enter a name for the database. For example, TRCDB. Click OK.
Results
Database permissions
The default system administrator is the owner of the database and therefore has the required permissions for using the database. If you have created a new user, they also have the required permissions if they have been assigned as the owner of the database.