Upgrading - SME 7.1 to 7.2 - Revision history

Marko at 15:47, 9 November 2012

2012-11-09T15:47:53Z

Marko at 15:47, 9 November 2012

2012-11-09T15:47:12Z

MarkO at 17:13, 14 August 2012

2012-08-14T17:13:29Z

MarkO at 17:12, 14 August 2012

2012-08-14T17:12:37Z

Amy at 16:55, 14 August 2012

2012-08-14T16:55:39Z

Amy at 16:54, 14 August 2012

2012-08-14T16:54:08Z

Show changes

Amy at 15:21, 27 October 2011

2011-10-27T15:21:57Z

Amy at 15:21, 27 October 2011

2011-10-27T15:21:26Z

Amy at 15:20, 27 October 2011

2011-10-27T15:20:46Z

Amy: Created page with "The Upgrade executable is available from the following download link. Download it and save it to your SME5 program folder. [ http://high5software.com/downloads/sme72/SME5andSQLi..."

2011-10-27T15:20:31Z

Created page with "The Upgrade executable is available from the following download link. Download it and save it to your SME5 program folder. [ http://high5software.com/downloads/sme72/SME5andSQLi..."

New page

The Upgrade executable is available from the following download link. Download it and save it to your SME5 program folder.

[ http://high5software.com/downloads/sme72/SME5andSQLinkSetupUpdater.exe ]

SME 7.1 uses the Common Language Runtime or ‘clr’ for business logic processing. The ‘clr’ must be enabled on the server instance hosting the SME database prior to launching the update.

# Open MS SQL Management Studio and run the following queries:

* To check if ‘clr’ is enabled – if not enabled proceed to step b

SELECT name,description, value_in_use

FROM sys.configurations

WHERE name = 'clr enabled'

'''and value_in_use = 1'''

* If the ‘clr’ is enabled you will see the following in the results window:

[[File:ResultsWindow.png]]
c. If you do not see the above message ‘clr’ is not enabled and you will need to run the following query:

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'clr enabled', 1;

GO

RECONFIGURE;

GO

<br>2. Close Management Studio

<br>3. SME requires exclusive access to the database while performing the update. To ensure that the database is available for exclusive access run the following SQL query:

USE master;

GO

ALTER DATABASE dbName

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE;

GO

ALTER DATABASE dbName

SET MULTI_USER;

GO

<br>4. Close Management Studio

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

'''Installing the SME 7.1 update'''

* Log onto the server or computer hosting the SME database.
* Log all users out of SME 7.0.
* Close SQLink if used.
* Do Start> Run> fsmgmt.msc to check open files - all SME files must be closed.
* You can skip the stop service steps if you can reboot your server.
* Do Start> Programs> Microsoft SQL Server 2005/2008> Configuration Tools> SQL Configuration Manger
* Stop the MSSQL service and the SQL Server FullTextSearch Services.
* Your MS SQL Server instance name may be different.
* Copy your database folder to a back up location.
* Restart the ‘SQL Server’ and the ‘SQL Server FullTextSearch’ services.
* Download the ‘SME_SQLinkUpdater.exe’ from the following link.
* [http://high5software.com/downloads/sme71/SMESQLinkUpdater.exe http://high5software.com/downloads/sme71/SMESQLinkUpdater.exe]
* Launch the SME_SQLinkUpdater.exe by double clicking or right clicking and selecting ‘Open’.
** Accept the license agreement and click '''Next'''
** Browse to the location of your SME/High5Software folder and click Next.
**[[File:BrowseToLocation.png]]
**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.
**Click '''Yes''' to the message.
**Select the Components to be installed:
**[[File:SelectComponents.png]]
**Click the check boxes if you want to create the desktop and Quick Launch icons. This is not necessary for most updates.
**Click '''Next'''
**Review the following installation information. Make sure that the install path is to your SME 5 program folder.
**[[File:ReadyToInstall.png]]
**Click '''Install''' if everything is correct. The update will install.
**You will see the following indicating that the installer has completed.
**[[File:Finish.png]]
**Click '''Finish'''.

'''Applying the Update:'''

*SME will launch and will open with the following message.</span>
[[File:UpdateMessage.png]]
* You will be prompted for an Update password: '''verify630'''
* Answer '''Yes'''
* SME will install the ‘clr’ routines library
* [[File:RebuildingLibrary(1).png]]
* When the routines library is installed you will be prompted to apply the update. Click Yes
* You will be prompted to back up SME.
* [[File:BackupWarning.png]]
* Click '''Yes''' to backup and SME will back up the database.
* SME will once again rebuild the library and begin to update.
* When the database processing is completes click '''Done'''
* The SME will update the tables.
* You will be notified that updates are to be preformed to your data.
* [[File:INformationwindow.png]]
* Answer Ok to the prompt.
* SME will begin processing the data:
* [[File:UpdatingProcessingContacts.png]]
* SME will perform the updates. This can take a considerable length of time with large data files.
* Update will be completed when you see the following message
* [[File:UpdatesAreApplied.png]]
* Click '''OK'''
* Users can begin using SME 7.1.

@@ Line 78: / Line 78: @@
 <br>
 <br>
-<h3>Notes: To obtain exclusive access
+<h3>Notes: To obtain exclusive access</h3>
 <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.

@@ Line 76: / Line 76: @@
 <br>http://high5software.com/downloads/QB/QBFC11_0Installer.exe
 <br>This installer must be run on all client computers where SQLink is running
-<br>Notes: To obtain exclusive access
+<br>
 <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.

@@ Line 30: / Line 30: @@
 <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. 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>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.

@@ Line 30: / Line 30: @@
 <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.
+<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. 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.
@@ Line 77: / Line 77: @@
 <br>This installer must be run on all client computers where SQLink is running
 <br>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 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>-  Alternate method is to run the following query in MS SQL Management Studio
-<br> -          Open Management Studio
+<br> -          Open Management Studio
-<br> -          New Query
+<br> -          New Query
-<br> -          Paste the following into management Studio
+<br> -          Paste the following into management Studio
 <br>USE master;
@@ Line 94: / Line 94: @@
 <br>GO
-<br>-          Type your database name between the brackets [mydatabase]
+<br>-          Type your database name between the brackets [mydatabase]
-<br> -          Click the Execute query button
+<br> -          Click the Execute query button
-<br> -          Close Management Studio
+<br> -          Close Management Studio
-<br>-          Proceed with the update
+<br>-          Proceed with the update

@@ Line 37: / Line 37: @@
 <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> Click '''Next'''
+<br>19. Click '''Next'''
-<br>Review the following installation information. Make sure that the install path is to your SME 5 program folder.
+<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> Click '''Install''' if everything is correct.
+<br>21. Click '''Install''' if everything is correct.
 <br>[[File:Installing.png]]
-<br> The update will install. You will see the following indicating that the installer has completed.
+<br>22. The update will install. You will see the following indicating that the installer has completed.
 <br>[[File:Finish.png]]
-<br>Click '''Finish'''
+<br>23. Click '''Finish'''
@@ Line 50: / Line 50: @@
 SME will launch and will open with the following message.
 <br>[[File:UpdateMessage.png]]
-<br> Click '''Yes'''.
+<br>Click '''Yes'''.
 <br>You will be prompted for the Update Password. Enter '''verify630''' and click OK
 <br>[[File:EnterPasswordVerify.png]]

← Older revision		Revision as of 15:21, 27 October 2011
Line 71:		Line 71:


−	'''Installing the SME 7.1 update'''	+	'''Installing the SME 7.2 update'''

	* Log onto the server or computer hosting the SME database.		* Log onto the server or computer hosting the SME database.

@@ Line 3: / Line 3: @@
 http://high5software.com/downloads/sme72/SME5andSQLinkSetupUpdater.exe
-SME 7.1 uses the Common Language Runtime or ‘clr’ for business logic processing. The ‘clr’ must be enabled on the server instance hosting the SME database prior to launching the update.
+SME 7.2 uses the Common Language Runtime or ‘clr’ for business logic processing. The ‘clr’ must be enabled on the server instance hosting the SME database prior to launching the update.
@@ Line 126: / Line 126: @@
 *    [[File:UpdatesAreApplied.png]]
 *    Click '''OK'''
-*    Users can begin using SME 7.1.
+*    Users can begin using SME 7.2.

@@ Line 1: / Line 1: @@
 The Upgrade executable is available from the following download link. Download it and save it to your SME5 program folder.
-[ http://high5software.com/downloads/sme72/SME5andSQLinkSetupUpdater.exe ]
+http://high5software.com/downloads/sme72/SME5andSQLinkSetupUpdater.exe
 SME 7.1 uses the Common Language Runtime or ‘clr’ for business logic processing. The ‘clr’ must be enabled on the server instance hosting the SME database prior to launching the update.