Step 3 - Create a Blank SQL Server Database

SQL Server

Note: This step is optional, and only required if using a SQL Server database. If you are not using a SQL Server database go to the next step.

Create a blank SQL Server database for the Library you want to work with - most of the time, you'll only need one. Read about when to use more than one library.

You'll also need to set up SQL user permissions:

Make sure each person who will use the library database/s has the necessary security permissions to read and write to the database.

• Each user who will use Author-it will need at least db_datareader, and db_datawriter privileges on the SQL Server database.
• Each user who will administer the database will also need db_dbadmin privileges on the SQL Server database.

These privileges can be allocated using user groups, and if using trusted connections, you can use the NT/Active Directories user groups.

We recommend you use NT permissions and trusted connections, to minimize your security administration workload. Also, only SQL Server library databases which were opened with trusted connections are listed in the Most Recently Used files list in the Author-it client program.

For detailed instructions about using SQL Server, please refer to your SQL Server user documentation.