Installing the MetaCommunications SQL SDK to a Database

The following procedures outline the necessary steps for installing SQL SDK for Virtual Ticket, Job Manager, Digital Storage Manager, and Approval Manager on a Microsoft SQL Server database. Procedures are provided for installing the SQL SDK to databases hosted by both MS SQL Server 2000 and MS SQL Server 2005. Please refer to the procedure appropriate to your version of MS SQL Server.

Important! The script used to install the SQL SDK utilizes the SQL Server Agent provided with Microsoft SQL Server. Before installation of SQL SDK, make sure that the SQL Server Agent service is installed, and running. It is recommended that the SQL Server Agent be configured to run automatically on startup.

Installing the SQL SDK stored procedures to a database using Management Studio (MS SQL Server 2005)

1. Open MS SQL Server 2005 Management Studio.
2. Connect to the SQL Server hosting the database to which you want to install the MetaCommunications SQL SDK.
3. Select Open> File... in the File Menu. The Open File window will appear.
4. Browse to and select the sql_sdk.sql file installed with the MetaCommunications SQL SDK. By default, this is installed to the following location: C:/Program Files/MetaCommunications/SQL SDK/sql_sdk.sql
5. Click Open ( ). The sql_sdk.sql file will open in a pane in the Management Studio.

1. Select the database to which you want to install the MetaCommunications SQL SDK in the popup list of available databases.

1. Click Execute ( ). The stored procedures included in the MetaCommunications SQL SDK will install to the selected database. A list of messages and actions will appear at the bottom of the sql_sdk.sql pane when installation is complete. You may ignore these if there are no error messages. To install the stored procedures to another database, repeat the steps above.

Installing the SQL SDK stored procedures to a database using Query Analyzer (MS SQL Server 2000)

1. Open the Start menu of the Microsoft Windows Server machine where your database is located. From the Programs menu, select the Microsoft SQL Server menu, and select Query Analyzer.
2. Connect to the desired SQL Server.
3. In the Query Analyzer window, select the desired database from the DB: dropdown list on the toolbar.
4. Select File:Open from the menu at the top of the window, or click on the Load SQL Script button on the toolbar.
5. Select the sql_sdk.sql query file from its location on the hard drive, network or CD, and click Open. This is the T-SQL script that will install the SQL SDK stored procedures onto the selected database.
6. With the query file open, select Query:Execute from the menu at the top of the window, or click the Execute button on the toolbar.

The stored procedures included in SQL SDK for Virtual Ticket, Job Manager, Digital Storage Manager, and Approval Manager have now been installed onto the database you selected in step 3. A listing of messages and actions will appear at the bottom of the window when the installation is complete. You may ignore these if there are no error messages. To install the procedures in another database, repeat the above procedure, selecting the new database in step 3.