If entering a password, note it down for later use when creating the datasource; ensure that you uncheck the ‘Enforce Password Policy’, ‘Enforce Password Expiration’ and ‘User must change password at next login’ options.

In the Database Field from the drop down box choose the database IntranetConnections (contact Support for the default password)

Click on User Mapping

Select the Database(s) IntranetConnections and SQBoxStatistics (only applicable if you're on Version 14.0+) by clicking in the checkbox

Under Database Roles make sure public is checked and db_owner is checked

Click OK to finish creating the login

Moving your old SQL content to the new SQL database

Create a backup of your old production IntranetConnections database. You can do this via SQL Management Studio.

Right click the database name > Tasks (or All tasks) > Backup

Backup the database to a location on Disk

Copy the backup file (filename.bak) from the old server to the new server

Open SQL Management Studio on the new server. Right click on the IntranetConnections database and choose Tasks and then Restore Database.

Go to Options in the top left hand corner and choose ‘Overwrite the existing database’ from the Restore options menu.

Once the restore has completed, open a new query and run the following:

EXEC sp_change_users_login 'auto_fix', 'intranetconnections'

Repeat this process for the SQBoxStatistics database if you're on Version 14.0+.

If your SQL user created in the previous section is not called intranetconnections, replace the occurrence of that name in the query with the appropriate name. This query repairs any orphaned user issues associated with the database transfer.

Once you have moved your old SQL content to the new SQL database, make sure to update the "connectionStrings" config file for statistics and modern (modern folder is only available on version 14.5) to reflect the changes on the new server. Standard location of the config file is C:\sqbox\webroot\statistics or C:\inetpub\wwwroot\statistics, and C:\sqbox\webroot\modern or C:\inetpub\wwwroot\modern.