Installation

General Notes | Database Installation | Polling Server Installation | Desktop Client Installation

General Notes About This Installation Guide

In scripts, bold items within square braces [] (e.g. [user-specified-data:default-value]) indicate user-supplied information that will need to be modified to fit your particular installation.

Database Installation

Windows User Requirements | Quick Installation | Detailed Installation 

This section describes how to download and install an empty database for the Visual Casino application to use.

Windows User Requirements

This activity requires that the windows user has permission to create both databases and users in the target database server instance.

SQL Server Service Configuration Requirements

Visual Casino requires the following settings configured in order to operate properly:

1. SQL Server Authentication must allow SQL Server Authentication (https://docs.microsoft.com/en-us/sql/relational-databases/security/choose-an-authentication-mode?view=sql-server-2017)
2. SQL Server must have TCP/IP Networking Enabled (https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-or-disable-a-server-network-protocol?view=sql-server-2017)

Quick Installation

1. On your SQL server, download the database from: https://www.biometrica.com/download/visual-casino-7-database/
2. Restore the database to your SQL server

   IF NOT EXISTS (SELECT * FROM dbo.sysdatabases WHERE [name]='VisualCasino')
   BEGIN
       RESTORE DATABASE VisualCasino 
       FROM DISK='[C:\PATH\TO\DATABASE\BACKUP]\VisualCasino6Empty2005v72.bak'
       WITH RECOVERY,
       MOVE 'VisualCasino_Data' TO '[C:\PATH\TO\DATABASE\RESTORE\LOCATION]\VisualCasino.mdf',
       MOVE 'VisualCasino_Log' TO '[C:\PATH\TO\LOG\RESTORE\LOCATION]\VisualCasino_log.ldf';
   END
   GO

3. On your SQL server, download and run the following script: https://support.biometrica.com/hc/article_attachments/360013668593/setup-sqlexpress.sql 

Detailed Installation

1. On your SQL server, download the database from https://www.biometrica.com/download/visual-casino-7-database/
2. Restore the database to your SQL server

   IF NOT EXISTS (SELECT * FROM dbo.sysdatabases WHERE [name]='VisualCasino')
   BEGIN
       RESTORE DATABASE VisualCasino 
       FROM DISK='[C:\PATH\TO\DATABASE\BACKUP]\VisualCasino6Empty2005v72.bak'
       WITH RECOVERY,
       MOVE 'VisualCasino_Data' TO '[C:\PATH\TO\DATABASE\RESTORE\LOCATION]\VisualCasino.mdf',
       MOVE 'VisualCasino_Log' TO '[C:\PATH\TO\LOG\RESTORE\LOCATION]\VisualCasino_log.ldf';
   END
   GO

3. Add an SQL User with the username of VisualCasino

   IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE [name]= N'VisualCasino')
   BEGIN
       CREATE LOGIN VisualCasino WITH PASSWORD = '[password:VisualCasino]'
   END
   GO 

4. Make the VisualCasino user an owner of the VisualCasino database

5. USE VisualCasino;
   GO
   
   IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE [name]=N'VisualCasino')
   BEGIN
       CREATE USER VisualCasino FOR LOGIN VisualCasino
       EXEC sp_addrolemember N'db_owner', N'VisualCasino'
   END
   GO

6. Make the VisualCasino database the default database for the VisualCasino user

7. EXEC sp_defaultdb @loginame='VisualCasino', @defdb='VisualCasino'

Polling Service Installation and Initial Setup

Windows User Requirements | Quick Installation | Detailed Installation | Initial Setup

This section describes how to install the Visual Casino application on the Polling Server and how to configure the polling server to run for Visual Casino 7

Windows User Requirements

Some portions of the installation and configuration will require the user to be able to install Applications and Services onto the machine performing the polling service. This will require Administrative access to the machine and may require the assistance of your organization's IT department. 

Quick Installation

1. Download the installer from: https://www.biometrica.com/download/visual-casino-7-windows-installer/
2. Run the installer

Detailed Installation

Initial Setup

Application Setup | SIN/UMbRA Service Setup | CID Service Setup | DBINIT Creation

