Before ingesting Reporting Services metadata into Dawiso, prepare your account for authentication by configuring a SQL user and grant it the necessary permissions.

Connection prerequisites

  • Ensure you are using an account with sufficient privileges to create logins, create users, and grant the minimum required permissions to the newly created user.

Connection configuration

In this guide, you will:

  • Create a new SQL login
  • Create a user for the login in the Reporting Services database
  • Grant minimum required permissions to the newly created user

Create new login

Create a new SQL login (e.g., DawisoIntegration) using the following statement:

CREATE LOGIN [DawisoIntegration] WITH PASSWORD = 'password123'
  • Make sure to replace password123 with a strong password. Refer to the official Microsoft documentation for more details.
  • If you use a custom login, make sure to replace it in all following statements.

Create users for login

The login is created at the server level, which is why you also need to create a corresponding user in each database from which you want to ingest metadata.

Switch to the database context and create a new user (e.g., DawisoIntegrationUser). You can use the same username across all databases:

CREATE USER [DawisoIntegrationUser] FOR LOGIN [DawisoIntegration]

Grant permissions

The minimum required permission for this user to ingest data is membership in the db_datareader role. Run the following statement in the context of the ReportServer database:

ALTER ROLE [db_datareader] ADD MEMBER [DawisoIntegrationUser]

Sample script

You can copy and run the following script on your server. To execute it, you must have the ALTER ANY LOGIN permission or be a member of the securityadmin fixed server role.

USE [master]
GO

CREATE LOGIN [DawisoIntegration] WITH PASSWORD = 'password123';
GO

USE [ReportServer]
GO

CREATE USER [DawisoIntegrationUser] FROM LOGIN [DawisoIntegration];
GO

ALTER ROLE [db_datareader] ADD MEMBER [DawisoIntegrationUser]
GO