When I am performing database maintenance, how do I disable logins so that a user (s) cannot log in while the maintenance is being performed?
*This post is locked for comments
When I am performing database maintenance, how do I disable logins so that a user (s) cannot log in while the maintenance is being performed?
*This post is locked for comments
Beat, I am the SA and IT Analyst and I don't want others doing maintenance. I have front end and back end experience with GP ....other employees do not. I am playing it safe..
Hi Pamela,
I've read that you start recently with Duke University in an other post... Can I make you a suggestion : buy the Dynamics GP Toolbox from Rockton Software, this will tremendously help in your daily work. It also contains a function to 'put' the system in Maintenance mode, but allows you to choose other users aside of 'sa' to be able to do the maintenance in GP... It's not very expensive and you will not regret it.
The problem with most functions in PSTL is that they can only be used with 'sa' and only be executed if you're the only user in the system (which can make sense for some activities, but not all at my opinion).
Good luck.
It does hide the company from the login screen. When I tested using PSTL Database Disabler,I logged in using a "test" id that I had set up. The test database didn't show as an option. I think "SA" is the only user that can log in. It happens instantly...When I wanted to enable logins for the test company, I just "unchecked" the test company from the PSTL D/B Disabler and was able to see the test company when I tried to log in..
Hi Richard,
That is a great question.
According to the PSTL manual:
"This tool allows the “sa” user to disable any company database. Once the database is disabled, the company option is removed from the Microsoft Dynamics GP log in window. The company database can easily be reactivated."
So this sounds to me like it is "hiding" the company from the login screen. How this is done technically, I am not sure. Perhaps if someone reading this knows the answer, they could chime in on this.
The nice thing about this tool is that you can use it quickly, on one company at a time.
Victoria, if you do not mind me asking what exactly does the PSTL do to disable the databases?
Pamela,
Great! I think now that the PSTL is free, this really makes sense.
I tested this with PSTL (Database Disabler) and liked this option better...Thanks!
You have to build the script for each user to disable them and then again to enable them. How many users are we talking about here?
SELECT name
FROM sys.server_principals
where type ='S' and is_disabled = 0
You could use this statement to help build a larger script if you have many users.
Richard, that worked for 1 user...is that a SQL statement that will disable all users or do I have to set this up for all users 1 time and then execute the statement when I am performing maintenance?
Leslie, I just installed PSTL last month (after GPUG!!) so I will check out the database disabler tool
You could use the Database Disabler tool in the PSTL (Professional Services Tools Library). It is free if you have GP 10.0 or 2010.
André Arnaud de Cal...
292,863
Super User 2025 Season 1
Martin Dráb
231,723
Most Valuable Professional
nmaenpaa
101,156
Moderator