HaloITSM Guides
Documentation to assist with the setup and configuration of the HaloITSM platform
Read-only connection for reports
Create a SQL user with read-only access to the Halo database
Create a new SQL user account in SQL Server Management Studio by going to Security > Logins, right-click on Logins and select New Login.
Use SQL server authentication and give your user a strong password. Copy this for later.
On the User Mappings tab give your new user db_datareader access to the Halo database.
Save to create the user.
Verify the permissions on the user account by trying to log into SQL Server Management Studio as the user that you created, and verify they only have read access to the Halo database.
Configure Halo
There are two ways to configure this in Halo.
Method 1: Setting in Config > Reports
This involves storing the read-only connection string in the database.
Open Config > Reporting > General Settings. Check "Enable read-only db user". Enter your database connection string for the read only connection in the "Readonly ODBC" field.
If you're unsure what this is, open /api/appsettings.json on the Halo app server. The read only connection string will be the same as this except;
- User Id = the sql user name you created earlier
- Password = the sql users passwords
- Trusted_Connection = False
To test this open the Security and Performance page and verify that "Read-only connection for reports" is now ticked.
Method 2: appsettings
This involves storing the connection string on the Halo app server. Version 2.124+ only.
On the Halo web server, open /api/appsettings.json.
Underneath the DefaultConnection: line, add a second connection called "ReadonlyConnection" with the User Id and password for your read-only user. Ensure you add a comma to the end of the DefaultConnection line.
To test this open the Security and Performance page and verify that "Read-only connection for reports" is now ticked.
Popular Guides
- Asset Import - CSV/XLS/Spreadsheet Method
- Call Management in Halo
- Creating a New Application for API Connections
- Creating Agents and Editing Agent Details
- Departments, Teams and Roles
- Halo Integrator
- Importing Data
- Multiple New Portals with different branding for one customer [Hosted]
- NHServer Deprecation User Guide
- Organisation Basics
- Organising Teams of Agents
- Step-by-Step Configuration Walk Through
- Suppliers