Geeks With Blogs
Everything IT Programmer, SQL and Server Admin

Has anyone successfully gotten this sample to work in reporting services?

http://msdn.microsoft.com/library/en-us/dnsql2k/html/ufairs.asp?frame=true

I noticed that the configurations left out one area in terms of forms authentication but even after finding and fixing that error, I still get a Server Not Available error.

Posted on Thursday, July 15, 2004 6:06 AM | Back to top


Comments on this post: Trouble With MSDN Article on Reporting Services

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I'm glad it's not just me... i spent 3 days working on this sample, trying to get it to work... all this time i thought it was something I was doing wrong, though. From my experience, though, I had the same problem where the reports manager would alwasy say that it can't communicate with the reports server... basically, the reports server was redirectly the web services request to a login page, which isn't a valid response for a web service call, so the reports manager was just saying server not available.

I'd love to find an actual working solution for this, though. if you do find it, send me an email: dredge -at- avocadosoftware ....dot.... com.

Left by Derick Bailey on Jul 16, 2004 9:40 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
You bet. I am working with Bryan Keller os MS on this issue an he has given me some items to check. As soon as I get it working, I will send you an e-mail with the resolution.

Gerry
Left by Gerry O'Brien on Jul 16, 2004 10:17 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Hi Gerry,

If its not too complicated, can you post your solution on this site. Or email me at ashimadua78@hotmail.com.

I've spent 2 days to try to get it to work too, but no luck.

Thanks!
Left by Ashima Dua on Jul 21, 2004 12:53 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Ashima, hi. I would be more than happy to post the solution or e-mail it. Trouble is, I don't have the solution yet. I still cannot get it to work.

I am now at the point where I am going to try it on another machine and see if that makes a difference. I though that perhaps it was a permissions issue early on but after trying it logged on as an Admin user, the problem is still there.

Bryan hasn't gotten back to me after my last post on the public new server group on Reporting services. He suggested verifiying my config files with those in the article one more time, which I did. Plus, I went one step further and asked some co-workers to verify the files as well.

Still working on a resolution. I will let you know as soon as I have sovled the mystery.

Gerry
Left by Gerry on Jul 21, 2004 1:19 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Hi all. Just like you guys, I've been trying for a couple of days. Checking and re-checking the code from the article.

I will hack on for a couple more days and keep you guys posted if I get any joy.

However, if anyone else solves "the mystery", please could you email paul_dj_mckenzie -at- yahoo -dot- co -dot- uk

Cheers
Left by PMac (UK) on Jul 23, 2004 3:56 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
It works finally!!!

I ended up putting XP Pro on my machine instead of Server 2003 so I'm not sure if that had anything to do with it.

Here are some items that I found;

1) It is very annoying and aggravating to be going from config files in ReportServer to ReportManager. The author of the article could have done a better job at keeping you in one directory for all config files then switching to the other directory. It would be far less confusing.

2) On page 12, (if you printed the article), on of the config file lines is not complete. Here is the printed AND online VIEW of the section.

<CodeGroup
class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="$CodeGen$/*"
/>
</CodeGroup>
<CodeGroup
class="UnionCodeGroup"
version="1"
Name="SecurityExtensionCodeGroup"
Description="Code group for the sample security extension"
PermissionSetName="FullTrust">
<IMembershipCondition
class="UrlMembershipCondition"
version="1"
Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\Microsoft
/>
</CodeGroup>

Allowing of course for word wrap the snippet is relatively close to what you see. The problem is the Url attribute of the tag is not complete. You will not see the complete line in the online version either. You will have to copy and paste into notepad to see that the full URL should be;

Url="C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\Microsoft.Samples.ReportingServices.CustomSecurity.dll"

3) On page 11, again printed page numbers only, when modifying the RSReportServer.config file, you will notice that you are modifying some attributes of the Extension tag under the Security tag. You will also be adding some child tags of Extension as well. This means that the original closing tag of /> must be changed to > so that you can enclose the <Configuration> <AdminConfiguration> and <UserName> tags as proper children of the <Extension> tag. I believe I missed that one first time around myself.

This time around, it did work for me.

Gerry
Left by Gerry on Jul 23, 2004 7:52 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I was able to get this sample working in a day or two. You need to put the logon.aspx and the UILogon.aspx in both the ReportManager/Pages/ folder and the ReportServer/ folder. You also need to deploy the DLL to the bin folder in ReportManager as well as the bin folder in ReportServer. In the rssrvpolicy.config point the the DLL on the report server. That should do it.

HTH

Nick

npagano AT indataweb.com
Left by Nick Pagano on Jul 29, 2004 4:25 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
That was never an issue. The article already listed those as steps to complete and they were.

Thanks for the suggestions though.

Gerry
Left by Gerry on Jul 29, 2004 4:30 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I kind of got it to half work. When accessing the REPORTSERVER, I can get through and I see the Login.aspx page. When I try to use the REPORTMANAGER, I get an asp.net error saying it can't load a .dll.
I'll keep looking into.
Anyone enconter that?
Left by Eugene K on Jul 30, 2004 4:43 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Some more thoughts. As I had copied the dll's over to the reporting server, I had to change the permissions on the dll files to include System, Network System (if w2k3), etc.

Now I can see the login page for REPORTMANAGER, but I can't get through. Nothing happens when I login. I am logged in to REPORTSERVER so the authticket has worked. Weird...

Eugene
Left by Eugene K on Jul 30, 2004 5:32 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I didn't have to change any permissions on files for my solution to work. Strange.

Did you create a new user by going through the registration process? That will add the username to the database.

Gerry
Left by Gerry on Jul 31, 2004 11:40 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Just getting back from vacation and reading this.

No, I wasn't aware of that. We are using Developer Edition and it is alright with that version. Must only be with the Standard Edition.

Gerry
Left by Gerry on Aug 17, 2004 8:41 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Greetings all,

