How to Configure the Necessary Database Permissions for Using Bold Reports Report Viewer in IIS
While using the Bold Reports Report Viewer in IIS, when your reports are retrieving data from your SQL database, you have to give the read and write permission for that specific database to access that data in the Bold Reports Report Viewer in IIS. If it is not permitted for the user, it will result in an error. “cannot open the database “Your_Database_Name” requested by the login. The login failed. Login failed for user ‘<Your_User_Name>’”
To resolve this, you have to give read and write access to that specific database. By following the steps outlined in this article, you can ensure that the appropriate permissions are granted to enable seamless data access in the Bold Reports Report Viewer within IIS.
- Open SQL Server Management Studio or any other tool that allows you to manage your SQL Server database.
- Connect to the SQL Server instance hosting your database.
- Expand the “Security” folder and right-click on the “Logins” folder. Then select “New Login” to create a new login.
- In the “Login - New” window, specify the login name as “<Your_User_Name>”. In this example, we have given the user name as “NT AUTHORITY\SYSTEM”.
User name will vary depending on your database. You have to add that specific user name as per your database.
- Choose the authentication method based on your requirements (either Windows Authentication or SQL Server Authentication).
- In the “User Mapping” section, select your “Your_Database_Name” database.
- Enable the appropriate roles and permissions for the “NT AUTHORITY\SYSTEM” login within the database. For example, you might grant the login “db_datareader” and “db_datawriter” roles, or assign specific permissions based on your application’s requirements.
- Click “OK” to create the login and apply the changes.
When utilizing the Bold Reports Report Viewer in IIS to retrieve data from a SQL database, it is crucial to provide the appropriate read and write permissions to the database. This knowledge base article has outlined a step-by-step process for granting these permissions. By following these instructions, you can ensure a successful connection and access to the required data, resolving any potential login failures.
After providing the read and write permissions for that specific user the report will render fine without any error messages.