Database Installation

Windows User Requirements | SQL Server Requitements | 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 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://visualcasino.net/download/visual-casino-mssql-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]\visual-casino-database.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/en-us/article_attachments/32767692394903/setup-sqlexpress.sql 

 

Detailed Installation

  1. On your SQL server, download the database from https://visualcasino.net/download/visual-casino-mssql-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]\visual-casino-database.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'