UBQ000253:  Configuring Microsoft SQL or MySQL for use with the UltraBac Database

 

Summary:

UltraBac can utilize either Microsoft SQL (Full or Express) or MySQL for the UltraBac Database functions. Each platform requires some changes from the "default" install options to ensure proper installation and operation of the UltraBac Database.

Details:

Microsoft SQL Server / SQL Server Express

NOTE: Installation of an UltraBac Database using Microsoft SQL Server / SQL Server Express will require a disk/partition with a minimum of 15GB of free space on the host.

 

NOTE: The SQL Server "Authentication Mode" will need to be set to "Mixed Mode" if your computers are in multiple domains where the domain containing the computer you are trying to add to UltraBac's Centralized Management does not have a trust relationship to the domain containing the SQL server and UltraBac's index manager server; or if you are trying to add computers that are not joined to a domain.

 

 

Setting "Authentication Mode" During Installation:

 

  1. Perform a default install of Microsoft SQL Server / SQL Server Express until the "Authentication Mode" screen.

  2. Click "Mixed Mode (Windows Authentication and SQL Server Authentication)" radio button.

  3. Enter/confirm the password for the "sa" account.

 

kb253_dialog.jpg

Fig. 1 - SQL Server Setup "Authentication Mode" dialog.

 

  1. Complete the installation with the default settings.

 

Changing "Authentication Mode" of an existing installation:

 

NOTE: The Microsoft SQL Server Management Studio / SQL Server Management Studio Express is required to alter the "Authentication Mode" of an existing installation.

 

  1. Open the SQL Server Management Studio / SQL Server Management Studio Express.

  2. Connect to the SQL Server\Instance to be configured.

  3. Right-click on the SQL Server\Instance, then click "Properties."

  4. Select the "Security" page.

  5. Under "Server authentication" select the "SQL Server and Windows Authentication mode" radio button.

 

kb253_dialog2.jpg

Fig. 2 - SQL Server Management Studio "Authentication Mode" dialog.

 

  1. Expand the "Security" folder, then expand "Logins."

  2. Right-click on "sa" and click "Properties."

  3. In the "General" page, set/confirm a password for the "sa" account.

  4. Click on the "Status" page.

  5. Under "Login:" select "Enabled" then click "OK."

 

Configuring SQL Server / SQL Server Express for remote UltraBac Database clients:

 

  1. Open the SQL Server Configuration Manager.

  2. Expand "SQL Server Network Configuration."

  3. Click on "Protocols for [INSTANCENAME]."

  4. Right-click "TCP/IP" and click "Properties."

  5. Change "Enabled" to "Yes."

  6. Click "OK."

 

kb253_dialog3.jpg

Fig. 3 - SQL Server Configuration Manager "Protocols" dialog.

 

  1. Next, click on the "SQL Server Services."

  2. Right-click on "SQL Server (INSTANCENAME)" then click "Restart."

  3. Right-click on "SQL Server Browser" then click "Properties."

  4. Click on the "Service" tab.

  5. Change the "Start Mode" to "Automatic" then click "Apply."

 

kb253_dialog4.jpg

Fig. 4 - SQL Server Browser "Properties/Service" dialog.

 

  1. Click on the "Log On" tab.

  2. Click "Start" then click "OK."

 

kb253_dialog5.jpg

Fig. 5 - SQL Server Browser "Properties/Log On" dialog.

 

  1. Open the SQL Server Management Studio / SQL Server Management Studio Express.

  2. Connect to the SQL Server\Instance to be configured.

  3. Right-click on the SQL Server\Instance, then click "Properties."

  4. Select the "Connections" page.

  5. If not already selected, check "Allow remote connections to this server", then click "OK."

 

kb253_dialog6.jpg

Fig. 6 - SQL Server Browser "Properties/Log On" dialog.

 

 

 

MySQL Server 5.1

NOTE: The "MySQL Connector/ODBC 5.1" software (a separate download from MySQL) must be installed on each system that will connect to the UltraBac Database.

 

Performing a new installation of MySQL Server:

 

  1. Perform a "Typical" install of MySQL Server, check "Configure the MySQL Server now" then "Finish."

  2. In the MySQL Server Instance Configuration Wizard, click "Next," select "Standard Configuration" then click "Next" again.

  3. Click "Next" to accept the default Windows options.

  4. Enter/confirm the password for the "root" account, and check the "Enable root access from remote machines" check box.

  5. Press "Execute" then "Finish" to complete the MySQL Server Instance Configuration Wizard.

More Information:

See UltraBac User Manual:  UltraBac Database