reporting using SQL Server security

B

BillE

I am developing locally processed reports with VB2005, displayed in a report
viewer on a web form.

Unfortunately my environment does not permit integrated security.

How can I supply the username and password to the report at run time when
the web form opens?

I tried populating a dataset and supplying the datatable to the report with
LocalReport.DataSources.Add method, but the report requires a datasource
instance and I get errors before I can add the data table as a data source.

I used a stored procedure to create the dataset the report is based on, and
it tries to load the report at runtime with the original dataset, but I get
login errors or errors like "a data source instance has not been
supplied..."

Thanks for your help
 
C

Cowboy \(Gregory A. Beamer\)

Use a connection string that allows access to the data in the report. You
can then always hit that site. If you only want certain people to be able to
hit the site, add headers. Not completely safe, if this is an Internet site,
but fine for Intranet. If you want more security, issue X.509 certificates
and use them to allow or deny access. A bit more painful, but certainly more
secure.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*********************************************
Think outside the box!
*********************************************
 
B

BillE

Thanks for the response, I appreciate it - I've been struggling with this
for days.

I have been trying to replace the original datasource which I used to create
the report with a data table I populate at run time using the current login
information, but when I call ReportViewer.LocalReport.DataSources.Clear(),
and add a new ReportDataSource, I get an exception "A data source instance
has not been supplied for the data source".

Is this not possible?

Thanks again
Bill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,818
Messages
2,569,727
Members
45,664
Latest member
Phil79581

Latest Threads

Top