It is recommended to use a dedicated SQL Server database option, if you have a high number of users/technicians working on support cases, as it gives a better performance and is easily scalable.
For SQL server, the server name is mandatory. The Database name is optional. If it is left empty, a new database with the name ‘AssistMyTeamHelpdeskDB’ would be created. If your SQL server is configured to use windows authentication (NTLM), then you can check the ‘Use Integrity Security’ option to let Windows manager the credentials to access the resources on the SQL server. For SQL authentication, each agent needs to enter their credential to connect to the database. So make sure, each agent has a SQL account with the SQL Server.
Using Cloud based SQL Server database
You can also use cloud based SQL server service instead of on-premise such as Amazon RDS cloud service (They offer both free and paid accounts. For more, refer to https://aws.amazon.com/rds/)
For instance, below is our test MS SQL account with Amazon RDS. Once you have signed up and created a MS SQL database, input the endpoint URL as server in our app. Make sure, you suffix the port number after the endpoint as “,1433” so that the full URL in the server name would be ‘XXXXXXXXXXXXXXXXXXXXXXXXX.rds.amazon.com,1433’.
And here is screenshot sample in our app, on how to connect to cloud based SQL server such as Amazon RDS.
NOTE: Most cloud based SQL server provider will not allow connection to the database instance from outside IP addresses. You will need to modify the security setup of your cloud based SQL server to allow (inbound/outbound) connections from your IP addresses.
For easy configuration, I would recommend that you try connecting your cloud based SQL server database through your SQL management studio utility and once a connection is established successfully, it should be easy to implement with our app too.
Permission for Technicians/Agents on the SQL database.
Each of your helpdesk users/technicians should have both db_datareader and db_datawriter permission on the Helpdesk SQL database.
NOTE: When choosing a SQL server database for Helpdesk add-in, if you are not using the ‘Integrated Security’ (also known as Windows Authentication, or NTLM authentication), then it is very important that the agent has a SQL user account.
If you have not setup a SQL Server for use with our app, refer to this KB article on how to setup one – Setting up a SQL Server Express for use with AssistMyTeam Collaboration Apps