I am trying this now for the first time & have also gotten stuck. I hope you have all now managed to get it working 100% & can tell me what is wrong.

I've checked & rechecked all the settings & am sure everything is exactly as in the artical. I cut & pasted the changes & fixed word wrap funnies, so did not miss any characters or break any lines. I editted the files in the .Net IDE & validated to check for typo's. I'm doing this on XP Pro with SP2.

Are there any errors in the artical ? I noticed that in the 'Configuring the Web.Config' section, the Report Manager Web.config does not do steps 3-5 as in the Report Server web.config - is this right ?

When I go to the localhost/Reports page, I get:
Unable to communicate with report server.

If I try going to localhost/ReportsManager, I get a Parsing error in machine.config on the line:
<add name="ValidatePathModule" type="Microsoft.Web.ValidatePathModule, Microsoft.Web.ValidatePathModule, Version=1.0.0.0, Culture=neutral, PublicKeyToken=eba19824f86fdadd"/>

Grateful for any advice.
Left by DaveSemm on Nov 25, 2004 7:41 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
The article, along with everything mentioned here for the fixes, has been working fine for me now.


I had the same error message once, unable to communicate with report server, but don't recall what caused it. Double check your permissions on the folder, ensure that it is actually an application folder and not just a Virtual Folder.

Verify the process it is set to run under as well.


Gerry
Left by Gerry on Nov 25, 2004 8:44 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
This may be a silly question but, is there a local account for the user that you have registered? Or perhaps you are on a domain and the user account doesn't exist there either.

Also, make sure that you have added the user to a role on the report server as well.

Reporting Services relies on Windows authentication by default and if you don't have a user account for the user you are trying to log on as, it can generate authentication errors.

Gerry
Left by Gerry on Dec 03, 2004 7:46 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I'm using Standard Edition of SQL Server. Is it necessary to use Enterprise Edition for Form Authentication method ?


Gaurav.
Left by Gaurav Shah on Dec 04, 2004 12:00 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
That I can't answer without searching the documentation or the Net.

I can tell you that it works in the Developer Edition for sure as that is what we are using.

I do believe that I heard a rumor about forms authentication support not being avalailable in the Standard Edition but I can't be 100% sure.

Gerry
Left by Gerry on Dec 06, 2004 12:50 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I want to create my own toolbar like url access method have.
Mainly i want to give export and paging features.

can u help me or provide me sample code for create my own toolbar using webservices for reporting service..


Gaurav.
Left by Gaurav Shah on Dec 07, 2004 12:24 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Gaurav, I'm sorry but I haven't taken Reporting Services that far yet. The most I have done without using the standard interfaces is to host the control in an iFrame and do some manual coding.

For what you want to do, there is an SDK that should offer samples and guidance for that.

Gerry
Left by Gerry on Dec 07, 2004 8:32 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I created the UserAccounts database and it's two stored procedures as stated in the sample. But how and where do you ADD a login for the local ASPNET account ???

I tried to add a new login in SQL Server Enterprise manager for mymachinename/ASPNET. I get following error - Windows NT user or group 'RJAD501062897\ASPNET' not found. Check the name again.

I tried to run sample application. I just get following error - Object reference not set to an instance of an object - when I try to access reoprtsmanager by saing - http://localhost/reoprts.

I have windows XP Pro and local SQL server and local reportsserver. Any help would be appreciated.

Left by RJ on Dec 13, 2004 11:39 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
One of the first things you have to do is go into Enterprise Manager, expand the Security node. Right click Logins and choose New Login...

This will present you with the New Login dialog box. Click the button to the right of Name. In the List names from drop down, ensure that your local computer name is selected if you are going to be running this from you local IIS.

Locate and doubleclick the ASPNET account from the list of account names and click OK. This will add the ASPNET account to the logins for SQL Server. Before you close the dialog, assign the account the appropriate database access from the Database Access tab and the appropriate server role from that tab.

That's all you should have to do to add the account. Ensure that when you view the report server locally that the account has been added to one of the existing roles.

Gerry
Left by Gerry on Dec 13, 2004 1:53 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I did that in Enterprise manager. I selected the localmachinename and the ASPNET account. I got the error - ERror 15401 : Windows NT user or group 'mymachinename/ASPNEt' not found. Check the name again.

Which is strange since I selected the ASPNET account from list of users.

BUT I must say that I MANUALLY created the ASPNET user account in 'My Computer' >> Computer Management >> Local Users and Groups.

I have Microsoft .Net framework 1.1 installed. I have read that this should create the ASPNET account. SO I should see ASPNET as a user in 'My Computer' right ???...but I do not see it in list of users in My Computer >> manage section >> Local Users and groups. I have registered ASP.net using aspnet_regiis.

How do I get the localmachinename/ASPNET account created on my machine ???

:(

Left by RJ on Dec 13, 2004 1:04 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
OK. I could create a mymachinename/ASPNET login in ASPNET. The problem was that there was an existing login by the name - othercomputername/ASPNET . I deleted this and created the mymachinename/ASPNET and it created !

The 'othercomputername' was one of the servers where Reportserver was first installed and i was trying to access it. Don't know how this account got created.

Anyways so I created the login and granted it all the required permissions and ran the sample - http://localhost/reports. I get the error - Object reference not set to an instance of an object - Just get this error..cannot see login page. Any idea ??

Also what is the type of this sample application ?? class library ??
Left by RJ on Dec 13, 2004 1:15 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Yes, the account should have been created automatically for you when you installed .NET. You should remove the account you created, uninstall .NET and reinstall.

It should be there.

Gerry
Left by Gerry on Dec 13, 2004 1:16 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Correction in above post - I mean I could create the mymachinename/ASPNET login in SQL Server Enterprise manager. Gerry thanks for you previous reply.
Left by RJ on Dec 13, 2004 1:16 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Here is what I would do.

1) Uninstall Reporting Services
2) Uninstall .NET Framework
3) Remove any existing ASPNET accounts
4) Reboot
5) Install .NET
6) Verify ASPNET user account is there
7) Install Reporting Services again.

