Editing Upgrading - SME 7.1 to 7.2

The Upgrade executable is available from the following download link. Download it and save it to your SME5 program folder.
<br>http://high5software.com/downloads/sme72/SME5andSQLinkSetupUpdater.exe 

<br>1. Go to your server or computer hosting the SME database. If you have a Data Server the update must be run from the Data Server and is launched from the Application Server
<br>2. Browse to your SME executable folder
<br>3. Test if all users are out of SME by attempting to temporarily renaming the sme5.exe to sme5.exe.old
<br>--If you cannot rename it all users are not out of SME and the update will fail
<br>--Once you can rename the executable – rename it back to sme5.exe 
<br>--SME must have Exclusive access to the database - see notes below

<br>Should you require assistance High 5Software is available to assist with your MS SQL configuration. 

<h3>Installing the SME 7.2 update</h3>
<br>1. Log onto the server or computer hosting the SME database.
<br>2. Log all users out of SME 7.1.
<br>3. Close SQLink if used.
<br>4. Do '''Start'''> '''Run'''> '''fsmgmt.msc''' to check open files - all SME files must be closed.
<br>5. You can skip the stop service steps if you can reboot your server.
<br>6. Do '''Start'''> '''Programs'''> '''Microsoft SQL Server 2005/2008'''>''' Configuration Tools'''> '''SQL Configuration Manger'''
<br>7. Stop the MSSQL service and the SQL Server FullTextSearch Services.
<br>[[File:STopMSSQL.png]]
<br>8. Your MS SQL Server instance name may be different.
<br>9. Copy your database folder to a back up location.
<br>10. Restart the ‘SQL Server’ and the ‘SQL Server FullTextSearch’ services.
<br>11. Download the ‘SME_SQLinkUpdater.exe’ from the following link.
<br>http://high5software.com/downloads/sme72/SME5andSQLinkSetupUpdater.exe    
<br>12. Launch the SME_SQLinkUpdater.exe by double clicking or right clicking and selecting '''Open'''.
<br>13. Accept the license agreement and click '''Next'''
<br>[[File:LicensingAgreementUpdate.png]]
<br>14. Browse to the location of your SME/High5Software folder and click '''Next'''.
<br>[[File:BrowseToLocation.png]]
<br>15. You should see the following message. If you ‘Do Not’ see this message click the '''Back''' button and check your path. It '''MUST''' be the same as your SME/High5Software path. Your installation folder may be in a different location. You can locate the location by right clicking on your SME 5 shortcut and selecting either ‘Find Target’ or ‘Open File Location’
<br>[[File:FolderExists.png]]
<br>16. Answer ‘Yes’ to the message.
<br>17. Select the Components to be installed:
<br>[[File:SelectComponents.png]]
<br>18. Click the check boxes if you want to create the desktop and Quick Launch icons. This is not necessary for most updates.
<br>[[File:SelectAdditionalTasks.png]]
<br>19. Click '''Next'''
<br>20. Review the following installation information. Make sure that the install path is to your SME 5 program folder.
<br>[[File:ReadyToInstall.png]]
<br>21. Click '''Install''' if everything is correct.
<br>[[File:Installing.png]]
<br>22. The update will install. You will see the following indicating that the installer has completed.
<br>[[File:Finish.png]]
<br>23. Click '''Finish'''


<h3>Applying the Update</h3>
SME will launch and will open with the following message.
<br>[[File:UpdateMessage.png]]
<br>Click '''Yes'''. 
<br>You will be prompted for the Update Password. Enter '''verify630''' and click OK
<br>[[File:EnterPasswordVerify.png]]
<br>You will be prompted to back up SME. 
<br>[[File:BackupWarning.png]]
<br> Click '''Yes''' to backup and SME will back up the database
<br>[[File:RunningbackupQuery.png]]
<br>SME will rebuild the library and begin to update.
<br>[[File:ProcessingDefaults.png]]
<br>When the database processing is completes click '''Done'''
<br>[[File:FinishedBackingUp.png]]
<br>The SME will update the tables. You will be notified that updates are to be preformed to your data.
<br>[[File:INformationwindow.png]]
<br> Answer ‘Ok’ to the prompt.
<br>SME will begin processing the data. You will see various info windows:
<br>[[File:VariousUpdateWindows.png]]
<br> SME will perform the updates. This can take a considerable length of time with large data files.
<br>Update will be completed when you see the following message:
<br>[[File:UpdatesAreApplied.png]]
<br> Click '''Ok'''. Users can begin using SME 7.2.

<h3>Updating SQLink QBFC program </h3>
<br>If you are using SQLink you will need to update the Intuit QBFC program 
<br>Download the latest QBFC program from the following link
<br>http://high5software.com/downloads/QB/QBFC11_0Installer.exe
<br>This installer must be run on all client computers where SQLink is running
<br>
<br>
<h3>Notes: To obtain exclusive access
<br> -  The easiest method is to attempt to rename the SME executable sme5.exe to sme5.old.exe if you cannot rename someone is still in SME.
<br>-  The second most reliable way is to reboot the server. This will force all connections to the database to be closed. 
<br>-  Alternate method is to run the following query in MS SQL Management Studio
<br> -          Open Management Studio
<br> -          New Query
<br> -          Paste the following into management Studio

<br>USE master;
<br>GO
<br>ALTER DATABASE [dbname]
<br>SET SINGLE_USER
<br>WITH ROLLBACK IMMEDIATE;
<br>GO
<br>ALTER DATABASE [dbname]
<br>SET MULTI_USER;
<br>GO

<br>-          Type your database name between the brackets [mydatabase]
<br> -          Click the Execute query button
<br> -          Close Management Studio 
<br>-          Proceed with the update