Setting up an SQL Server database
Before installing WorldServer on your environment, you need to create an populate an SQL Server database.
Before you begin
You must have a supported Microsoft SQL Server instance up and running. You must also have adequate permissions to access this instance and to perform various operations.
Permissions required for database users
To create an SQL Server database, you need an SQL Server user that has database creation permissions (such as sa). If you want to create users used only by WorldServer, make sure you assign them the db_owner role for the WorldServer database.
If you want to use the System Monitor tool, make sure that the user also has READ rights on the following tables:
sys.dm_tran_lockssys.dm_os_waiting_taskssys.partitionssys.dm_exec_requestssys.dm_exec_sessionssys.databasessys.dm_exec_connectionssys.dm_exec_query_stats
GRANT VIEW SERVER STATE TO <username>where <username> is the name of the database user.
Creating the SQL Server database
This process should generally be performed by a database administrator.
- Log in to SQL Server Management Studio as a user with database creation permissions (for example, sa).
- In Object Explorer, right-click the Database tree, and then click New Database.
- In the New Database window, type a name for the new database and make other configurations, if necessary.
- Click OK. The new database has been created and added to the Databases tree.
Populating the database schema
After you have created the SQL Server database, you can populate the database schema. To do so:
- Copy the following scripts from the sql folder of your WorldServer distribution kit to a working directory on your SQL Server client machine:
- create.ms.sql
- create_sp.ms.sql
- create_tr.ms.sql
- setup.ms.sql
- In SQL Server Management Studio, right-click the database you have just created, and then, on the shortcut menu, click New Query.
- Run the following queries:
- create.ms.sql
- create_sp.ms.sql
- create_tr.ms.sql
- setup.ms.sql
At this point, your database schema has been populated and can be used by WorldServer. You can now install WorldServer on the supported operating system of your choice.