Moving SQL and Intranet Connections to a new Server
Your first step is to move your SQL database from the old server to the new server. The following steps will walk you through how to accomplish this. Following the move of SQL, you will then need to bring over the Intranet directory and all of its subfolders and contents to the new server, which is outlined at the end of this document.
- Install and Configure new SQL Server
- Create IntranetConnections database and login on New Server
- Backup existing production database and restore it to the new SQL database
- Install ColdFusion
- Create the SQL data source
Step 1) SQL Server Migration (from one SQL server to another)
- Install and Configure new SQL Server
- Install SQL Server as per the Microsoft installation instructions.
- Only note is to ensure that you have enabled Mixed Authentication (i.e. both SQL and Windows Authentication on the SQL server are enabled).
- Take a backup of your database and copy the .bak file to the new SQL Server (click here for backup instructions)
Step 2) Creating the IntranetConnections SQL Database
- Open SQL Management Studio
- Right click Databases and select New Database…
- In the Database Name field type in IntranetConnections
- You can keep the rest of the default settings as per the screen below
- You should now have a database called IntranetConnections under the Databases heading in the left hand pane
- Create the IntranetConnections Login
- Right Click Logins (under Security) and select New Login…
- In the Name field type in IntranetConnections
- Change the default of Windows NT Authentication to SQL Server Authentication
- Enter a password or leave it blank. If entering a password, please note it down for later use when creating the datasource. If entering a password 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 (see image on next page)
- Now click on the User Mapping page
- Select the Database IntranetConnections by clicking in the checkbox
- Under Database Roles make sure public is checked and db_owner is checked
- Click on OK to finish creating the login
Step 3) Moving your old SQL content to the new SQL IntranetConnections database
- First create a backup of your old production IntranetConnections database. You can do this via the 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 Restore Database.
- Go to Options in the top left hand corner and choose â€˜Overwrite the existing databaseâ€™ from the Restore options menu. Click OK. Click OK again on the main backup screen to run the backup.
- Once the backup has completed, open a new query window pointing to the IntranetConnections database (you can select the database from the drop down). Enter the following into the query and execute it. If your SQL user created in the previous section is not called intranetconnections then replace the occurrence of that name in the query below with the appropriate name. This query repairs any orphaned user issues associated with the database transfer.
EXEC sp_change_users_login 'auto_fix', 'intranetconnections'
Step 4) Install ColdFusion
Before installing ColdFusion, log into your current Production server's ColdFusion admin portal and locate your serial number.
The following image shows where you can locate the serial number within your CF admin:
Choose your version of ColdFusion from the following list:
STOP - Before installing ColdFusion, refer to the know Windows Server requirements:
- Windows Server 2008 can support ColdFusion 8 and 9
- Windows Server 2012 can only support ColdFusion 10+
- IC does not support ColdFusion 11+
Supported Intranet Connections (IC) version
IC 11.5.12 to IC 12.5
Up to IC 12.5
ColdFusion 8.0.1: 32Bit download
(Click here for the CF 8.0.1 update. Please note that you need to be on CF 8.0.0 to apply this update.)
Up to IC 12.5
Up to IC 10.5.131
Up to IC 9.5.173
Step 5) Create Datasource
Creating your IntranetConnections SQL Data source in Cold Fusion.
Now that you have created your IntranetConnections SQL database and the IntranetConnections Login, you need to set up the SQLFunctions data source in the ColdFusion Administrator for your new SQL database.
The following steps will walk you through creating additional data source for SQL.
- Go to the Cold Fusion Administrator through the browser:
- Click on ODBC Data Sources
- Create a new Data source called: SQLFunctions
- Select SQL Server Driver from the drop down list as per the below screen snap
- Enter in the name of your server
- For Database, type in: IntranetConnections
- For Username, type in: IntranetConnections
- Bring over the Intranet directory and all of its subfolders and files to the inetpub/wwwroot of the new server.
- Bring up the intranet site through your browser
- Click on Site Settings / Administrator Info
- Change the drive and path field to point to where you placed the Intranet directory on the new server (if applicable)
Migrating old versions of IC (up to 9.5): Are you encountering a SessionError message when trying to access your site? Click here for instructions on how to correct this issue.