Hi,
I was dabbling about within SIMS System Manager and may have done something I shouldn't with the "System Manager" user although didn't save anything I attempted to change yet when now trying to add users to groups I get the attached error. The user does still get added to the group but am not sure what I need to do to stop this error from appearing. Any ideas?
Log a call with Local support team
Already have. This was while I was waiting for a callback...
Making any changes in System ManagerAdvice
Warning Microsoft OLE DB Provider for SQL Server - User or role 'SIMS_<Teacher Name>' does not exist in this database.
Where <Teacher Name> is the login name for a staff member and SIMS is the database name.
This is usually a teacher who has left and has been made inactiveThis problem is a warning message and can be ignored.
To resolve the problem, please detach and re-attach the database using dbattach.
randle (20th October 2010)
As simple as that eh!! I'll give it a go and see what happens.
Should be. I've seen it a few times before.
Surely you wouldn't have a user called manager... wait... take it back.
I've had that error before and as mentioned above - a detach / reattach fixed it.
randle (20th October 2010)
Just about to perform this. I take it i'm using the "SIMS Database Management Utility" and not ticking the "Drop SQLServer Logins" box?
DBattach.exe, yes. Don't tick the box.
Q the drum rollOriginally Posted by jinnantonnix
Was a bit like that I tell ya. Never quite know when you're going to get a Unhandled exception or something along those lines
Anyway all went as planned and the warning no longer appears. Thanks very much.
Glad to hear it worked.
Glad this is sorted - One of the things that has caused this error in the past is if you provision users using the ADProvisioning tool to SLG and those users are not a member of any permissions group in System Manager.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks