Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Shiv — Wed, 18 Jan 2006 21:25:08 GMT

Hello Russell,

This is very interesting. We were waiting to use the custom authentication on SRSS using forms for the longrest time and I am glad we can do it now. I really like your step-by-step overview on how to accomplish the authentication. However, would you shed some light on how the permissions to the various reports on the report server would be setup? For example we want the admin reports to be viewable only by admins, etc.

Thanks,
Shiv.
[shiven.ramji@gmail.com]

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

russch — Sun, 22 Jan 2006 03:34:39 GMT

Hi Shiv -- Maybe I don't understand your question -- However, you set up permissions on reports just they way you would before switching to Forms Auth -- You'd add the machine\Administrators group to the Browser Role of a report in order to allow admins to view the report, for example.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Trish — Tue, 14 Feb 2006 18:36:06 GMT

We are using a web app with our own custom authentication using cookies. We want to be able to use that cookie to bypass the login screen when displaying a report to the user. Is this possible and if yes, how?

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Kris — Tue, 21 Feb 2006 13:45:49 GMT

Hi
It is a great tip.
It works fine.
One help required:
In Report Manager, how do you assign roles to groups with Role Manager enabled?
Presently, it is only taking usernames, but not accepting group names.
I have membership and roles enabled in my application calling the report server.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

russch — Wed, 22 Feb 2006 18:57:48 GMT

Yes, you can do this and it will happen automatically (the login screen will only be displayed if the cookie doesn't exist). See:

http://blogs.msdn.com/bimusings/archive/2005/12/05/500195.aspx

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

russch — Wed, 22 Feb 2006 18:58:19 GMT

I haven't played with this, sorry.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Wan — Tue, 28 Feb 2006 06:58:02 GMT

Hi,
it is great to interoperate SQLmembershipprovider with RSS2005.
But i need to hardcode the Membership.ApplicationName of the website somewhere in the RSS2005.
How if there are multiple website ( with different Membership.ApplicationName ) that need to access the same RSS2005 , but the RSS 2005 can only take one Membership.ApplicationName ?? ??
PLease help....i stuck in this..thanks

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

russch — Thu, 02 Mar 2006 01:49:06 GMT

No, this wouldn't work...you essentially want o "multiplex" the user database, which we don't do...You couldn't do this in an ASP.NET app scenario, either.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

wan — Fri, 03 Mar 2006 06:35:10 GMT

OK. thanks for youre reply..
Another question. I have manage to make SQLmembershipprovider with RSS2005 to work. Thanks for your guide..
But the subscription couldnt work. In the log file, it said that couldnt load authorization extension. Cant find any more info in the log. Do you have any idea ?

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

russch — Fri, 03 Mar 2006 14:40:01 GMT

Can you post the complete error message coming out of your log?

http://blogs.ugidotnet.org/kfra/archive/2006/01/24/33585.aspx

TrackBack — Fri, 24 Mar 2006 23:56:38 GMT

Cookie not passed from ASP.net to RS???

Dirk — Fri, 21 Apr 2006 13:07:02 GMT

Hi, I managed to get the FormsAuth to work from both (FormsAuth demo app) and the direct login to http://SERVERNAME/Reports.

But I can't get it to work to use the cookie from the web app to automatically login to RS. The custom Login.aspx is shown every time after I try to redirect to http://SERVERNAME/Reports.

I'm sure that I use only a single SQLServer tables users and I ca login with identical credentilas in both apps.

How can I validate if the cookie is passed from ASP to RS?

Is it possible to use the ReportViewer Control (ASP.net 2.0, ) in my ASP.net app and give the control the credentials from the forms auth?

Thanks a lot,
Dirk

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Sreeni KCH — Fri, 21 Apr 2006 18:22:09 GMT

We are very thankfull for your step by step approach. Everything works fine. But i have situation, while accessing the Report Builder, its asking again userid and password. How can i bypass that.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Kris_usa — Fri, 21 Apr 2006 23:07:20 GMT

Cannot find Readme_FormsAuthenication.html file and this directory. Can you post it?

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

russch — Sat, 22 Apr 2006 01:21:47 GMT

Sreeni -- There is no way to pass credentials to Report Builder if not using Windows Auth, so you will always be prompted for credentials in this scenario -- There is no way around it. Sorry.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Sreeni KCH — Tue, 25 Apr 2006 00:17:24 GMT

As i mentioned earlier i successfully implemented the forms authentication. But i am getting the following error while generating the report using Report Builder. "The permissions granted to user 'user1' are insufficient for performing this operation. (rsAccessDenied)".

Could you please help me out on this.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

russch — Tue, 25 Apr 2006 00:44:34 GMT

Have you granted user1 Execute Report Definitions? Sometimes people miss that.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Sreeni KCH — Tue, 25 Apr 2006 17:52:46 GMT

How can i give user1 Execute Report Definitions? Please explain how can i do that.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

russch — Wed, 26 Apr 2006 18:37:50 GMT

Use Report Manager | Site Settings. It is a system-level task, so you will need to assign Execute Report Definition to a system role, then put user1 in that role.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Sreeni KCH — Thu, 04 May 2006 18:49:17 GMT

After forms auth implementation I am getting the following error: Could you please help me out.

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Web.HttpException: Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\App_Data' is denied. ---> System.UnauthorizedAccessException: Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\App_Data' is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.Directory.InternalCreateDirectory(String fullPath, String path, DirectorySecurity dirSecurity) at System.IO.Directory.CreateDirectory(String path, DirectorySecurity directorySecurity) at System.IO.Directory.CreateDirectory(String path) at System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString) --- End of inner exception stack trace --- at System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString) at System.Web.DataAccess.SqlConnectionHelper.EnsureSqlExpressDBFile(String connectionString) at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) at System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) at System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) at System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved) at System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) at System.Web.Security.Membership.ValidateUser(String username, String password) 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 73 at Microsoft.ReportingServices.WebServer.RSCustomAuthentication.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 ---

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Sreeni KCH — Tue, 09 May 2006 00:08:55 GMT