You are certain that there are no error messages or warnings when you install Reporting Services?

Gerry
Left by Gerry on Dec 13, 2004 2:19 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
YES, I had lot of problems installing Reporting services. Error was Report Server was not initialised. Resolved this error by

rskeymgmt -d
rsactivate
Manually added ASPNET account to local Administrators group.

After above 3 steps my reporting services worked. I could access Reportmanager and server.

Well correction, I did not manually create the ASPNET account...I did not see it in the list so I searched the mymachinename/ASPNET name and added it to Administrator group.

Also It does say in the description of this account - Account used for running ASP.Net worker process...so I think that is not an issue now. SO this ASPNET account should be a valid account.

But my sample is not working.
Left by RJ on Dec 13, 2004 1:36 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Strange.

You should remove the ASPNET account from the Administrator's group though. Not a good idea to have it there.

Are you only running .NET v1.1?

I had issues installing it here but forgot that I have .NET 2.0 installed as well. I had to remove .NET 2.0 by using aspnet_regiis -u from the 2.0 directory. Install Reporting Services, then reinstall 2.0.

Other than that, I had no issues with it installing at all and working right off the bat.

Gerry
Left by Gerry on Dec 13, 2004 2:40 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Yes I have .Net v1.1

Yes, my mgr said the same that it is not a good idea to have ASPNET in admin group. But only when I did that did my reporting services work. :(

OK I will uninstall .Net Framework 1.1 and Reporting services and install both again.

But just uninstalling the framework should not be problem, right ??

ALSO by uninstalling .net framework will it remove the ASPNET account ??
Left by RJ on Dec 13, 2004 2:25 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
One more question regarding the sample. What type of application is it ??? A Class Library ??? ALSO where does the Reportingservice.cs class file come from. When you open it, it says this code was generated by a tool.

Also can I create an exact same application as the sample but as a ASP.Net web application ??? will it work like the sample app ??

Left by RJ on Dec 13, 2004 3:30 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I'll answer both previous posts.

1) I'm not sure if the ASPNET account is removed upon removing the framework or not. Never thought to look. Check and remove if it doesn't remove it automatically.

2) It is an ASP.NET web application. The .cs files is generated by MS when they created Reporting Services. It essentially gets built when you do the install which is why it says it is generated by a tool.

You can create the same app yourself although it will take a lot of work.

Gerry
Left by Gerry on Dec 13, 2004 2:40 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Ok I uninstalled .net Framework 1.1 and re-installed it. AND YES, it does remove the ASPNET account upon uninstall and adds it again on install. I checked that.

I then uninstalled Reporting services (what a risk I took!) and re-installed it. And voila! it worked !!

My last intsllation gave me lot of problems. So I was quite hesitant to do it all over again. But like you said I checked the ASPNET account before re-installing RS and it didn't give me any errors....Phew!

I still have to install sample and change the config files..(what a pain that is)..let me try that now.

Thanks a ton Gerry!
Left by RJ on Dec 13, 2004 4:03 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Glad you got it working RJ.

Anytime I get errors like that on an install and when things go awry, an uninstall and reinstall is the first thing I do. That way, I am back at a known state.

Some fun huh? :-)

Gerry
Left by Gerry on Dec 13, 2004 4:06 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Ok I uninstalled .net Framework 1.1 and re-installed it. And YES it DOES remove the ASPNET account on uninstall and adds it again on re-install. I checked that.

Then I uninstalled Reporting services (that was a risk as I had lot of errors when I last installed it!) and re-installed RS Developer edition. And Voila! it worked !! Phew!

I think if you have ASPNET account in addition to other prerequisites, RS installation goes well. Touche!

