AJWhite1970 Posted February 3, 2016 Posted February 3, 2016 Morning Quick question on behalf of our new MIS person as I'm not a SIMS admin.... They are entering the new school year for September this afternoon and want to disable all logins from a certain time so that they are the only one accessing SIMS. Apologies if there is a big obvious "disable logins" button they've missed but how would this be actioned? Thanks as always Andrew
Steve21 Posted February 3, 2016 Posted February 3, 2016 How are they planning to login? If they have local server access etc could always stop remote connections, but obviously if they're expecting it from their pc it'd knock theirs off too Steve 1
bobsmith Posted February 3, 2016 Posted February 3, 2016 Our timetablers put the new timetable on the system without the rest of us having to log out. Is there a particular need for the users to be barred from logging in? If we do need everyone off the server we send an all staff email asking them to log out by such and such a time. This is reserved for patches and upgrades, not for routine SIMs tasks. 1
AJWhite1970 Posted February 3, 2016 Author Posted February 3, 2016 Thanks for the replies, I'm just the middle man here!! I suspect they want everyone off just because that's how they thought it should be. I'm going to remove all the desktop icons to SIMS and they will email everyone, hopefully that's enough. Was just asking in-case they've missed anything simple, I was bought up on Netware where "disable logins" was my favourite command... Andrew
bobsmith Posted February 3, 2016 Posted February 3, 2016 depending on how your connect.ini is set up you could just rename it temporarily. But this won't log out users with an open session in SIMS, nor will it stop people accessing the DB vis SLG or any other webaccess interface you're running. 1
deKay Posted February 3, 2016 Posted February 3, 2016 We deny access to the SIMS share on the server - stops SIMS from running. 2
Fazza Posted February 3, 2016 Posted February 3, 2016 We deny access to the SIMS share on the server - stops SIMS from running. That would do it! Good idea that, might use that myself when doing upgrades/updates of the backend and we want to make sure no one tries to access the database whilst we're doing it as it can screw it up sometimes if they do!
Banjo Posted February 3, 2016 Posted February 3, 2016 That would do it! Good idea that, might use that myself when doing upgrades/updates of the backend and we want to make sure no one tries to access the database whilst we're doing it as it can screw it up sometimes if they do! I'm assuming that all local connect.ini files are redirects to the .ini on the shared folder? You will need to stop/start SQL to boot the exisiting users off the system, and swap over the workstation you want to use SIMS to a drirect connect.ini to the SQL instance. 1
DarkMaster Posted February 3, 2016 Posted February 3, 2016 this is what i do to stop users from accessing sims on workstations but it will work on the server - Click Start. - All Programs. - Microsoft SQL Server 2008/2012/2014 - Configuration Tools. - SQL Server Configuration Manager. - Expand the SQL Server Network Configuration option. - Select the correct instance name (I.e. Protocols for SQL2008) - Double click Named Pipes - Change enabled to 'No' - Click Apply and OK. - Click OK to the message. - Double click TCP/IP. - Change enabled to 'No' - Click Apply and OK. - Click OK to the message. The SQL Service will now need to be restarted. This can be done via the following: - Click Start. - Click Run and enter the following command 'services.msc' - This will open the Microsoft Services Menu. - Locate the SQL Server 2008/2012/2014 service. - Select the Stop this service option. - Once complete, select the Start this service option. This will stop the Users from connecting to the Server outside of the actual box, please now run the specified application as required. When complete, please do the following: - Click Start. - All Programs. - Microsoft SQL Server 2008/2012/2014. - Configuration Tools. - SQL Server Configuration Manager. - Expand the SQL Server Network Configuration option. - Select the correct instance name (I.e. Protocols for SQL2008) - Double click Named Pipes - Change enabled to 'Yes' - Click Apply and OK. - Click OK to the message. - Double click TCP/IP. - Change enabled to 'Yes' - Click Apply and OK. - Click OK to the message. The SQL Service will now need to be restarted. This can be done via the following: - Click Start. - Click Run and enter the following command 'services.msc' - This will open the Microsoft Services Menu. - Locate the SQL Server 2008/2012/2014 service. - Select the Stop this service option. - Once complete, select the Start this service option. 2
Banjo Posted February 3, 2016 Posted February 3, 2016 You'll need Office on the server for this to work fully.
AJWhite1970 Posted February 3, 2016 Author Posted February 3, 2016 Thanks to everyone who answered, a combination of AB Tutor Control blocking the exe, removing the shortcut from the shared desktop and renaming the share did the trick
PhilNeal Posted February 3, 2016 Posted February 3, 2016 (edited) I'm pretty sure that if it was necessary to disable access in writing back we would have included it in the software! Edited February 3, 2016 by PhilNeal
Cache Posted February 4, 2016 Posted February 4, 2016 They probably wanted everyone out because the SIMS guide says this: The process of creating a new academic year is very demanding on the SQL server and should be carried out when a minimal number of users are accessing SIMS, ideally when no users are logged on. 1
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now