Set Up the Database for Shared Hosting

Applies to All Versions of SmarterTrack

SmarterTools customers using an installed version of the software can run SmarterTrack with any of the following databases:

  • Microsoft SQL Server Express – The automated installer for SmarterTrack includes the option to install SQL Server Express, a free version of Microsoft SQL Server 2005 or later. It is the recommended database on most systems, except for those that have access to the non-Express version of Microsoft SQL Server. It has no connection limits like MSDE does and is much easier to backup and restore. It also supports databases of up to 4 GB in size.
  • Microsoft SQL Server – SQL Server is an enterprise-grade database server available from Microsoft. While most of the functionality is identical to the Express edition, it does not have some of the usage restrictions that the Express edition has (such as the 4 GB database size limit). The primary difference is that you usually will not need to specify an instance name (like \SQLEXPRESS) in the database server field when attaching to the database.
  • MySQL – MySQL is a free database package that competes against Microsoft SQL Server. It also works well with SmarterTrack, but our tests have shown slightly higher performance with Microsoft SQL Server.

Details on setting up SmarterTrack with each database are below:

Microsoft SQL Server Express (Version 2005 or higher)
To create a new database in Microsoft SQL Server Express, follow these steps:

  1. Install SQL Server Express. SmarterTools also recommends downloading and installing Management Studio Express.
  2. Log in to Microsoft SQL Server Express using Management Studio Express.
  3. Create an empty database for SmarterTrack. NOTE: SmarterTools recommends the use of SQL Authentication. To verify that SQL Server is configured for Mixed-Mode Authentication, go to the properties of the SQL Server in Management Studio Express and click on Security. The Server authentication should be SQL Server and Windows Authentication mode. If it is not configured for this, change the setting, and click OK. This will require a restart of the SQL Instance.
  4. Create a user that has Database Owner (DBO) privileges over the new database.

Microsoft SQL Server (Version 2005 or higher)
To create a new database in Microsoft SQL Server, follow these steps:

  1. Log in to Microsoft SQL Server using SQL Management Studio.
  2. Create an empty database for SmarterTrack. NOTE: SmarterTools recommends the use of SQL Authentication. To verify that SQL Server is configured for Mixed-Mode Authentication, go to the properties of the SQL Server in Management Studio Express and click Security. The server authentication should be SQL Server and Windows Authentication mode. If it is not configured for this, change the setting, and click OK. This will require a restart of the SQL instance.
  3. Create a user that has Database Owner (DBO) privileges over the new database.

MySQL (Version 5.1 or higher)
SmarterTools recommends downloading and installing the MySQL GUI tools prior to setting up the database. To create a database in MySQL using the MySQL Administrator GUI, follow these steps:

  1. Log in to MySQL using the MySQL GUI Administrator.
  2. Create an empty schema (database) for SmarterTrack. NOTE: SmarterTrack requires the use of the InnoDB database engine. To check what your default storage is, click on Startup Variables, and on the General Parameters tab check to see what your Default storage is set to. If you are using SmarterTrack 4.x, the database engine is specified during the database initialization.
  3. Create a user that has DBO permissions over the new database.

Connecting the Database to SmarterTrack
The database is connected during the Setup Wizard process. For more information, refer to Running the Setup Wizard in the KB article Install SmarterTrack on a Shared Server.

 

Learn more about SmarterTrack’s helpdesk system, which includes live chat, a self service portal and knowledge base software.

Feedback

Add Feedback
Hi,

The "Set Up the Database for Shared Hosting" documentation page seems incomplete.

1. You identify tools to create a database- good.
2. You say to create a user that has Database Owner (DBO) privileges over the new database, I will use the default (sa) - good.
3. You identify the database should be created in Mixed-Mode Authentication - good.

Okay the SmarterDB is created - awesome.

q-1) Where is the "setup" information that tells me where to place the SmarterDB and how to access it from your application?

I did not see this information in the next step "Installing SmarterTrack on a Shared Server".

Please help me with a pointer or additional information.

Thanks and Happy 4th of July weekend,
Dave

david stemkoski (July 2, 2016 at 1:54 PM)
Hey David, the "Setup" information is presented after the product is installed and you access the web interface for the first time.
Andrea Rogers (July 6, 2016 at 11:46 AM)
Thanks, That got the job done. - Dave
david stemkoski (July 9, 2016 at 10:06 AM)

Add Feedback