This is probably a dead stupid question, but I'm new to GP 10.
I'm trying to build a DR server for GP 10 with MS SQL 2005 SP1 on a Win 2k8 server.
Whenever I try to use the Login/User Generator it tells me there are 5 users logged in. Even after a fresh install. I assume they were logged in when that database was backed up last (and that I restored from). But how do I clear them so I can create them?
Thanks!
*This post is locked for comments
Don,
You can do this in the GP user interface by going to GP | Tools | Utilities | System | User Activity and deleting each login manually.
Or...log out of GP, then run the following script in SQL:
delete DYNAMICS..ACTIVITY
delete DYNAMICS..SY00800
delete DYNAMICS..SY00801
That should clear all the logins that were there when you took your backup.
Don - Do you have MS SQL Server Management Studio installed?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156