Difference between revisions of "Exclusive Access"
(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. <br>'''1)''' The easiest method is to che...") |
|||
| (3 intermediate revisions by the same user not shown) | |||
| 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>'''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> | + | <br>Demo Video Link: http://goview.com/?id=0e6f8e6f-f6b0-4bb3-b5ab-34f359f5227f |
| − | <br> | + | <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. | <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>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>g. Answer '''Yes''' to this prompt | ||
| − | <br> | + | <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>'''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>a. Paste the query provided below into the query window and Execute the query | ||
| + | |||
| + | <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>b. Change the <dbname> to your database name | <br>b. Change the <dbname> to your database name | ||
| − | <br> | + | <br>Demo Video Link: http://goview.com/?id=29be0448-ca0f-48b6-b9e5-f5a8815a8464 |
| − | <br> | + | <br>c. Proceed with the update using the instructions at this wiki link: http://high5software.com/mediawiki/index.php?title=Updating_SME_7.2 |
Latest revision as of 16:40, 13 September 2012
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 as shown in the video linked below.
Demo Video Link: http://goview.com/?id=0e6f8e6f-f6b0-4bb3-b5ab-34f359f5227f
b. 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 Start 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
Demo Video Link: 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
USE master;
GO
ALTER DATABASE [<dbname>]
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
ALTER DATABASE [<dbname>]
SET MULTI_USER;
GO
b. Change the <dbname> to your database name
Demo Video Link: http://goview.com/?id=29be0448-ca0f-48b6-b9e5-f5a8815a8464
c. Proceed with the update using the instructions at this wiki link: http://high5software.com/mediawiki/index.php?title=Updating_SME_7.2