Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rsandy
Starting Member
2 Posts |
 Posted - 2010-04-09 : 16:23:01
|
| We have an custom OLEDB provider which works in SSRS 2005 with anonymous access enabled. Since SSRS 2008, does not support anonymous access, I gave access rights to NTSERVICE to run the report. When I run the report, im getting the following error "Cannot create a connection to data source 'DataSource1'. The server threw an exception". I verified that the OLEDB provider is installed properly in my machine. Can anyone help me, what I have to do now, to make sure that SSRS 2008 connects to my OLEDB provider? Is there any security configuration missing? |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-04-10 : 08:20:37
|
| I imagine when you developed the report in BIDS, you were able to create the data source and connect to it and run the report in test mode successfully?______________________________________________Talk sense to a fool and he calls you foolish. |
 |
|
|
rsandy
Starting Member
2 Posts |
Posted - 2010-04-12 : 17:00:55
|
| Apologize for the late reply. The reports was developed in RS 2005 and it was working good with anonymous access. When I deploy it to RS 2008, it could not generate report. I had tested my OLE DB provider and it was working fine. I think RS 2008 could not communicate with the OLE DB provider. What I have to do to make sure my OLE DB provider is invoked by RS 2008? |
|
|
|
|
|
|
Cannot connect to custom OLEDB provider from SSRS