We have a web-based application where we authenticate users. Users get to the reports via links in the application. No one is sent directly to the Report Manager.
We have tried Windows Authentication but it is sketchy at best. I can log into the application and access reports at my machine. However, if I go to someone else's machine, it does not work. This is true even if the person whose machine it is has rights to Reporting Services.
We are going to have people logging in from all over the state with possibly a variety of devices so a location-dependent solution is not going to work.
In our application, we authenticate people by comparing their log-in credentials to those held in a SQL Server table. When the application accesses the database, it is a user. No matter who is logged in, the app is always the same user when it connects to SQL Server.
Isn't there a way to do this with RS?
We have tried Windows Authentication but it is sketchy at best. I can log into the application and access reports at my machine. However, if I go to someone else's machine, it does not work. This is true even if the person whose machine it is has rights to Reporting Services.
We are going to have people logging in from all over the state with possibly a variety of devices so a location-dependent solution is not going to work.
In our application, we authenticate people by comparing their log-in credentials to those held in a SQL Server table. When the application accesses the database, it is a user. No matter who is logged in, the app is always the same user when it connects to SQL Server.
Isn't there a way to do this with RS?