Set up ZyDB and ZyStatDB databases

1. Start Deployment Manager, and locate the ZyDB Configuration in the top of the screen.

2. In IP, enter the hostname of the SQL server that hosts ZyDB, for example: WinAppServer

3. In Port, enter 1433

4. In Username, enter ZyUser

   For security reasons, don’t use the sa account (user name: sa).

5. In Password, enter the password for MSSQL user ZyUser

6. In Database, enter ZyDB

7. Click Save

8. You should see this message: Successfully connected to database: zydb (ZyDB: 0.0.0.0)

1. In the Deployment Manger menu, select Database > ZyDB > Update

2. Click Update, and wait for approximately one minute for the update to complete

3. Click Create to create user

You must import at least one language for ZyDesk to work correctly.

1. In the Deployment Manager menu, select Database > ZyDB > Language

2. In Import Language, select required language

3. Click Compare

4. Click Upload

You can import more than one language if you repeat the steps.

You must save a license key in ZyDB before you can use the software.

1. In the Deployment Manager menu, select Database > ZyDB > License

2. Click Get License

3. Paste your license key into the field

4. Click Save License

You must import at least one ZyDesk profile for ZyDesk to work.

1. In the Deployment Manager menu, select Database > ZyDB >Profile

2. Select the profile type that matches your available licenses and the ZyDesk product that you need.

3. Click Upload

If you have licenses for more than one product, repeat the steps to upload additional profiles.

1. Restart the Deployment Manager

2. In the Deployment Manager menu, select Database > StatDB, and locate the Statistics Database Settings.

3. In IP, enter the hostname of the SQL server that hosts ZyStatDB, for example: WinAppServer

4. In Port, enter 1433

5. In Username, enter ZyUser

   For security reasons, don’t use the sa account (user name: sa).

6. In Password, enter the password for MSSQL user ZyUser

7. In Database, enter ZyStatDB

8. Click Save Configuration

9. You should see this message: Successfully connected to StatDB ZyStatDB

10. Click Update

1. In the Deployment Manger menu, select Database > ZyDB > Update

2. In Update Database, verify that Current Database Version isn't 0.0.0.0

Now you know that Deployment Manager can locate and connect to ZyDB, and the database has tables and programmability.

1. In the Deployment Manager menu, select Database > StatDB, and locate the Statistics Database Settings.

2. Click Save Configuration

3. In Update Statistics Database, verify that Current Database Version isn't 0.0.0.0

Now you know that Deployment Manager can locate and connect to ZyStatDB, and the database has tables and programmability.