I will now download and try to install the sample Forms auth..hope it works!! Thanks Gerry for your help so far.
Left by RJ on Dec 13, 2004 4:09 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
no fun that !! oops posted my message twice. will try to install sample now.
Left by RJ on Dec 13, 2004 5:11 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
OK no Luck ! :( After all the various re-installations my sample app is still not working. I modified all config files. and did all the steps mentioned.

I get following error on typing http://localhost/reports

Object Reference not set to an instance of an object.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


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



I don't know where to look..

Since my sql server is local, I modified the connectionstring in the sample example. Whereever it said Server=localhost - I changed it to Server=(local).

But I am getting the same error before and after the above change.

Anything to do with security/permissions ??
Left by RJ on Dec 13, 2004 5:24 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
One more question, related to reporting Services but not related to the Forms Auth Sample.

I want to create a web page which will list all the reports created using Reporting services. BUT I DO NOT want to use the Reports manager interface to view the reports. How can customize and show list of reports. I would also like to use the Forms authentication security thereby allowing users to view and access only those reports they have permission on.

I would like this to be part of my web portal.
Left by RJ on Dec 13, 2004 7:53 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Just framing above question again.

I too need to have a single sign-on for my web portal and reports created in Reporting Services. Once a user is authenticated in the web portal and wants to view Reports he should not be asked to sign on again.

I do not want to use integrated windows security but use Forms Authentication for both my web portal and reports with single signon for both.

How do I use both ASP.net forms authentication and the custom security extension of REporting services.

Please help.
Left by RJ on Dec 13, 2004 9:33 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
You will need to ensure that all reports that you want to use in your application are stored in a folder of your web application with a web.config file that has Forms set for authentication. That way, all reports will be protected by the forms authentication mechanism you specify. Ensure that the web site properties in IIS have anonymous authentication only and not integrated.

You will have to also ensure that you place the <deny users="?"> in your authentication section as well in web.config.

As for your earlier post about the object not set to a reference, it may be as a result of authentication failure. As you can see in your stack trace, the AuthenticateRequest was the last method call made prior to the exception. I would assume that security is still an issue as of right now.

Verify the web.config and permissions settings in the web site properties.

Also, you should leave localhost in your connection string instead of (local). The latter will cause Shared Memory Provider errors.

Gerry
Left by Gerry on Dec 14, 2004 8:43 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Thanks Gerry.

I was looking into permission settings in web site properties. I have read that there should be a IUSR_machinename (since I will be using local IIS it will be my computername) user account which IIS uses to impersonate. But I do not see this account on my machine. http://www.asp101.com/tips/index.asp?id=5

Instead I see IUSR_remoteservername (which was a remote IIS server I was accessing initially)

Could, not having a IUSR_machinename be a problem ? (In IIS directory security i have used localmachinename\ASPNET as the username and enabled anonymous authentication.)

Left by RJ on Dec 14, 2004 11:12 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
That account is used for anonymous access. It may be a part of your problem yes.

Gerry
Left by Gerry on Dec 14, 2004 12:16 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Now, this one has me stumped. I am looking at my machine.config file right now and what you have on line 258 is valid and correct in format.

Once again though, it appears to be an authentication issue due to the error message that states "Execution permission cannot be acquired".

I just don't know. There are too many variables to deal with now. I know that after my fixes as mentioned earlier on in the thread, mine, and others have worked.

Sorry

Gerry
Left by Gerry on Dec 15, 2004 12:44 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I know, it seems to work for everyone here. But Thanks a lot for all the help. The postings here really helped me.

I checked the event viewer. And this is the error I see.

Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start()
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

I checked error log, doesn't say any error there.
Left by RJ on Dec 15, 2004 2:44 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Well I missed out a log file in Reporting Services directory and that one showed foll error. Posting it here, just in case someone has a clue.

ReportingServicesService!servicecontroller!26c!12/15/2004-11:34:14:: e ERROR: Exception caught loading and setting code permissions policy level: System.ArgumentException: Error "Invalid syntax on line 140." occurred while parsing the AppDomain policy level. The default policy level was used instead.
Left by RJ on Dec 15, 2004 3:03 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I have question related to ASP.Net Forms Authentication. How granular can Forms Authentication get ???

I need to check permissions of logged in User and accordingly enable/disable menu Items, buttons etc. How can I do it using Forms Authentication ?
Left by RJ on Dec 20, 2004 3:14 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
You will likely have to pass the information in a session state of some sort. Depending mostly on how you are maintaining state in your app.

You can use session state to maintain the information for each particular user. You will then need to validate based on that information.

Gerry
Left by Gerry on Dec 21, 2004 9:50 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Thinking about forms authentication and report server ...

cant we just put a shortcut into reporting services to point to our web folder ie mywebapp\reports and controlaccess to reports with the normal site folder authentication ?

Colin
Left by Colin robinson on Jan 06, 2005 6:26 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I once thought as you do. :-)

Sorry, bad humor.

I tried that at first as well, placing a web.config file in the reports folder with the authentication section set to forms but couldn't get it to work right until I implemented everything in this article.

I think it has to do with Reporting Services' default authentication mechanism. I hadn't really researched it further than implementing the code in the article.

Now, after almost 6 months absence from the project that required it, I will have to get back into it as the project was only put on hold for the short term.

Once I get a spare moment, I will look at it in some more detail again. I do agree with you though, it should be rather simple to implement.

Gerry
Left by Gerry on Jan 07, 2005 8:44 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Please help.
I am getting following error:
Parser Error Message: Execution permission cannot be acquired.

Source Error:


Line 22: <assemblies>
Line 23: <clear />
Line 24: <add assembly="ReportingServicesWebServer" />
Line 25: </assemblies>
Line 26: </compilation>

when executing http://localhost/reportserver/reportservice.asmx.
Many thanks in advance.

Lee
Left by Lee Tran on Jan 20, 2005 12:26 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
What type of authentication are you using? Forms? Integrated?

This error message can mean that you do not have the appropriate authentication permissions configured on the server or for Reporting Services.

Are you trying to use the forms authentication model as the MSDN article discusses?

Gerry
Left by Gerry on Jan 20, 2005 8:44 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Gerry,
Yes, I am trying to get the example from MSDN(Using Forms Authentication in Reporting Services) to work. I resolved the problem. I was tinkering with rssrvpolicy.config file. I was confused by the <CodeGroup> tags and tried to re-arrange them by matching pairs without realising they were intended to be nested. However I am getting a different problem.
<META Name='StackTrace' CONTENT='System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---&gt; System.Security.SecurityException: Request for the permission of type System.Web.AspNetHostingPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.
at Microsoft.Samples.ReportingServices.CustomSecurity.AuthenticationExtension.GetUserInfo(IIdentity&amp; userIdentity, IntPtr&amp; userId)
at Microsoft.ReportingServices.WebServer.ReportingService..ctor()

I granted Full Access to Microsoft.Samples.ReportingServices.CustomSecurity.dll and did not solve the problem. Do I need to strong-name and put it in the GAC?

Many thanks for your reply.
Lee
Left by Lee Tran on Jan 20, 2005 6:35 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Hi Everyone !

I am learning the reporting server components at the moment. However when i try to run the logonUser method as a sample in this website : http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_lz_3d7q.asp

I have the problem of " incorrect edition of reporting service error " Anyone who knows how to go about solving this?

Regards
Alvin
Left by Alvin on Jan 23, 2005 7:39 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Dear All , I have encountered this problem , i dun understand why this cant work . I have tried the suggested issues infront but it still cant seem to work .


Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


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



Left by alvin on Jan 26, 2005 3:06 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Hi Everyone !

I manage to get the sample to work . However i have a query . Why do we have a register user button in the log in page for reportserver ? Is that necessary?


Thanks and regards
Alvin
Left by alvin on Jan 27, 2005 5:23 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Alvin, glad you got it working.

