Enter your SQL server name and instance name. If you want the installation to show you which instances are available, click Load SQL Instances and select the correct instance from the drop-down list.
Note: The drop-down might not display all available SQL Server instances.
If you want to use the Windows Authentication, click Trusted. The account you entered for the Windows Service will be used to access SQL Server and the database. The Windows account needs to be configured in SQL Server to have a login. In addition, that user needs to have the IsahReportServiceRole in the database you want to use. Assign this database role to the user, if necessary. Please note:
- If your trusted user is the LocalSystem and the Isah Report Service is being installed on the database server, you need to assign permissions to user NT AUTHORITY\SYSTEM.
- If your trusted user is the LocalSystem and the Isah Report Service is being installed on another server, user {DOMAINNAME\COMPUTERNAME$} - for instance {ISAH\C0258$} - needs permissions for the database.
If you want to use SQL Authentication, click Specify username and password:
Specify the SQL Server login user name and password that should be used to access SQL Server and the database. That SQL Server user needs to have the IsahReportServiceRole in the database you want to use.
Note:
Use SQL Server Management Studio to assign the role to the Windows or SQL Server user in the Isah database. Isah recommends a user name with IsahReportServiceRole permissions only. These are the only permissions required to run the Isah Report Service. Isah does not recommend the use of the built-in SQL Server user 'sa'.