Microsoft SQL Server
Database setup on a Microsoft server requires configuration of the server and creation of the database.
- Configuring Microsoft SQL Server
Database setup is done on the Microsoft SQL server. - Creating a database
Create a database for the Content Manager data collection. - Importing data from the SQL dumpfile
Import the sample Content Manager database dump to validate the configuration and for training purposes. - Removing the database user and schema
To ensure successful creation of a new database user and schema, delete the user that was created when importing the sample data, as well as the schema of the same name if one exists. - Creating a new database user and schema
Add a new user to connect to the newly created database. - Optionally minimize the database user's roles and permissions
Describes how to optionally reduce the roles and permissions of the database user for everyday usage