Configuring an Microsoft SQL Server repository
This procedure illustrates how to configure a repository using Microsoft SQL Server 2008 Management Studio.
The user ID and schema name must have the same name as the FortiDB repository. |
Create a SQL database
- Log in as sa.
- Right-click Databases.
- Click New Database.
- For the database name, enter
fortidb
. - Configure the database using the following values:
Initial data-file size 300 MB (minimum) Initial log-file size 20 MB (minimum) Collation value A value that supports case-sensitivity
The characters “CS” in a collation value indicate that it is case-sensitive. For example, the collation value SQL_Latin1_General_CP1_CS_AS is for U.S. English systems and is case-sensitive.
- Click OK.
Create a SQL login
- Go to Security.
- Right-click Logins.
- Click New Login.
- For Login name, enter
fortidb
. - Select SQL Server authentication, and then enter and confirm a password.
- Clear Enforce password expiration.
- For Default database, select fortidb.
- On the User Mapping page, for Users mapped to this login, select fortidb.
In the User column for the fortidb list item, fortidb is displayed.
- Select the fortidb item in the list of users, and then, for Database role membership for: fortidb, select db_owner.
- Click OK.
Create the fortidb schema
Ensure that the schema uses the same name as login name that you created in the previous step. |
- Log in using the user (fortidb) and password.
- Go to Databases > fortidb > Security.
- Right-click Schemas, and then select New Schema.
- For both Schema name and Schema owner, enter
fortidb
. - Click OK.
- Go to Databases > fortidb > Security > Users.
- Right-click the fortidb user, and then click Properties.
- For Default schema field, enter
fortidb
. - Click OK.
Verify that the login is mapped to the correct schema and user
- Log in as
sa
. - Go to Security > Logins.
- Right-click fortidb, and then select Properties.
- On the User Mapping page, verify that "fortidb" is both the user and default schema value for the fortidb item.