In our help note – How to Configure a Network Database (SQL Server), we recommend using Windows Authentication to autheniticate with the SQL Server as there is no need to setup additional passwords. Additionally a single domain security group can be used instead of setting up separate user logins. If however you don’t have a domain network environment you may find it easier to use SQL Authentication.
MSSQL is not part of Calxa and these instructions herein are provisional and should be confirmed with the official Microsoft documentation. The steps outlined in this help note are for a suggested setup using SQL authentication where the SQL Login passwords will not expire and a password policy will not be enforced. Users are granted full access to the Calxa database but only public access to the server will be granted.
Open SQL Server – SQL Management Studio
Right Click on Logins and select New Login
On the Login – New window complete the following:
- Login Name (this will be the username used in Calxa later)
- Select SQL Server authentication
- Enter a password and confirm password
- Uncheck User must change password on next login
- Uncheck Enforce password expiration
- Uncheck Enforce password policy
Click the User Mapping option on the left and in the right hand column and complete the following:
- Tick the Calxa database to be mapped to
- Tick the db_owner option in the Database role membership section
- Click OK
If Calxa opens an existing database automatically you will need to click the orange Calxa drop down field in the top left corner and select Authentication, otherwsie skip this step.
On the Open or create Calxa Database screen select Network database from the Data Sources list in the left hand column.
- Select the Server name and database
- Select SQL Server Authentication from the drop down list
- Enter the login name and password that was created in SQL Management Studio and click Sign In