As for the register user button, that is so you can have new users register on the site without requiring an administrator to set up accounts etc.

Gerry
Left by Gerry on Jan 27, 2005 8:46 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Hi Gerry !

Thank you for your reply .

I have another query : Is it possible to customize the main page of the report manager to another own customized interface? Is it through the .css file in report server folder?

Regards
Alvin
Left by alvin on Jan 28, 2005 5:19 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Hmmm, good question. I haven't looked at doing that but I suppose you could.

Gerry
Left by Gerry on Jan 28, 2005 8:40 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Hi Gerry !

i believed theres some restriction with regards to customizing the main page of the reporting manager. I have another query , is it possible to just retrieve the reports from the report server using our very own web application?

Regards
Alvin
Left by alvin on Feb 02, 2005 9:37 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Glad you like it. Hope it helped.
Left by Gerry on Feb 18, 2005 3:32 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Based on the article on MSDN;

"Note The scheduling engine used with Reporting Services requires SQL Server QFE 859 in order to run on a Windows Server 2003 computer using the Network Service account. Until the SQL Server QFE is installed, you will not be able to choose the Network Service built-in account during setup. To download the QFE, go to Microsoft Support. Note that after you install the hotfix, you cannot rename columns in Enterprise Manager. Consider using a different account if you do not want to apply the hotfix."

So it is mainly used for the scheduling engine. If you have installed Reporting Services to use the Network Service account, then yes, you should install the update.

One thing I would verify as well is to ensure the user account you created has actually been added to the logins for the DB. Double check that in the Reporting Services DB.

Gerry
Left by Gerry on Feb 22, 2005 8:51 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Thank you for your answer ,My Problem is resolved. The SSL is not necessary.
Left by spyer on Feb 28, 2005 11:44 PM

# Problem with 'text/html; charset=utf-8'
Requesting Gravatar...
I have a very similar problem Gaurav Shah had.

That is, when I access the http://[servername]/reports and key in username and password, I get:
-------------------------------------------------------------
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: --

Reporting Services Error
--------------------------------------------------------------
Anybody can shed some light on this? Thanks
Left by Michael on Mar 05, 2005 10:55 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I am getting the same error
Left by Lindsay on Mar 16, 2005 6:17 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Left by tetsuoshima on Mar 18, 2005 7:28 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I am having exactly the same problem as Eugene has here [Re: 7/30/2004 5:32 PM Eugene K ].
I can login through ReportServer and see my reports. I can see the login page for ReportManager, but when I login here nothing happens (the page is just redirected to UILogin.aspx). I've debugged it and the login is working and validating, but when it goes to do the redirect it just comes back up with the login page again.

Any ideas?

Thanks

Lyn
Left by Lyn Q on Apr 07, 2005 8:30 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I have tried a few times but I cannot reproduce the bahaviour you two are experiencing. I have no issues with the login at all.

Gerry
Left by Gerry on Apr 07, 2005 8:40 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I am gettng the following error please help me out

Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[NullReferenceException: Object reference not set to an instance of an object.]
Microsoft.Samples.ReportingServices.CustomSecurity.Logon.InitializeComponent() in d:\program files\microsoft sql server\mssql\reporting services\samples\extensions\formsauthenticationsample\logon.aspx.cs:63
Microsoft.Samples.ReportingServices.CustomSecurity.Logon.OnInit(EventArgs e) in d:\program files\microsoft sql server\mssql\reporting services\samples\extensions\formsauthenticationsample\logon.aspx.cs:57
System.Web.UI.Control.InitRecursive(Control namingContainer) +241
System.Web.UI.Page.ProcessRequestMain() +189




--------------------------------------------------------------------------------
Left by Rodoyo on Apr 13, 2005 4:18 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Have you verified that the user account you are using to logon does in fact exist in the Reporting Services user accounts?

If your account doesn't have the appropriate permissions, you can see this error becuase the appropriate objects do not instantiated on the server.

Gerry
Left by Gerry on Apr 13, 2005 9:05 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I am getting the following error:

Unable to communicate with report server. Please verify that the report server is operational.

when I try to implement the MSDN article...can somebody post the solution here how to get it to work pls.


Thanks
Left by Vijay on Apr 15, 2005 1:04 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
You're not providing very much information in your post to help us help you.

Have you verified that SQL Server is running?

Have you verified that IIS is running?

Have you verified the site that Reporting Services is using is running?

If you can provide more information as to where you are specifically in the article, it might also help.

Gerry
Left by Gerry on Apr 15, 2005 1:08 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
hello Gerry,

thanks for trying to help me...here is the thing:

I am trying to get the CustomSecurity example to work. I followed all the instructions listed in the MSDN article and then when I try to open the report manager in the web browser I got this error page and the message says 'Unable to communicate with the report server.

I did check the sql server and the web site...and they both are running.

Left by Vijay on Apr 15, 2005 7:01 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I got the same error message "provider loaded failure" when I tried CustomSecurity. I did everything the MSDN artical listed. I checked log file but there was none for this instance (I did see log file for restaring report server service)
Left by MW on Apr 27, 2005 10:46 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I am also getting the same error message "provider loaded failure" when I tried CustomSecurity. Can someone post a solution on this.
Left by Hari on May 24, 2005 2:21 AM

# custom security
Requesting Gravatar...
hi
hello sir,
i was unable to communicate the web services so pls help me
if any one has worked on custom sercurity on web pls mail me at
krs_jagan@hotmail.com
Left by jagan on Jun 03, 2005 7:09 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Hi Gerry:

I was able to get the forms authentication customer security exension up and running fairly quickly. Do you know if anyone was able to get an asp.net application with sql reporting services to work in a "single sign on" scenario. For example, user signs on to web application and is not prompted to sign on again when accessing sql reporting services reports. Any guidance is appreciated.

