Note: SQL Server Management Studio is not installed by EZ Arms Keeper. It is however installed by the Microsoft SQL Server 2014 install.
Windows Authentication logins can be used to associate with you existing Domain Users. This way you don’t have to maintain an additional username / password.
SQL Server Authentication logins are a separate username / password only applicable for this Microsoft SQL Server instance.
First we are going to add a SQL Server Authentication login as this is the simplest type of login.
Login Name: SqlServerLogin
Password: **********
Confirm password: **********
Default database: master (DO NOT CHANGE the logins default database from master)
Application Roles
Server Roles
6. public – By default all users are members of this role. DO NOT REMOVE users from the public role or parts of EZ Arms Keeper may not function properly when this user is logged in.
Note: A user can be a member of multiple roles. The result with be an accumulation of permissions from each role
For this example we are going to choose to add the user to the “Acquisitions” role.
Note: That after opening the bound book you can’t see the Disposition menu option because the SqlServerLogin we created is not a member of a role that has access to this feature