Exclusive Access - Revision history

Amy at 16:40, 13 September 2012

2012-09-13T16:40:21Z

Amy at 16:40, 13 September 2012

2012-09-13T16:40:07Z

Amy at 16:17, 13 September 2012

2012-09-13T16:17:41Z

Amy at 16:16, 13 September 2012

2012-09-13T16:16:37Z

Amy: Created page with "SME must have 'Exclusive Access' to apply updates. There are various methods to make sure there are no users logged into the database.
'''1)''' The easiest method is to che..."

2012-09-13T16:15:14Z

Created page with "SME must have 'Exclusive Access' to apply updates. There are various methods to make sure there are no users logged into the database. '''1)''' The easiest method is to che..."

New page

SME must have 'Exclusive Access' to apply updates. There are various methods to make sure there are no users logged into the database.

 '''1)''' The easiest method is to check if you can rename the sme5.exe executable. If you can then all users are out of the program.
 a. Highlight the sme5.exe and rename to sme5.1.exe - if you can rename then rename it back to sme5.exe
 b. http://goview.com/?id=0e6f8e6f-f6b0-4bb3-b5ab-34f359f5227f
 c. Proceed with the update using the instructions at this wiki link: http://high5software.com/mediawiki/index.php?title=Updating_SME_7.2

 '''2)''' Another method is to reboot the computer or server hosting the SME database. However this is not always an option as other business critical programs and processes may be running on the system.
 a. Log all users out of SME
 b. Reboot the computer or server hosting SME
 c. Proceed with the update using the instructions at this wiki link: http://high5software.com/mediawiki/index.php?title=Updating_SME_7.2

 '''3)''' Checking using the Control Panel Shared folders MS Management Console Snap in.
 a. Log all users out of SME
 b. Go to the '''Star'''t button> '''Run''' (on Windows 7 use the Search field) type 'fsmgmt.msc'. This will open the Shared Folders utility
 c. Click on '''Open Files''' and look for SME files that are open. All files related to SME must be closed.
 e. All files highlighted in blue must be closed - right click on the files and select '''Close Open File'''.
 g. Answer '''Yes''' to this prompt
 h. http://goview.com/?id=da121b49-c9f3-4d6a-8318-9adda2144ed2

 '''4)''' Checking using MS SQL Management Studio - open Microsoft Management Studio
 a. Paste the query provided below into the query window and Execute the query
 b. Change the <dbname> to your database name
 c. http://goview.com/?id=29be0448-ca0f-48b6-b9e5-f5a8815a8464
 d. Proceed with the update using the instructions at this wiki link: http://high5software.com/mediawiki/index.php?title=Updating_SME_7.2

@@ Line 21: / Line 21: @@
 <br>'''4)'''	Checking using MS SQL Management Studio - open Microsoft Management Studio
 <br>a.	Paste the query provided below into the query window and Execute the query
 <br>USE master;
 <br>GO
@@ Line 30: / Line 31: @@
 <br>SET MULTI_USER;
 <br>GO
 <br>b.	Change the <dbname> to your database name
 <br>Demo Video Link: http://goview.com/?id=29be0448-ca0f-48b6-b9e5-f5a8815a8464
 <br>c.	Proceed with the update using the instructions at this wiki link: http://high5software.com/mediawiki/index.php?title=Updating_SME_7.2

@@ Line 21: / Line 21: @@
 <br>'''4)'''	Checking using MS SQL Management Studio - open Microsoft Management Studio
 <br>a.	Paste the query provided below into the query window and Execute the query
 <br>b.	Change the <dbname> to your database name
 <br>Demo Video Link: http://goview.com/?id=29be0448-ca0f-48b6-b9e5-f5a8815a8464
 <br>c.	Proceed with the update using the instructions at this wiki link: http://high5software.com/mediawiki/index.php?title=Updating_SME_7.2

@@ Line 3: / Line 3: @@
 <br>'''1)'''	The easiest method is to check if you can rename the sme5.exe executable. If you can then all users are out of the program.
 <br>a.	Highlight the sme5.exe and rename to sme5.1.exe - if you can rename then rename it back to sme5.exe as shown in the video linked below.
-<br>http://goview.com/?id=0e6f8e6f-f6b0-4bb3-b5ab-34f359f5227f
+<br>Demo Video Link: http://goview.com/?id=0e6f8e6f-f6b0-4bb3-b5ab-34f359f5227f
-<br>c.	Proceed with the update using the instructions at this wiki link: http://high5software.com/mediawiki/index.php?title=Updating_SME_7.2
+<br>b.	Proceed with the update using the instructions at this wiki link: http://high5software.com/mediawiki/index.php?title=Updating_SME_7.2
 <br>'''2)'''	Another method is to reboot the computer or server hosting the SME database. However this is not always an option as other business critical programs and processes may be running on the system.
@@ Line 17: / Line 17: @@
 <br>e.	All files highlighted in blue must be closed - right click on the files and select '''Close Open File'''.
 <br>g.	Answer '''Yes''' to this prompt
-<br>h.	http://goview.com/?id=da121b49-c9f3-4d6a-8318-9adda2144ed2
+<br>Demo Video Link: http://goview.com/?id=da121b49-c9f3-4d6a-8318-9adda2144ed2
 <br>'''4)'''	Checking using MS SQL Management Studio - open Microsoft Management Studio
 <br>a.	Paste the query provided below into the query window and Execute the query
 <br>b.	Change the <dbname> to your database name
-<br>c.	http://goview.com/?id=29be0448-ca0f-48b6-b9e5-f5a8815a8464
+<br>Demo Video Link: http://goview.com/?id=29be0448-ca0f-48b6-b9e5-f5a8815a8464
-<br>d.	Proceed with the update using the instructions at this wiki link: http://high5software.com/mediawiki/index.php?title=Updating_SME_7.2
+<br>c.	Proceed with the update using the instructions at this wiki link: http://high5software.com/mediawiki/index.php?title=Updating_SME_7.2

@@ Line 2: / Line 2: @@
 <br>'''1)'''	The easiest method is to check if you can rename the sme5.exe executable. If you can then all users are out of the program.
-<br>a.	Highlight the sme5.exe and rename to sme5.1.exe - if you can rename then rename it back to sme5.exe
+<br>a.	Highlight the sme5.exe and rename to sme5.1.exe - if you can rename then rename it back to sme5.exe as shown in the video linked below.
-<br>b.	http://goview.com/?id=0e6f8e6f-f6b0-4bb3-b5ab-34f359f5227f
+<br>http://goview.com/?id=0e6f8e6f-f6b0-4bb3-b5ab-34f359f5227f
 <br>c.	Proceed with the update using the instructions at this wiki link: http://high5software.com/mediawiki/index.php?title=Updating_SME_7.2

Exclusive Access - Revision history

Amy at 16:40, 13 September 2012

Amy at 16:40, 13 September 2012

Amy at 16:17, 13 September 2012

Amy at 16:16, 13 September 2012

Amy: Created page with "SME must have 'Exclusive Access' to apply updates. There are various methods to make sure there are no users logged into the database. '''1)''' The easiest method is to che..."

Amy: Created page with "SME must have 'Exclusive Access' to apply updates. There are various methods to make sure there are no users logged into the database.
'''1)''' The easiest method is to che..."