How to add groups, after implementing the Forms Authentication? Is there any way where i can configure groups?

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Patrick — Sat, 13 May 2006 00:14:24 GMT

I want to do authentication without using Login control. Is that possible, if so what would be the code for that?

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

mljdtj — Fri, 19 May 2006 20:30:02 GMT

I followed all the steps outlined above and am getting the following error message now when I try to load reportmanager...

[NullReferenceException: Object reference not set to an instance of an object.]
Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object sender, EventArgs e) +44
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

rubia — Wed, 21 Jun 2006 00:28:05 GMT

i have set up custom authentication and everything works fine when I access a report from a c# app using URL. but if I use reportviewer control or web service then i get this error The request failed with the error message: -- <html><head><title>Object moved</title></head><body> <h2>Object moved to <a href="/ReportServer/login.aspx?ReturnUrl=%2freportserver%2fReportExecution2005.asmx">here</a>.
please help me to solve this error

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

anagrah — Sat, 29 Jul 2006 06:16:10 GMT

Hello rubia,
I am getting the same problem that you have mentioned above. Did you get resolved that problem?. Does any one else has idea why I am getting this this error.
Error detail:

I using custom authentication and everything works fine when I access a report from a c# app using URL. but if I use reportviewer control or web service then i get this error The request failed with the error message: -- <html><head><title>Object moved</title></head><body> <h2>Object moved to <a href="/ReportServer/login.aspx?ReturnUrl=%2freportserver%2fReportExecution2005.asmx">here</a>.

please help me to solve this error

Custom role authorization with form authentication in Reporting Services 2005

Around .NET — Tue, 01 Aug 2006 18:45:24 GMT

Reporting Services 2005, as like its predecessor but now without edition limits, allows the developers...

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Leana — Tue, 22 Aug 2006 15:47:45 GMT

