Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Database Maintenance

(0) ShareShare
ReportReport
Posted on by

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

  • Community Member Profile Picture
    on at
    Re: Database Maintenance

    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..

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    28,058 Moderator on at
    Re: Database Maintenance

    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.

  • Community Member Profile Picture
    on at
    Re: Database Maintenance

    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..

  • Victoria Yudin Profile Picture
    22,766 on at
    Re: Database Maintenance

    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.  

  • Richard Wheeler Profile Picture
    75,796 Moderator on at
    Re: Database Maintenance

    Victoria, if you do not mind me asking what exactly does the PSTL do to disable the databases?

  • Victoria Yudin Profile Picture
    22,766 on at
    Re: Database Maintenance

    Pamela,

    Great!  I think now that the PSTL is free, this really makes sense.

  • Community Member Profile Picture
    on at
    Re: Database Maintenance

    I tested this with PSTL (Database Disabler) and liked this option better...Thanks!

  • Richard Wheeler Profile Picture
    75,796 Moderator on at
    Re: Database Maintenance

    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.

  • Community Member Profile Picture
    on at
    Re: Database Maintenance

    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

  • Victoria Yudin Profile Picture
    22,766 on at
    Re: Database Maintenance

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,863 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,723 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans