Provide a user access to Reporting Services

If a new user needs to open reports through the Reporting Suite or IRIS Financials Purchasing, set them up as a Reporting Services user. This process is only required for customers not using our PS Cloud environment.

Complete the processes in this topic on the SQL and Report server (if you have one). You may therefore need to speak to your IT department/provider for assistance. The example shown in this topic uses Microsoft SQL Server 2016.


Add a new Reporting Services user

  1. On the Report Server (if you have one - SQL Server it not), open an internet browser and enter http://[Servername]/reports in the address bar. For example, if your server is called aaw05, the address is http://aaw05/reports.
  2. The SQL Server Reporting Services window opens. Select Manager Folder on the toolbar.

    In previous versions of SQL Server, this may be called Folder Settings.

    SQL Server Reporting Services home page with the Manage folder button highlighted on the toolbar. Folders such as Academy Dashboard and Accounting Tabs are listed below.

  3. The Security page opens. Select + Add group or user on the toolbar.

    SQL Server Reporting Services Security page with the Add group or user button highlighted on the toolbar. One group, BUILTIN Administrators, is listed with its roles.

  4. Enter the full Windows domain user name (not IRIS Financials user name) in Group or user:, then select Browser. If you are adding an ACTIVE DIRECTORY USER Group, your IT department must set it up in their Active Directory.

    New Role Assignment page in SQL Server Reporting Services. A group or user name is entered, the Browser role is ticked, and the OK button is highlighted.

  5. Select the OK to save the changes.


Give the user access to Reporting Services

The next step is to add the user to the XUSERLOGIN table on the SQL database. This enables the user to be able to login to Reporting Services.

  1. On the SQL server, open and log in to Microsoft SQL Server Management Studio.

    Windows search results for sql ser, with Microsoft SQL Server Management Studio highlighted as the best match.

  2. From the Object Explorer panel, expand the Databases, PSFSYSTEM then the Tables folder to display the tables in the SQL database.
  3. Right-click the dbo.XUSERLOGIN table, then select Edit Top 200 Rows from the pop-up menu.

    SQL Server Management Studio Object Explorer with the Databases, PSFSYSTEM and Tables folders expanded. The dbo.X_USERLOGIN table is highlighted and its shortcut menu shows Edit Top 200 Rows highlighted.

  4. Scroll to the bottom of the list of users and select in NULL on the USERID row, as this graphic shows. Enter the IRIS Financials user name of the new user. This is the user name set up in the USERS ledger in IRIS Financials when the user was first added to the system.

    Edit Top 200 Rows window for the dbo.X_USERLOGIN table with columns ID, USERID and DOMAINNAME. The empty USERID cell on the new row is highlighted.

  5. Press the Tab key to move to DOMAINNAME and enter the new user's Windows user name.

  6. Press the Tab key to create a new NULL line, which automatically saves the record. You can now close the Microsoft SQL Server Management Studio window.