Hi !
I managed to get the custom authentication to work well for some time, but recently I've had a problem : it seems that the report server "loses" the informations about the user or it's profile after a random amount of time, and I get error messages like "The permissions granted to user '' are insufficient for performing this operation. (rsAccessDenied)" either with an empty user name, or with the username when it has just lost the role.
Would anybody have an idea about what is happening, and how to solve that ?

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Eugene Rainey — Mon, 18 Sep 2006 19:36:51 GMT

Regarding the "object moved" error, if you are using ReportViewer you need to implement IReportServerCredentials. See the following article:

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials.aspx

Forms Authentication in SQL Reporting Services

Project Programmability — Thu, 19 Oct 2006 20:31:29 GMT

Phil passed along a blog entry from one of our SQL colleagues which mentions how to support Forms Authentication

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

kukabuka — Fri, 10 Nov 2006 08:23:42 GMT

Did anyone figure out how to post the connection string in the web.config instead of the machine.config?

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Vince — Tue, 28 Nov 2006 00:54:41 GMT

I have setup forms authentication for SQL 2005 RS and it works fine except for subscriptions. If I subscribe to a report using Report Manager when logged in as a user other than the "Admin" defined in rsreportserver.config, the subscription fails. I looked up the log files and found the following error:

ReportingServicesService!library!d!11/27/2006-14:56:01:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;

Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Configuration.Provider.ProviderException: The Role Manager feature has not been enabled.

at System.Web.Security.Roles.GetRolesForUser(String username)

...

It goes on to list the "CheckAccess" method of my CustomSecurity module.

How does the subscription delivery driver work with forms auth?

It appears that subscription delivery does not recognize that role manager is enabled when Report Manager and my application both work fine with role manager.

Forms Authentication with Reporting Services and ASP authentication provider « Charlie Maitland’s Blog

Thu, 30 Nov 2006 18:18:45 GMT

PingBack from http://charliem.wordpress.com/2006/11/30/forms-authentication-with-reporting-services-and-asp-authentication-provider/

Put ConnectionString below ConfigSection in web.config file of ReportServer

Akash Jain — Thu, 21 Dec 2006 09:12:04 GMT

Put ConnectionString below ConfigSection in web.config file of ReportServer.

It worked for me.

SSRS's web.config (found in C:\Program Files\Microsoft SQL Server\MSSQL.?\Reporting Services\ReportServer)

</configSections>

</connectionStrings>

Troubleshooting Sql Reporting Services custom assemblies (extensions & what not)

Lance's Whiteboard — Tue, 06 Feb 2007 04:46:24 GMT

I dont have time for a lengthy post, so here is some link-love for some great articles that have helped

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Kevin Thomas — Mon, 19 Mar 2007 19:20:46 GMT

I understand the authentication extension that has been done in the samples I've seen. However, I haven't understood the authorization framework in a way that makes it useful for a project my company is building. We'd like to use authorization from an external website's security model. We'll know the username with an authorization security extension in CheckAccess, GetPermissions, but want to use the authorization from an external source. All we seem to have access to in the IAuthorizationExtension interface is the ACL for a given item, not any other information about the item ( such as its path or name ) except for its type. How should the ACLs be managed for the items? I'd like to avoid the users using Reporting Services web site to have to manage a separate authorization system from the external website's authorization system.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

chi — Tue, 27 Mar 2007 16:55:28 GMT

"As i mentioned earlier i successfully implemented the forms authentication. But i am getting the following error while generating the report using Report Builder. "The permissions granted to user 'user1' are insufficient for performing this operation. (rsAccessDenied)"."

"Have you granted user1 Execute Report Definitions?"

i followed "Use Report Manager | Site Settings. It is a system-level task, so you will need to assign Execute Report Definition to a system role, then put user1 in that role."

my question is how do i put user1 in the new role ?

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

MM — Mon, 16 Apr 2007 21:25:13 GMT

How do you programmatically set permissions using the RSS2005 WebService? There is only a GetPermissions method and a SetProperties() method. But there is no 'security' property.

