SLG – SIMS SQL2008 post migration tasks for SLG Schools

After succesfully migrating to SQL2008 a school using SLG hosted by Scomis needs to carry out the following steps…

Process Summary (only carry out these changes after succesfully migrating a school to SQL2008)

• Change School SQL2005 instance tcp port to 32440
• Change School SQL2008 instance tcp port to 32441
• Change School SQL2008 instance configuration to force SSL encryption
  • Restart SQL2005 and SQL2008 services to apply changes
• Create a new External Access Account in the SIMS db for SLG
• Update ADPS Client IIS site on school server with new credentials
• Update ConnectionSettings.xml in school SQL Binn folder with new credentials
  • Copy ConnectionSettings.xml, ADPScheduledProcesses.exe into the SQL2008 Binn folder (and ConnectionSettings.bat or ADPScheduledProcesses.bat if they exist)
• Update the Scheduled Task to point provisioning task to the new ADPScheduledProcesses.exe location
• Update ADPS Client IIS site on school server with new credentials
• Update School Connection details in SLG Sharepoint portal

Process Detail (only carry out these changes after succesfully migrating a school to SQL2008) – These steps are carried out on the school sims server unless specified otherwise…

• Change School SQL2005 instance tcp port to 32440
• Launch the SQL2005 “SQL Server Configuration Management” utility: Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > “SQL Server Configuration Manager”
• Expand “SQL Server 2005 Network Configuration”
• Select “Protocols for SIMS2005”
• Double Click onto “TCP/IP” to open the Properties
• Click onto “IP Addresses”
• Under “IPALL” change the “TCP Port” to “32440”
• Click “OK” to save changes and once again if a warning pops up
• Change School SQL2008 instance tcp port to 32441
• In the same utility Select “Protocols for SIMS2008”
• Double Click onto “TCP/IP” to open the Properties
• Click onto “IP Addresses”
• Under “IPALL” change the “TCP Port” to “32441”
• Click “OK” to save changes and once again if a warning pops up
• Change School SQL2008 instance configuration to force SSL encryption
• In the same utility right click onto “Protocols for SIMS2008” and select “Properties”
• Change “Force Encryption to “Yes”
• Click “OK” to save changes and once again if a warning pops up
• Restart SQL2005 and SQL2008 services to apply changes
• In the same utility click onto “SQL Server Services”
• Right click on “SQL Server (SIMS2005) and choose “Restart”
• Right click on “SQL Server (SIMS2008) and choose “Restart”
• Create a new External Access Account in the SIMS db for SLG
• Launch SIMSExternalAccessAccount.exe (elevate if necessary due to UAC)
• Download and extract from this zip if necessary: http://attix.scomis.org/files/slg/SLGClientSide.zip
• Enter the server name, e.g. ADMINSERVER\SIMS2008
• Leave “Windows Authentication” selected and click “Next”
• Choose the SIMS database from the drop down list and click “Next”
• Leave “Create a new external access account” selected and click “Next”
• Enter a user name made up like SLG{SchoolPrefix}ADP2, e.g. SLGCCCADP2 and click “Next”
• Example above would fit Cullompton Community College, convention of this username doesn’t matter to much so long as it is just alphanumeric
• Make a note of the new username and password
• Note: you can copy the password field and test this user by logging into the SIMS client if you are unsure of 0, o , O, etc.
• Update ADPS Client IIS site on school server with new credentials
• Launch IIS Manager: Start > All Programs > Administrative Tools > “Internet Information Services (IIS) Manager”
• Expand the IIS Server, e.g. %computername% Then Expand “Web Sites”
• Right click onto the ADP Client site normally called “SIMS-ADP-SIMS” and choose “Properties”
• Click onto the “ASP.NET” tab and click “Edit Configuration”
• Note: Don’t click “Edit Global Configuration”
• Select the “SimsDb” configuration string and click “Edit”
• Update the UID detail with your new user, e.g. SLGCCCADP2
• Update with PWD detail with your new user credentials
• Update the SERVER detail to reflect the new instance name, e.g. SERVER=ADMINSERVER\SIMS2008
• Click “OK”, “OK” & “OK” again to save the changes then close the IIS manager
• Update ConnectionSettings.xml in school SQL Binn folder with new credentials
• Open notepad (elevated if required) and open a file
• Browse to the “C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn” folder
• Select ConnectionSettings.xml to edit and click “OK”
• Update the ServerName to reflect the new SQL Instance, e.g. SIMS2008
• Update the “Username” and “Password” to reflect your new user credentials
• Close notepad and save the changes
• Copy ConnectionSettings.xml, ADPScheduledProcesses.exe into the SQL2008 Binn folder (and ConnectionSettings.bat or ADPScheduledProcesses.bat if they exist)
• Copy the following files; ConnectionSettings.xml, ADPScheduledProcesses.exe, ConnectionSettings.bat (if it exists) & ADPScheduledProcesses.bat (if it exists) from the SIMS2005 Binn folder e.g. “C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn” into the SIMS2008 Binn folder e.g. “C:\Program Files\Microsoft SQL Server\MSSQL10.SIMS2008\MSSQL\Binn”
• Update the Scheduled Task to point provisioning task to the new ADPScheduledProcesses.exe location
• There will be a scheduled task for SLG ADP Provisioning on the server that needs to be changed to correct the location of the ADPScheduledProcesses.exe
• You may need to reset the password for the user assigned to this task so that it can be updated
• Note: in some configurations the same user is set for the SIMS backup scheduled task so make sure both are updated if the password is changed
• Note: If your scheduled task was pointing to a batch file check this to make sure it doesn’t have any paths which need updating
• Update School Connection details in SLG Sharepoint portal
• Log a call with the Service Desk to advise us of the username and password for your new external access account
• Advise us that you have migrated SIMS to SQL 2008 and are on SLG following the steps in this FAQ http://faq.scomis.org/kb1868
• We need to update your connection details following http://faq.scomis.org/kb1909