|Manuals

Configuring MS SQL Server

MS SQL Server is needed by z/Scope Anywhere to store Analytics data.

Requirements:

  1. An MS SQL Server 2005 (or higher) installation that is accessible from the machine running z/Scope Anywhere Server.

  2. Create a blank database with permissions to Create/Modify tables and Read/Insert/Update data.

  3. Go to the ‘Permissions’ tab in the Server Settings section of the z/Scope Anywhere Configuration Manager, and select Configure Analytics button:

Database Options dialog with Microsoft SQL Server selected

Choose Microsoft SQL Server.

  1. Access the Microsoft SQL Server Data Link Properties and configure the connection:
Data Link Properties Connection tab for configuring the SQL Server connection

4.1 Enter the server name and complete the information to log in to the server.

4.2 Uncheck the Blank password field and check the Allow saving password field.

4.3 Select the database created in step 2.

  1. Go to the All tab:
Data Link Properties All tab for setting Persist Security Info and Password

5.1 Set the Persist Security Info property to True.

5.2 Type the password in the Password field.

See Also