Custom Reports Deployment to SP2010 Site with FBA

Question

Hello all,

Hopefully somone where is able to help with this small issue I have. I'm trying to deploy some SSRS reports to my SharePoint 2010 Foundation Site which is Claims Based - FBA only.

I keep getting an error when trying to load the ReportingServices2010.asmx

My Code that accesses ReportingService2010:

private static ReportingService2010 InitialiseRs()
 { 
	var rs = new ReportingService2010 
		{ 
			url = spUrl + "/reportserver/reportService2010.asmx",
			Credentials = CredentialCache.DefaultCredentials
		 };
	 return rs;
 }

It is the Authentication that it is falling over on as my network account doesnt have access to my SharePoint site.

This is the error that I'm getting:

System.Web.Services.Protocols.SoapException: The permissions granted to user 'MyDomain\Irianna' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'MyDomain\Irianna' are insufficient for performing this operation.
   at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.CreateDataSet(String dataSet, String parent, Boolean overwrite, Byte[] definition, Property[] properties, CatalogItem& itemInfo, Warning[]& warnings)
   at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.CreateCatalogItem(String ItemType, String Name, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, CatalogItem& ItemInfo, Warning[]& Warnings)
   at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateCatalogItem(String ItemType, String Name, String Parent, Boolean Overwrite, Byte[] Definition, Property[] Properties, CatalogItem& ItemInfo, Warning[]& Warnings)

I've tried adding Windows Authentication back into the Claims Based and adding my Domain account as a Site Collection Administrator and still unable to get this work.

Does anyone know if it is possible to do this?

Is is possible to pass the SPUser and SPUserToken over?

I know that BIDS prompts for a password when deploying from there, is there anyway to mock this password prompt inside a c# console app?

Appologises if this is posted in the incorrect forum was unsure if it should be SP or SSRS as its kind of both sides of the fence.

Many Thanks in advance, Irianna

Answer 1

Hi,

Thank you for your question.

I am trying to involve someone familiar with this topic to further look at this issue.

Thanks,
Qiao

---

Qiao Wei

TechNet Community Support

Answer 2

Thank you ever so much.

This is becoming a major issue for me now as this is kind of the final peice of the puzzle for my solution.

Any help you can offer would be greatly accepted.

Irianna.

Answer 3

Hi Irianna,

Thank you for your post.  In order to better assist you, I have some questions regarding the issue you are encountering.
1. Have you ever been able to access SharePoint with FBA?
2. Where do your forms based users reside? (LDAP, Active Directory, SQL?)
3. What permission does the users that you are testing with have in SharePoint and in SQL?

In addition to these questions I would recommend that you review the following documentation configuring forms based authentication to verify that is configured correctly.   http://technet.microsoft.com/en-us/library/ee806890.aspx

Gregg

---

MSFT

Answer 4

Hello Gregg,

My FBA is fully working with all aspects of SharePoint, with various users and permissions.

I'm using SQL for my forms authentication base.

The user i'm trying is a Site Collection Administrator, I have also tried using with just Owner group access as well with no luck.

Thanks for the link, I'll take a read through it however I'm sure that its configured as it should be as everything else is working fine.

My Console application that I have opens up the Forms Authentication Window and requests my username and password, I then get the SPUserToken and use that for creating libraries in the site which is working fine - however the ReportingService2010.asmx doesnt seem to want to use the forms based account when authenticating against the SharePoint site, just my domain account, or when no credentials are supplied it just drops out saying no credentials supplied.

Any help you can offer at this stage would be great.

Thanks, Irianna.

Answer 5

Hi Irianna,

Thank you for your response.  One other thing I would like to confirm is whether you are able to render SSRS reports within your SharePoint site while using form based authentication. I’ve included our MSDN documentation on configuring SSRS in integrated mode below. If this functions properly I would like to engage a development resource to review your console app code posted previously in the thread.

http://msdn.microsoft.com/en-us/library/bb283324.aspx

Gregg

---

MSFT

Answer 6

Hello Gregg,

The SSRS Reports are running fine once deployed via BIDS to my SharePoint Enviroment with FBA. 

I've even tried setting up with Intergration to use Both Trusted and Windows accounts (In SharePoint Central Admin >  General Application Settings > Reporting Services Intergration) however this has had no affect.

I have also tried setting my console application to use " spUrl + /_vti_bin/ReportServer/ReportService2010.asmx" but again no affect

Thanks, Irianna.

Answer 7

Hi Irianna,

At this point I believe we have hit the wall on what we can do in the forums. I recommend that you open a support ticket with Microsoft so that we can take a deeper look at the issue and perform more thorough troubleshooting.

Gregg

---

MSFT

Answer 8

Hello Irianna,

Have you solved your problem? I am having the same problem here with FBA...

Thanks

Answer 9

Hello Hugo,

Yes we did manage to get this working.

The trick was to pass through the FBA Details into the console application and use these to authenticate using a Web Reference which logged on and use that cookie to connect to the report server. we were then able to deploy the reports when FBA was enabled on the site.

See the following code (C#):

  private static ReportingService2010 InitialiseRs(string spUrl, string fbaUser, string fbaPass)
        {
            fbaAuth.Authentication auth = new fbaAuth.Authentication();
            auth.Url = spUrl + "/_vti_bin//authentication.asmx";
            auth.CookieContainer = new CookieContainer();
            fbaAuth.LoginResult lr = auth.Login(fbaUser, fbaPass);
            var rs = new ReportingService2010();
            if (lr.ErrorCode == fbaAuth.LoginErrorCode.NoError)
            {
                rs.Url = spUrl + "/_vti_bin/ReportServer/ReportService2010.asmx";
                CookieCollection cookies = auth.CookieContainer.GetCookies(new Uri(auth.Url));
                Cookie authCookie = cookies[lr.CookieName];
                rs.CookieContainer = new CookieContainer();
                rs.CookieContainer.Add(authCookie);
            }
            return rs;
           
        }

fbaAuth is the Web Service.

Hope that this helps you, I know how painful this can be

Irianna.