Application Setup

1. Set the Server field to point to the Machine Name\InstanceName for the Database installed in the previous section. NOTE: If a password other than the default password was used, you will need to create a DBINIT file - see the DBINIT Creation section for this process.
2. Select the Local Authentication radio button
3. Enter the user name Administrator
4. Enter a blank password
5. Click Connect
6. Enter the Customer ID provided by Biometrica Systems, Inc.
7. Contact Biometrica Systems, Inc. and provide them with your Customer Key
8. Once Biometrica Systems, Inc. has acknowledged entering your Customer Key, Select Web Update
9. Once the update succeeds, Close the License Manager window using the X at the top right of the window
10. Enter a new password for the Administrator user - this is the root Administrator account and should only be used in emergencies.

SIN/UMbRA Service Setup

1. Select Administration > System Settings > SIN Settings ...
2. Click New to create a new Property 
3. Choose the Property for your installation from the dropdown menu
4. Select the Old Polling Mode radio button
5. Enter the SIN Station ID provided by Biometrica Systems, Inc.
6. Enter the Account Name provided by Biometrica Systems, Inc.
7. Enter the SIN Password provided by Biometrica Systems, Inc.
8. Enter the following in SIN Server: https://sin.biometrica.com/ipsin
9. Set the Polling Interval to 5 minutes
10. Set the SIN Polling Machine to the local machine's name (this should be displayed below the field)
11. Select Test - this should respond with Success. If it does not, contact Biometrica Systems, Inc.
12. Select the New SSIN Polling Mode radio button at the top
13. Enter the following in SSIN Server: https://ssin.biometrica.com
14. In SSIN Username, enter your SIN Station ID followed by helpdesk@biometrica.com
15. in SSIN Password, enter the SIN Password provided by Biometrica Systems, Inc.
16. Select Disable VC6 SIN Polling
17. Click Test - this should respond with Success. If it does not, contact Biometrica Systems, Inc.
18. Click OK

CID Service Setup

1. Select Administration > System Settings > CID Settings ...
2. Set the Polling Interval to 60 minutes
3. Enter the name of the local machine in the Polling Machine field
4. Set the Download Preference to Download and Update
5. Set the CID Update URL to: https://cid.biometrica.com
6. Click OK
7. Select Administration > Advanced Settings
8. Select Settings > Service Settings > Service Setup from the left-hand tree
9. Un-check the box for Install SIN Service
10. Check the box for Install CID Service
11. Click Install
12. Click Cancel 

DBINIT Creation (Optional)

In cases where the default database password is not used, a DBINIT file must be created in order for Visual Casino to access the application. This file can also be used to speed up configuration of new desktop clients. The DBINIT file is encrypted so that it cannot be easily read outside the Visual Casino application.

1. On the login page, select Create DB Init File
2. in Server, enter the MachineName\InstanceName for the database server
3. In Database, enter VisualCasino
4. In Username, enter VisualCasino
5. In Password, enter the password created for the VisualCasino user (default is VisualCasino)
6. Re-enter the Password in the Confirm Password field
7. Click Save
8. enter a name for the file (e.g. mydatabase.dbinit) and save it
9. Close the DB Init. File Editor window using the X in the top right corner

This file is saved in the folder C:\ProgramData\VisualCasino6\ and can be copied to this folder on new installations. The file will be automatically detected by Visual Casino.

Desktop Client Installation

Windows User Requirements | Quick Installation 

Windows User Requirements

In order to install the application, you must have permission to add and remove programs from the workstation.

Quick Installation

1. Download the installer from: https://www.biometrica.com/download/visual-casino-7-windows-installer/
2. Run the installer
3. Set the Server field to point to the Machine Name\InstanceName for the Database installed in the previous section. NOTE: If a password other than the default password was used, you will need to create a DBINIT file - see the DBINIT Creation sub-section in the Polling Service Installation and Initial Setup section for this process.
4. Log in to the application.

If you experience issues installing Visual Casino 7 on a machine, please consult our troubleshooting section at: https://support.biometrica.com/hc/en-us/articles/1500001441141-Troubleshooting-Installation-Errors