I want to give write access to Report Builder users to save to their own folders and read access to the suborganization folder that they belong to etc.

I cannot use the 'My Reports' folder feature because it restricts them to their own folder but does not grant them read access to the suborganization folder.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

MM — Mon, 16 Apr 2007 23:20:49 GMT

Sorry I found that I was supposed to use SetPolicies to set permissions. My next questions is, I am using ReportingService.asmx, but there's another service called ReportingService2005.asmx. What is the difference?

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

russch — Thu, 19 Apr 2007 14:30:39 GMT

ReportingService.asmx is the SSRS 2000 Webservice, which was kept around for backwards compat. You shouldn't use it if you can avoid doing so, however as it will probably "go away" in the next version of SQL.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Pritesh Gandhi — Mon, 23 Apr 2007 08:20:56 GMT

Hi,

I want do the Authorization in form Authentication.Only user can access this much reports that belonging in to the particular Reply.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Andy — Wed, 09 May 2007 16:12:06 GMT

I have Forms authentication working fine, but when deploying Reports using Visual Studio it fails to display a login popup, with error "The permissions granted to user '' are insufficient for performing this operation.

What's the solution?

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Vivek Harne — Tue, 12 Jun 2007 10:29:46 GMT

How to set the authentication mode to SSRS.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

SwissToni — Wed, 11 Jul 2007 13:26:06 GMT

Nice article. I have a problem with report manager, when I login to it I get redirected back to the UILogin.aspx even though the CustomSecurity extension try to redirect to the Folder.aspx. Any ideas why this would happen? I can login to the Report Server with out any problem.

Thanks

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

DS — Wed, 11 Jul 2007 14:30:50 GMT

Report Builder prompts for credentials every time it is launched. Is there any way to skip this since in my web app, the user has already entered his credentials once?

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

russch — Wed, 11 Jul 2007 22:12:30 GMT

SwissToni, I'm guessing you initially navigatge to SSRS using "http://localhost/Reports" instead of "http://machineName/Reports". If you don't use the machinename, you can see this behavior.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

russch — Wed, 11 Jul 2007 22:13:39 GMT

Hi DS -

If you use any sort of authentication mechanism beyond Windows in SSRS, Report Builder will always prompt for credentials. There are discussions of this elsewhere on the blog.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

DS — Thu, 12 Jul 2007 08:34:43 GMT

Hello Russell,

Thanks a lot for the reply.

Since skiping the Report Builder prompt is not possible, is there any way to customize the authentication failure message that this prompt throws on entering invalid credentials in case of Forms Authentication?

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

SwissToni — Thu, 12 Jul 2007 15:36:52 GMT

Hi Russell,

That was the problem. Many thanks.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

DS — Tue, 17 Jul 2007 11:38:45 GMT

Hi Russell,

Im facing another problem using Forms Authentication of SSRS 2005.

when i try to call any of the SOAP functions of ReportingService2005.asmx in my FormsAuthentication application, i get following error:

*********

The request failed with the error message: -- <html><head><title>Object moved</title></head><body> <h2>Object moved to <a href="/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx">here</a>.</h2> </body></html> --.

*********

But if I type

"[servername]/reportserver/ReportExecution2005.asmx" into a browser, I get the webservice wsdl:definitions as I would expect.

Can you please help me out in this?

It is very important for our project to get this solved. Any help would be much appreciated.

Thanks,

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

russch — Wed, 18 Jul 2007 05:15:55 GMT

You're not in SharePoint Integrated mode, are you? Also, are you calling LogonUser before you call the other SSRS web service methods?

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

DS — Wed, 18 Jul 2007 17:34:14 GMT

Thanks a lot for the reply.

No, I was not in the SharePoint Integrated mode but I know that for the same issue in the SharePoint Integrated mode with the Forms Authentication, Microsoft has given a hotfix (KB 939942) on 16th july 2007.

For more information, visit the following link:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=278056

Now coming back to my problem, I got this one resolved. I discovered that the credentials/cookie of my ReportingServices2005 object were not getting set properly. This are getting set properly now and things are working fine.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