Regards,
Rob.
Left by Rob on Jul 08, 2005 12:00 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Hi all,
After setting up the security sample app for reporting services and finding some errors I've done in config files I still can't make it work.
After fill in the login form I get almost empty page with just header and no controls except Home, My subscriptions and Help... Looks like permission problem but my users' rights are set to Content Manager. Furthermore I have Everyone permission set but nothing happens. Does anyone know what's wrong?
Thanks,
Georg
Left by Georg on Jul 18, 2005 8:23 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Server Error in '/SampleApplication' Application.
--------------------------------------------------------------------------------

Configuration Error
Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Required attribute 'key' not found

Source Error:


Line 2: <configuration>
Line 3: <appSettings>
Line 4: <add Key="ConnString" value="Data Source=localhost;Initial Catalog=Malarvannan;User Id=test;Password=test;trusted_connection=true;"/>
Line 5: </appSettings>
Line 6:


Source File: c:\inetpub\wwwroot\SampleApplication\web.config Line: 4


--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.0.3705.0; ASP.NET Version:1.0.3705.0
Left by Malarvannan on Aug 26, 2005 3:31 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I think I had the same problem as you guy's. The way I resolved this was to un-install Reporting Services and Re-install. When I got to the part in the install where it asked me for SQL Server Credentials, I chose my domain account instead of what is offered as a default. This worked for me so I thought I should share it
Left by Gerry Whitworth on Sep 29, 2005 6:32 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I've implemented the Microsoft example, and the login.aspx does show, but after I click the logon button the redirect doesn't seem to work. I tried the debugger but everything seems to work fine: the authentication does succeed and the line:
FormsAuthentication.RedirectFromLoginPage(
TxtUser.Text, false);
Is reached, but doesn't do anything.

Any suggestions would be greatly appreciated. Thanks.
Left by Stefan on Oct 12, 2005 5:19 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I have configured my Reporting Server to use forms authentication and Report Manager and Report Server present the Logon form and allow access to reports on presenting valid credentials. The problem is that when I try to logon to the web service using LogonUser passing the same credentials, I get the following error:

Logon Failed Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'

I have tried specifying my domain account in the Report Server windows service and restarted the service also. My domain account is also an administrator on the Windows 2003 server. I have installed Reporting Services 2000 Enterprise Edition with SP1. Can somebody help?
Left by Ravi on Dec 27, 2005 10:28 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Hopefully someone has solved the issue of the Logon page running successfully but redirect to Folder.aspx not happening - as per several unanswered posts here.

To clarify:

>I get the logon page

>My user has been registered ok (i have checked the entry in the db to make sure it was created)

>I enter the un & pass correctly and page posts back

The redirect never happens - Ie it never leaves the UILogon.aspx

Using Win2003, SQL Server 2000 Std., Reporting Services - Dev Edition

Any help greatly appreciated


Left by Richard on Feb 12, 2006 5:09 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I am having the same problem, Richard has that I cannot get past the UILogon.aspx page in the Report Manager.
Have a feeling that the redirection is happening, but when it gets to the Folder.aspx page, the cookie or session is not being recognized and hence redirect back to the UILogon.aspx.

Any suggestion is greatly appreciated.

Thanks
Left by Shesh on Feb 28, 2006 7:22 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I have the same problem as Shesh, I unbale to redirect to the Folder.aspx, it shows the page not found error for me.

Can anyone help??

Thanks a lot.
Left by LingLing on Mar 08, 2006 9:25 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I manage to redirect to Folder.aspx. Instead of using localhost , type in servername
eg . http://<servername>/reports

It works ..
Left by CTDino on Mar 09, 2006 10:34 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
And remember to use the correct version of ReportService webservice in order to get te thing work.
Left by CTDINO on Mar 09, 2006 10:36 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I'm getting the error at the time i run the sample in
<%@ Page language="c#" CodeFile="Logon.aspx.cs" AutoEventWireup="false" Inherits="Microsoft.Samples.ReportingServices.CustomSecurity.Logon,Microsoft.Samples.ReportingServices.CustomSecurity" %>
Microsoft.Samples.ReportingServices.CustomSecurity.Logon,Microsoft.Samples.ReportingServices.CustomSecurity is not a valid value


Left by Bhansali on Mar 12, 2006 7:16 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Hi CTDino,

I am following the suggestions you made. The scenario I am working with is that the Systems department does not want to expose the ReportManager in the DMZ box, so I have installed the ReportServer on the DMZ box(Windows 2003) and the ReportManager on a box behind the firewall(Windows 2000). AM NOT USING LOCALHOST and AM CONFIGURING THE WEBSERVICES correctly.
THIS SCENARIO IS NOT WORKING.
Just to be sure that its not WMI thats killing it, I hard coded the URL for the ReportServer web service in AuthenticationUtilities.cs.

I have both ReportManager and ReportServer on my Developement box(Windows 2000) and its working just fine.

Any more suggestions?

Thanks



Left by Shesh on Mar 14, 2006 4:01 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I made it pretty far but when I logon to http://localhost/reports I get the following error: Key cannot be null. Parameter name: key. I do get the reporting services screen. I am also using Windows 2003.

Thanks for any help,
Tom
Left by TomO on Mar 29, 2006 4:21 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I am working now the key error was I believe since I generated the key on the server and not the PC that I was using to compile the code.
Left by TomO on Mar 30, 2006 2:21 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Howdy. We are using forms authentication and can get to the ReportManager and ReportService websites.

We do have a problem getting the Reporting Services web methods to run, for example: ListChildren(), GetReportParameters().

When code attempts to execute one of these web methods we get an error that reads:

<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="/ReportServer/logon.aspx?ReturnUrl=%2freportserver%2fReportExecution2005.asmx">here</a>.</h2>
</body></html>

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

Our Reporting Services project has come to a grinding halt.

Can anyone help me with this?

Thank you, thank you.
Left by wall on Mar 30, 2006 10:32 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
... by the way, this is happening on a XP Pro SP2 box. We will be running on a Win2003 box, however.

