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'