Configuring MS SQL Server

Top  Previous  Next


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



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 press the 'Configure Analytics' button:


Choose 'Microsoft SQL Server'.


4. Access the Microsoft SQL Server Data Link Properties and configure the 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.


5. Go to the 'All' tab:



5.1 Set the 'Persist Security Info' property to 'True'.

5.2 Type the password in the 'Password' field.

Read More:

Configuration Manager - Server - Permission Settings
Features - Admin Control Panel
Analytics Tables Reference