clark — Fri, 03 Aug 2007 18:17:47 GMT

hmm .. logging in from ReportServer/Logon.aspx gives an error containing "Invalid object name 'Users'" (I renamed the UserAccounts.Users table). Logging in via my app login page or the Reports/UILogon.aspx page works as expected. Any help greatly appreciated.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Josh — Mon, 06 Aug 2007 21:42:22 GMT

I've successfully implemented a forms custom security extension to authenticate against our LDAP server.

However, deployment via Visual Studio fails due to insufficient permissions and does not prompt for login credentials to the server.

Is there any way to deploy directly from Visual Studio while using Forms authentication?

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Manoj Kumar Sinha — Wed, 10 Oct 2007 16:04:25 GMT

I am using Sql server 2005 reporting services. I have created reports on server. I want -- to connect reportserver from client's PC and Reports with Records should come logged in User wise. This I want to place on different panes, as this happens with Google Analytics and msn sites.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

russch — Thu, 11 Oct 2007 01:40:49 GMT

Hi - Reporting Services isn't an analytics suite, it's a reporting tool. You're not going to find all the fun dynamic drag-and-drop stuff because it's not meant for that purpose.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Gavin Ramm — Fri, 19 Oct 2007 02:04:38 GMT

Hi, I'm not using the SQL membership provider im using an LDAP membership. Will this solution work with this also?

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

russch — Fri, 19 Oct 2007 18:34:34 GMT

Sure, but you'll have to re-write your code to talk to the LDAP provider.

Error at step 3

Krishni — Sun, 21 Oct 2007 19:22:46 GMT

Hi there

I am trying to follow steps above, but at step 3, where i compile the sample application I get and wrror when browsing to the report server : http://<report server>/reports. The error is "loginURL is not a valid site element"

What am i doing wrong?

thanks in advance

Krishni

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Krishni — Mon, 22 Oct 2007 17:36:18 GMT

hi there

I have managed to get the application working....yay. BUT i can only log on with the admin credentials while if I use a normal user then I get the following error when trying to use normal user credentials

System.Web.Services.Protocols.SoapException: Logon failed. ---> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Logon failed. at Microsoft.ReportingServices.WebServer.RSCustomAuthentication.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 --- at Microsoft.ReportingServices.WebServer.ReportingService2005.LogonUser(String userName, String password, String authority)

any help will be appreciated

Krishni

SetPolicies

Ryan — Thu, 25 Oct 2007 20:11:06 GMT

I have successfully completed form authenication with and without LDAP provider.

How do i call the function SetPolicies?

When someone logs into the system, I want to set there role to browser. but I can't get it to work. Any ideas?

Dim test As Microsoft.Samples.ReportingServices.CustomSecurity.ReportingService2005

Dim Item As String = "/"

Dim Policies(0) As Microsoft.Samples.ReportingServices.CustomSecurity.Policy

Policies(0) = New Microsoft.Samples.ReportingServices.CustomSecurity.Policy

Policies(0).GroupUserName = TxtUser.ToString

'Policies(0).Roles = New Microsoft.Samples.ReportingServices.CustomSecurity.Role(0) {}

Policies(0).Roles(0) = New Microsoft.Samples.ReportingServices.CustomSecurity.Role

Policies(0).Roles(0).Name = "Browser"

Policies(0).Roles(0).Description = "May view folders, reports and subscribe to reports."

test.SetPolicies(Item, Policies)

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Vince — Wed, 14 Nov 2007 20:54:37 GMT

We are using RS 2005 SP1 with Forms Authentication.

Most functionality appears to be working correctly, however there are 2 troublesome issues in Report Manager:

#1. My Subscriptions page returns "There are no items to show in this view. Click Help for more information about this page."

This happens even for the RS admin account defined in the rsreportserver.config file

#2. Non-admin users can create their own subscriptions, but they cannot edit them since the "Edit" link is not available in Report Manager.

