To move a existing intranet to a new server you'll need to do a new installation on the new server, then copy the file system and the database in from the original server.
Assistance with migrating your intranet to a new server is available as a professional service from our Support team.
Please make sure to take web server backup/snapshot and database backup before making any changes.
Install Intranet Connections on the New Server
Setup the new server and complete the installation as per the Intranet Connections Installation Guide article.
- The version installed should match the version running on the original server
- Do not configure this new intranet
Copy the Files From the Original Server to the New Server
- Stop Lucee, ElasticSearch, SQBoxTaskManager and World Wide Web Publishing services on the new server
- Copy the Intranet folder on the new server as a backup
- Overwrite the contents of the default Intranet directory on the new server with the contents of the Production Intranet directory on the new server.
- Start World Wide Web Publishing, SQBoxTaskManager, ElasticSearch and Lucee services on the new server
Copy the Original SQL Database to the New SQL Database
After the installation on the new server is complete, there will be an IntranetConnections database and (on version 14.0+) an SQBoxStatistics database. Backup of the original database(s) will need to be taken and restored over the new database(s).
Learn how to move existing database content to a new database.
Update Mapping
- Click Mappings under Archives & Resources.
- Confirm or Create the intranet mappings with the following details:
- Virtual:
- /Intranet (if you have /intranet in your URL)
- / (if you do not have /intranet in your URL)
- Resource: C:\sqbox\webroot\intranet or C:\inetpub\wwwroot\intranet (or the location of your Intranet folder, if different)
- Archive: C:\sqbox\webroot\intranet\IntranetConnections.ras or C:\inetpub\wwwroot\intranet\IntranetConnections.ras (or the location of the IntranetConnections.ras file, if different)
- Virtual:
Additional Steps Required
The following steps show how to update the connectionStrings files responsible for the Toolbar, Storyboard, and Statistics to work.
- Version 14.0+ - Repeat the above process for the SQBoxStatistics database
- Update the "connectionStrings" config files in the following locations to reflect the new SQL Server name:
- Statistics - C:\sqbox\webroot\statistics or C:\inetpub\wwwroot\statistics
- Modern - C:\sqbox\webroot\modern or C:\inetpub\wwwroot\statistics.
- ICSearch - C:\sqbox\webroot\icsearch or C:\inetpub\wwwroot\icsearch
- Update Datasource - See instructions below
- Detach or decommission the database from previous server
- Confirm the intranet loads
Final Steps
- Restart World Wide Web Publishing and Lucee services (in order)
- Access the intranet site through your browser
- If you log in and get redirected to the an old path, type in your base URL and add this text to go directly to the admin setup page: admin/sitesettings/site_settings.cfm?tabidx=1
For example http://sqintranet.sqbox.com/admin/sitesettings/site_settings.cfm?tabidx=1
- If you log in and get redirected to the an old path, type in your base URL and add this text to go directly to the admin setup page: admin/sitesettings/site_settings.cfm?tabidx=1
- Click on Admin
- Click Update Locations at the bottom of the screen
- Web location should reflect the new server's address (i.e. new DNS)
- Navigate to Admin > Setup tab > Site Search and click Re-Index My Site Data
- Delete the Intranet_Orig folder after confirming you can access your site