Summary: You need to perform KapaMPI Server installation but cannot or do not want to use Mixed Mode Authentication on the SQL Server.
Details: The simplest and recommended way to install KapaMPI on your server is to install a separate instance of SQL Server with Mixed Mode Authentication and enter the "sa" password upon KapaMPI installation. This way, it is guaranteed that all Kapa clients, regardless of the Windows user logged in, can access the database without trouble, as the connection to the database will always be made as "sa".
However, in your case you may prefer or require to use Windows Authentication in their SQL Server installations.
To enable KapaMPI to use Windows Authentication, simply check the checkbox "Use Windows Authentication" on initial installation of the Kapa Server. You need to be logged in as a user that has "sysadmin" access to the SQL Server you plan to use in order for the installation to succeed. Server Administrators and Domain Administrators have full access by default.
If you have performed KapaMPI installation in the past and want to change the Authentication mode at a later time, please contact Helintec.
For Windows Authentication to work for everyday use of KapaMPI, each Windows User that may login to KapaMPI from any client pc, needs to have a valid SQL Server Login.
Each of those logins must be mapped to your company's Kapa Databases (main database, training, etc.) granting full access to all tables.
Please consult SQL Server documentation on how to do this.
TIP: A simple solution for trouble-free access for a user is to create a login for the Windows Users that will use KapaMPI and then assign those logins the "sysadmin" role. This will make sure that any database operation will be available on any of the databases, otherwise you may receive unexpected error messages. To do this easily, dowload the attached Script "AddWindowsLogin.hsql", open it with a text editor (e.g. Notepad) and find the following line:
SET @DomainOrComputerName = 'MYDOMAIN'
Change MYDOMAIN to the name of your Domain for Domain Users, or to the computer name for Users that will connect locally from the Server.
Then, go to the next line:
SET @WindowsUserOrGroupName = 'USER'
Change USER to the name of the user, exactly as it appears in Windows Login screen.
Save the file, and double-click on it to run using KapaMPISetup (provided KapaMPI has already been installed).
Afterwards, the specific user will have full access.
You may also use a Windows User Group name, in that case all users of that group will be granted access.
Repeat the process for each of the users you want to give access to.
You should in any case create at least one login with the "sysadmin" role in order to use for KapaMPIAdmin and KapaMPISetup. Those two utilities require elevated privileges on the SQL Server as they manipulate the database at low level.
Administrators of the server pc or Domain Administrators are "sysadmin" by default on the SQL Server. So, you can simply login as Administrator to use KapaMPIAdmin and KapaMPISetup.
Disclaimer: The information on this article are provided as-is and are meant for experienced technical users only. If you do not feel at ease with any of the concepts of this article, please contact Helintec.