Thanks.
Left by wall on Mar 30, 2006 10:34 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Yup ... I get exactly the same problem ... XP SP2.
Left by DaveMcK on May 04, 2006 10:26 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I have a possible solution but cannot seem to post it to this site.
Left by wall on May 05, 2006 9:01 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I am able to post this simple comment but not 85 lines of code?

No error message to tell me what I am doing wrong.

Sorry Dave. If you have a "throw away" email address that you don't mind posting here then I'll send you the code that worked for me.

-- wall
Left by wall on May 05, 2006 9:04 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
There have been quite a few posting where people say their UILogin.aspx page works fine yet the redirect fails with no error, just simply posts back. I too have this problem...have yet to see anybody een address the issue. Must be a common problem for this many people to have the same issue.

I agree with whoever said that it probably is getting redirected to Folder.aspx but is getting sent right back due to persmissions.

I have debugged the UILogin.aspx page and everything works fine, including the line:

server.LogonUser(TxtUser.Text,TxtPwd.Text, null);

However, the line:

HttpContext.Current.Response.Redirect("./Folder.aspx", false);

will simply not redirect to the Folder.aspx page. No errors, just clears out the username and pw boxes and stares back at you.

If ANYone has found a solution to this issue, or a way to verify wha the issue may be, pleeaazzzee let me know.

Also, I have Anon authetication setup on both the Reports an ReportServer directories.

Ready to give-up on this altogether as it's obviously extremely flaky.

Thanks,
Randy
Left by RandyB on May 08, 2006 7:32 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I have gottten a security extension to work on my development box, using the already in place Forms Authentication, redirtecting to that logon and using machine keys to share auth cookies. But when I try to get what works on my XP development machine working on the production web server on IIS 6.0 under Server 2003, the Report Manger starts complaining that it can't find the Report Server. There are two instances on this 2003 production machine. One is a stand along default install pretty much and this one is a full www.url.com/
Left by Kory on May 10, 2006 5:46 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Hi wall,

I met the same problem. Can you send me the code? Thank you very much.

Email address: receptive79@yahoo.com

--asite
Left by asite on May 12, 2006 6:08 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I had the same problem as those of you with the UILogin.aspx redirecting back to UILogin.aspx. The problem was I was putting http://localhost/reports instead of my machine name in the URL.
Left by Rick on Jun 08, 2006 7:10 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
This thread has been going on for almost 2 years now... Has anyone found a solution yet?

I am running SSRS enterprise 2005 on server 2003.

I was able to get the sample to work on my internal server following the sample but when I push to a dmz server it stops working.

Here is what happens:

When I go to http://{server}/reports I get the uilogon.aspx page. I am able to authenticate the user and am redirected to folders.aspx. Before folders.aspx receives my request the web server tries to confirm my authentication and fails so I am redirected back to uilogon.aspx.

For some reason
server.LogonUser(TxtUser.Text,TxtPwd.Text, null);
is not dropping the cookie.

Does anyone have any ideas?
Left by Chris on Jun 23, 2006 4:21 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
For passing the cookies you need to add the permission to RSWebApplication.config of ReportManager

<UI>
<CustomAuthenticationUI>
...
<PassThroughCookies>
<PassThroughCookie>cookiename1</PassThroughCookie>
<PassThroughCookie>cookiename2</PassThroughCookie>
</PassThroughCookies>
</CustomAuthenticationUI>
...
</UI>
Left by Sancpa on Jun 28, 2006 10:37 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I am having this same problem:
*********
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="/ReportServer/logon.aspx?ReturnUrl=%2freportserver%2fReportExecution2005.asmx">here</a>.</h2>
</body></html>

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

I have verified that my application and reportserver/report manager are sharing cookies but I still get this error when trying to run a report using the reportviewer control.

Has anyone found the solution?
Left by Vince on Jul 20, 2006 6:17 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I have an error while trying to implement forms authentication.

I am using Reporting Services 2005. Only documentation I can find is the example that has been used several times in this post. Even though the documentation refers to SS2000 it seems that SS2005 has the same configuration settings.

Using Forms Authentication I am able to successfully log into http://<server>/ReportServer. When I navigate to http://<server>/Reports I get an error.

