I want to add a new user but don't have SQL Server Administrator permissions.
What do I do?
If you have the MainBoss Administration security role, you can use
Administration | Users to try to add a new user to MainBoss.
However, you must also have SQL Server Administration permissions for the operation to succeed.
If you don't have these permissions, you'll get the error message
User does not have permission to perform this action.
The statement has been terminated.
Since the problem is that you don't have SQL Server permissions, you can't fix it
by giving yourself more MainBoss permissions.
There are several ways to fix the problem.
You can obtain SQL Server Administrator permissions, at least for the time required
to set up the new user.
(If your IT department doesn't want to give you such privileges, you
might persuade them to give you the privileges just long enough to create
the new user record, then to take away the privileges again.)
You could go to the Defaults for User section of
Administration | Users and remove the
"MainBoss manages SQL security" checkmark.
(To remove the checkmark, click the "Edit Defaults" button and remove
the checkmark in the resulting window.)
If you do this, MainBoss will not attempt to set SQL Server permissions
for any new people you add to the Users list; your IT department
will have to manually add SQL Server permissions for each new person
(following the instructions in the MainBoss Installation and
Back to FAQ index
Copyright © 2018 Thinkage Ltd. All rights reserved