I have done extensive testing via trial and error - if I turn on the "Manage all subscriptions" task for my default role then item #2 is solved but #1 is still a problem. However, that's a huge security hole that I cannot open.

I have also used the SOAP API to call ListSubscriptions and verify that the Owner property is exactly the same user name that I used to create the subcriptions.

My gut tells me that somehow Report Manager is building the SOAP API calls to match subscriptions based on user id incorrectly. It may be including a slash before the username as a holdover from windows auth or something like that. The scenarios I have tested seem to point to that. I have extensively debugged the custom security module for forms auth. and it appears to work correctly.

Any help would be appreciated, especially any details on how Report Manager builds the "My Subscriptions" page and how it determines whether to display the "Edit" link for a subscription.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Pavani — Fri, 30 Nov 2007 00:05:50 GMT

Hi Russell

I would like to thank you for this nice blog post. This has been helping me a lot and saving tons of my time.

I am wondering whether you have any time to answser/comment on the below questions.

1. How can we deploy a SSRS 2005 Report Model or a Report (RDL) to the Report Manager using Visual Studio 2005 while FORMS AUTHENTICATION + SQL MEMBER PROVIDER is on ?

2. How can I upload the Report Model using Report Manager (I tried your sugggestions but no luck), Can you please provide more specific instructions on how to merge these files?

Thanks in advance.

Pavani

Email: pvajjala@doubleknot.com

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

docchang — Sat, 05 Jan 2008 03:03:32 GMT

I tried to edit the connection string into both web.config in ReportManager & ReportServer. Its been two days I have been trying to input a connection string until i read your

"MAJOR LAMENESS ALERT"

I got it compile, but during run time when my object trying to grab the connection string. It is not there.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Drikus — Fri, 18 Jan 2008 20:46:33 GMT

Hi, nice discussion...

I would also ask a question about the security context with wich a deployment is made from VS2005, which challenged me once and now those credentials are stowed somewhere and I so want to change the user, because I have subsequently created a security model to suit my situation. If I deploy with my "currently stowed away user credentials" I have to add that account to the Publisher role, which is not what I want. I would like to change the user? Howz this done? Thanks in advance!

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Krip — Thu, 13 Mar 2008 19:23:10 GMT

>>Friday, November 10, 2006 12:23 AM by kukabuka

Did anyone figure out how to post the connection string in the web.config instead of the machine.config?<<

Yes it worked for me. I just added this line in the <configuration> section:

Then my sqlProvider line has this attribute:

connectionStringName="myConnectionString"

Finally, the connectionStrings.config file:

<?xml version="1.0"?>

</connectionStrings>

Hope that helps,

Krip

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Krip — Thu, 13 Mar 2008 21:52:57 GMT

Just a question for everyone: Anyone figured out how to deploy Data Sources and Report Models from Visual Studio 2005 when SSRS is in Forms Authentication mode? I get prompted to enter user name and password but it's not able to connect to the report server.

Thanks,

Krip

Links Today (2008-05-28)

Links Today (2008-05-28) — Wed, 28 May 2008 19:38:04 GMT

PingBack from http://mhinze.com/links-today-2008-05-28/

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Jeetu — Fri, 06 Jun 2008 19:14:26 GMT

I am able to authenticate to reporting service using the logonuser method. I call this methode from the reportproxy object while loggin in my custom application. But when I try to access the report catalog using the listchildren method it gives me an "Object moved to here" error. Any help will be appreciated.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Ross Mason — Thu, 26 Jun 2008 00:48:47 GMT

Great article. Will be trying soon...

Lexapro.

Lexapro. — Wed, 16 Jul 2008 16:08:20 GMT

Generic lexapro. Lexapro. Lexapro focalin xr.

re: Using SQL Reporting Services 2005 and Forms Authentication with the Whidbey/2.0 SQLMembershipProvider

Jon — Wed, 19 Nov 2008 23:01:23 GMT

registered Admin, cannot login.

Russell, do you still check this article/blog?

If so, I can give more detail.

Thanks,

Jon