Here is my stack trace:
[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

I have isolated the error to the web.config file in the ReportManager folder. When I set the authentication mode to Windows I am able to access the ReportManager. (This is the security setting that was skipped in the documentation.)

However, when I click on the report builder, the *only* time I am able to access the Report Builder is if I create a login with the exact username / password as a login that is on my network. If I use a random username/password, access is denied.

My suspicion is that I have accidentally set-up Basic Authentication but I don't know how to fully implement Forms Authentication.

I need Forms Authentication to work for Report Builder because people outside the network will access and create reports.

Thank-you for your help.
Left by Aaron on Aug 08, 2006 1:20 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Hi,

I have been playing with the original MS example for forms authentication and have almost got it working.

I can login to both reports and reportserver and can access all of the properties and security settings including setting up users and roles.

The problem I have run into is that when clicking on a report it doesnt seem to be passing the credentials and i receive the following error:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Logon failure: unknown user name or bad password.

Also can any one confirm that we cant use this on the standard addition, I am yet to try it but it would seem a very short sighted decision to not implement the functionality in the version most people are still running.

Regards

David
Left by Dave Casey on Aug 13, 2006 11:53 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I had similar problems using a different sample. I found that one of the things I was doing wrong was with regards to the placement of

<CodeGroup
class="UnionCodeGroup"
.......

within the rssrvpolicy.config file. The file has several nested CoddeGroup elements and you need to make sure that the one you add is nested inside the root code group:

<CodeGroup
class="FirstMatchCodeGroup"
......
>
<CodeGroup
class="UnionCodeGroup"
.......
/>
<!-- Other code groups -->
....
<!-- Other code groups -->
</CodeGroup>

After making this change things started working for me.
Left by Adam on Aug 17, 2006 3:35 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
here is a version of the article updated for RS 2005 http://msdn2.microsoft.com/en-us/library/ms160724.aspx
Left by Adam on Aug 17, 2006 4:55 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I edit custom security reporting services. I browse 'localhost/reportserver' that work but
'localhost/reports' that message error '
Unable to communicate with report server. Please verify that the report server is operational'

Thanks
Left by Help me! on Sep 27, 2006 4:39 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
The VB Code example doesnt work. I can compile the C# code, copy over the dll, and it works. I compile the VB code, copy the dll, and it's broken.

The logon.aspx and uilogin.aspx pages in the VB sample even specify the C# language in the header, so it looks like VB was a second thought, and wasn't even tested since published.

The error I got with the VB build was:

Key cannot be null. Parameter name: key.

Hope this helps someone. I wasted about a week and a half trying to get the stupid VB to work.
Left by kukabuka on Nov 08, 2006 7:21 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I got the error, Object reference not set to an instance of a object, on Report Manager when I tried to run a report after moving the RS databases to a new server, does anyone know the fix? Please help.

Thanks
Left by Tuong on Jan 25, 2007 2:31 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Sounds like an authentication error. Are you certain the correct user accounts are created and assigned correctly on the new server?
Left by Gerry on Jan 25, 2007 4:38 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
You may be right cause if I publish the same report again, and run the new version, it works perfectly. The ReportServer database was originally running in Forms Authenticaion mode, and since migrated over to the test server, I can't get it to work again.The authentication/access details from the database need to be retained in order to continue the service, and I don't know how to do it. Please help!

Thanks


Tuong

Thanks
Left by Tuong on Jan 26, 2007 6:19 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I just re-stored the ReportServer database and ran rsconfig, rskeymgmt, rsactivate. I set breakpoint in the user defined logon page (RMLogon.aspx) in the CustomSecurity project to debug the the Authentication process, then open Report Manager, I noticed that the LogonUser() method returned true ,and the client got redirected to Folder.aspx. But something happenned in the Folder page, which caused the service to redirect the client back to RMLogon.aspx. Can you please tell how to trap this error?

Thanks


Tuong
Left by Tuong on Jan 26, 2007 8:26 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Check the account that is being used by IIS to connect to the DB. Chances are it is using /<machinename>/anonymous. That may be your problem.
Left by Gerry on Jan 27, 2007 12:17 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Gerry,

Where can I check that?

Thanks
Left by Tuong on Jan 29, 2007 1:11 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Go into your original DB, verify the user account that had permissions for that particular DB. Then verify that account exists in the new DB and that it has been assigned the same permissions to the new DB.

You do that in SQL Server or whatever you backend DB is.
Left by Gerry on Jan 29, 2007 4:56 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
The VB Sample does not work. Just compile the C# example and copy the dll's over and it will work. Thank you for the advice.
Left by RSAdmin on Apr 21, 2007 11:37 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Tip: Building en CustomSecurity sample using .NET Framework 2.0 on one machine and then deploying it to a server where the Reporting Services are running under 1.1 also gives you the: 'Unable to communicate with report server. Please verify that the report server is operational' error. I fixed it by using the 2.0 framework on the server. This applies to RS 2000.
Left by Alex on Apr 29, 2007 4:03 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
For those of you who were having the problem of trying to access the ReportManager where the redirect did not work after successfull authentication on the UILogon.aspx page. I solved my problem by using the complete servername instead of simply localhost: http://[servername]/Reports/UILogon.aspx.
Left by mc on May 30, 2007 12:07 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I am having this same problem:
*********
<html><head><title>Object moved</title></head><body>
<h2>Object moved to here.</h2>
</body></html>

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

Has anyone found the solution?
Left by DS on Jul 17, 2007 2:21 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I use reportserver but not report manager. On win 2003 server it works, untill ssl certificate is installed, then it says file not found error when log in. however the namespace or file it seeks i cannot find. It works fone on xp with ssl, and on win server 2003 without ssl. only when ssl implemented does it prevent login. any ideas.
Left by Leon on Jan 24, 2008 2:33 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I am facing a problem with custom authentication when using SQL Report service's report server.
I want to add change password page to Logon.aspx page provided by custom security DLL.IS it possible?

When I try to redirect to some aspx page from logon.aspx, it is redirecting me back to login page. I don't want authentication to be done for changepassword.aspx.
If you have any solution, Please help me.
Left by Nayana.K on Jun 10, 2008 3:54 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I have been able to get the forms authentication to work 100%. The problem I'm having is using the report viewer control to access the reports. I pass a cookie and validate the user to use a predetermined username/password (which user never sees) but I receive the following error

The request failed with the error message: -- <html><head><title>Object moved</title></head><body> <h2>Object moved to here.</h2> </body></html> --.

although the following works perfectly fine
http://localhost/reportserver?/myreport - I just have to log in
Left by dw on Jul 02, 2008 3:39 PM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
Quite inspiring,

I got the error, Object reference not set to an instance of a object, on Report Manager when I tried to run a report after moving the RS databases to a new server, does anyone know the fix? Please help.


Thanks for bringing this up
Left by web development company on Aug 20, 2009 9:35 AM

# re: Trouble With MSDN Article on Reporting Services
Requesting Gravatar...
I have also having the issue where I have the login.aspx working and authenticating but I get "Input string was not in a correct format." "Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:" and wondered if anyone has come up with a solution - I noticed an msdn article in this post but it no longer exists :(

Any help would be greatly received as this appears to be one problem after another.

Regards

Adam Perkins

PS I am using SSRS 2008 on a Vista Test machine with VS 2008
Left by Adam on Jul 15, 2010 5:33 AM

Your comment:
 (will show your gravatar)


Copyright © Gerry O'Brien | Powered by: GeeksWithBlogs.net