I am implementing the Custom Security Extension for Reporting Services. It all compiles into Microsoft.Samples.ReportingServices.CustomSecurity.dll & Microsoft.Samples.ReportingServices.CustomSecurity.pdb

Within Microsoft.Samples.ReportingServices.CustomSecurity.dll I have a reference to a class library that I have installed into GAC Membership.Data.dll

Within Membership.Data.dll I have a reference to the Microsoft.Practices.EnterpriseLibrary.Data.dll

Under the ReportManager & ReportServer Folder I have edit the default connectionstring into their web.config files.


I am getting a run time error when my Membership.Data.dll calls "DatabaseFactory.CreateDatabase();" It can not find the connectionstring that I have edited in the web.config. Here is the exception:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Membership.Data.DataProvider.Authenticate(String login, String pwd) at Microsoft.Samples.ReportingServices.CustomSecurity.AuthenticationUtilities.VerifyPassword(String suppliedUserName, String suppliedPassword) in C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Extension Samples\FormsAuthentication Sample\cs\FormsAuthentication\AuthenticationUtilities.cs:line 117 at Microsoft.Samples.ReportingServices.CustomSecurity.AuthenticationExtension.LogonUser(String userName, String password, String authority) in C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Extension Samples\FormsAuthentication Sample\cs\FormsAuthentication\AuthenticationExtension.cs:line 70 at Microsoft.ReportingServices.WebServer.RSCustomAuthentication.LogonUser(String userName, String password, String authority) at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.LogonUser(String userName, String password, String authority) at Microsoft.ReportingServices.WebServer.ReportingService2005.LogonUser(String userName, String password, String authority) --- End of inner exception stack trace ---

any ideas?

Are you passing in the correct connection string name/section to "CreateDatabase" method? Also, is this an ASP.NET application or a Windows Forms application. If it is ASP.NET you have to use the 'web.config' file, if not then you have to name it 'app.config'

For some reason the Reporting Services web.config has problem working with Enterprise Library Data Access Block, so I encapsulate all my data accessing into a Web Service. The configuration file in web services works standalone so you don't need to worry about other factors when using it verses using it as a class library with issues like permission, trust level, and configuration extraction.

That's my thought on that. If you like to add or see it differently please reply. I am eager to learn.

DC