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
Posted in Services, SIMS Learning Gateway, SIMS.net, Technical and tagged , , , , , .