I have a SSRS project whose reports retrieves data from a SQL Server database;
I have a WinForm C# project which accesses the SQL Server database
- directly by using OleDb API, and
- indirectly by providing WinForm controls linking to the reports in the SSRS project, which retrieve data from the database.
In order that users of the WinForm executable can access both the database and the SSRS reports by using the WinForm Executable, how shall I set up access permissions
on the SQL Server database?
on the SSRS project?
Do I have to create a user account for each user of the WinForm executable on the SQL server database and the SSRS project?
Are the following two the same:
setting up permission on the SQL Server database for access from the WinForm executable, and
setting up permission on the SQL Server database for access from SSMS?
Are the following two the same:
setting up permission on the SSRS project for access from the WinForm executable, and
setting up permission on the SSRS project for access from pasting report URLs in a web browser?
Thanks.