Blog Stats
  • Posts - 19
  • Articles - 0
  • Comments - 58
  • Trackbacks - 261

 

<< Trouble With MSDN Article on Reporting Services | Home | DataGrid TableStyles Oddity >>

Trouble With MSDN Article on Reporting Services

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.

Print posted @ Thursday, July 15, 2004 6:06 AM

Feedback

# re: Trouble With MSDN Article on Reporting Services

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.

7/16/2004 9:40 AM | Derick Bailey

# re: Trouble With MSDN Article on Reporting Services

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 7/16/2004 10:17 AM | Gerry O'Brien

# re: Trouble With MSDN Article on Reporting Services

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!
7/21/2004 12:53 PM | Ashima Dua

# re: Trouble With MSDN Article on Reporting Services

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 7/21/2004 1:19 PM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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 7/23/2004 3:56 AM | PMac (UK)

# re: Trouble With MSDN Article on Reporting Services

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 7/23/2004 7:52 AM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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 7/29/2004 4:25 PM | Nick Pagano

# re: Trouble With MSDN Article on Reporting Services

Gravatar That was never an issue. The article already listed those as steps to complete and they were.

Thanks for the suggestions though.

Gerry 7/29/2004 4:30 PM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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? 7/30/2004 4:43 PM | Eugene K

# re: Trouble With MSDN Article on Reporting Services

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 7/30/2004 5:32 PM | Eugene K

# re: Trouble With MSDN Article on Reporting Services

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 7/31/2004 11:40 AM | Gerry

# re: Trouble With MSDN Article on Reporting Services

Gravatar Did anyone have the pleasure of finding out that forms authentication is not supported on the standard edition. After hours of research and getting the stupid example to work only to receive a message that says operation not supported with version. 8/10/2004 5:11 PM | Jeff

# re: Trouble With MSDN Article on Reporting Services

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 8/17/2004 8:41 AM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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. 11/25/2004 7:41 AM | DaveSemm

# re: Trouble With MSDN Article on Reporting Services

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 11/25/2004 8:44 AM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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 12/3/2004 7:46 AM | Gerry

# re: Trouble With MSDN Article on Reporting Services

Gravatar I'm using Standard Edition of SQL Server. Is it necessary to use Enterprise Edition for Form Authentication method ?


Gaurav. 12/4/2004 12:00 AM | Gaurav Shah

# re: Trouble With MSDN Article on Reporting Services

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 12/6/2004 12:50 PM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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. 12/7/2004 12:24 AM | Gaurav Shah

# re: Trouble With MSDN Article on Reporting Services

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 12/7/2004 8:32 AM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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.

12/13/2004 11:39 AM | RJ

# re: Trouble With MSDN Article on Reporting Services

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 12/13/2004 1:53 PM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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 ???

:(

12/13/2004 1:04 PM | RJ

# re: Trouble With MSDN Article on Reporting Services

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 ?? 12/13/2004 1:15 PM | RJ

# re: Trouble With MSDN Article on Reporting Services

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 12/13/2004 1:16 PM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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. 12/13/2004 1:16 PM | RJ

# re: Trouble With MSDN Article on Reporting Services

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 12/13/2004 2:19 PM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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. 12/13/2004 1:36 PM | RJ

# re: Trouble With MSDN Article on Reporting Services

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 12/13/2004 2:40 PM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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 ??
12/13/2004 2:25 PM | RJ

# re: Trouble With MSDN Article on Reporting Services

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 ??

12/13/2004 3:30 PM | RJ

# re: Trouble With MSDN Article on Reporting Services

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 12/13/2004 2:40 PM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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! 12/13/2004 4:03 PM | RJ

# re: Trouble With MSDN Article on Reporting Services

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 12/13/2004 4:06 PM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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. 12/13/2004 4:09 PM | RJ

# re: Trouble With MSDN Article on Reporting Services

Gravatar no fun that !! oops posted my message twice. will try to install sample now.
12/13/2004 5:11 PM | RJ

# re: Trouble With MSDN Article on Reporting Services

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 ?? 12/13/2004 5:24 PM | RJ

# re: Trouble With MSDN Article on Reporting Services

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. 12/13/2004 7:53 PM | RJ

# re: Trouble With MSDN Article on Reporting Services

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.
12/13/2004 9:33 PM | RJ

# re: Trouble With MSDN Article on Reporting Services

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 12/14/2004 8:43 AM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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.)

12/14/2004 11:12 AM | RJ

# re: Trouble With MSDN Article on Reporting Services

Gravatar That account is used for anonymous access. It may be a part of your problem yes.

Gerry 12/14/2004 12:16 PM | Gerry

# re: Trouble With MSDN Article on Reporting Services

Gravatar ok I got the proper IUSR_localmachinename etc

I get following error on running the sample now

Server Error in '/Reports' 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: Execution permission cannot be acquired.

Source Error:


Line 256: <add assembly="System.EnterpriseServices, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 257: <add assembly="System.Web.Mobile, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 258: <add assembly="*"/>
Line 259: </assemblies>
Line 260:


Source File: c:\windows\microsoft.net\framework\v1.1.4322\Config\machine.config Line: 258
12/15/2004 12:00 PM | RJ

# re: Trouble With MSDN Article on Reporting Services

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 12/15/2004 12:44 PM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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. 12/15/2004 2:44 PM | RJ

# re: Trouble With MSDN Article on Reporting Services

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.
12/15/2004 3:03 PM | RJ

# re: Trouble With MSDN Article on Reporting Services

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 ?
12/20/2004 3:14 PM | RJ

# re: Trouble With MSDN Article on Reporting Services

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 12/21/2004 9:50 AM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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 1/6/2005 6:26 PM | Colin robinson

# re: Trouble With MSDN Article on Reporting Services

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 1/7/2005 8:44 AM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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 1/20/2005 12:26 AM | Lee Tran

# re: Trouble With MSDN Article on Reporting Services

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 1/20/2005 8:44 AM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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
1/20/2005 6:35 PM | Lee Tran

# re: Trouble With MSDN Article on Reporting Services

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 1/23/2005 7:39 PM | Alvin

# re: Trouble With MSDN Article on Reporting Services

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



1/26/2005 3:06 AM | alvin

# re: Trouble With MSDN Article on Reporting Services

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 1/27/2005 5:23 AM | alvin

# re: Trouble With MSDN Article on Reporting Services

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 1/27/2005 8:46 AM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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 1/28/2005 5:19 AM | alvin

# re: Trouble With MSDN Article on Reporting Services

Gravatar Hmmm, good question. I haven't looked at doing that but I suppose you could.

Gerry 1/28/2005 8:40 AM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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 2/2/2005 9:37 PM | alvin

# re: Trouble With MSDN Article on Reporting Services

Gravatar Glad you like it. Hope it helped. 2/18/2005 3:32 PM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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 2/22/2005 8:51 AM | Gerry

# re: Trouble With MSDN Article on Reporting Services

Gravatar Thank you for your answer ,My Problem is resolved. The SSL is not necessary. 2/28/2005 11:44 PM | spyer

# Problem with 'text/html; charset=utf-8'

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
3/5/2005 10:55 AM | Michael

# re: Trouble With MSDN Article on Reporting Services

Gravatar I am getting the same error 3/16/2005 6:17 PM | Lindsay

# re: Trouble With MSDN Article on Reporting Services

Gravatar This is a known problem : see http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rserrors/htm/Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings_rsOperationNotSupported.asp

This is because the standard edition does not support this feature :( 3/18/2005 7:28 AM | tetsuoshima

# re: Trouble With MSDN Article on Reporting Services

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 4/7/2005 8:30 AM | Lyn Q

# re: Trouble With MSDN Article on Reporting Services

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 4/7/2005 8:40 AM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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




--------------------------------------------------------------------------------
4/13/2005 4:18 AM | Rodoyo

# re: Trouble With MSDN Article on Reporting Services

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
4/13/2005 9:05 AM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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
4/15/2005 1:04 PM | Vijay

# re: Trouble With MSDN Article on Reporting Services

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 4/15/2005 1:08 PM | Gerry

# re: Trouble With MSDN Article on Reporting Services

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.

4/15/2005 7:01 PM | Vijay

# re: Trouble With MSDN Article on Reporting Services

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) 4/27/2005 10:46 AM | MW

# re: Trouble With MSDN Article on Reporting Services

Gravatar I am also getting the same error message "provider loaded failure" when I tried CustomSecurity. Can someone post a solution on this. 5/24/2005 2:21 AM | Hari

# custom security

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 6/3/2005 7:09 AM | jagan

# re: Trouble With MSDN Article on Reporting Services

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. 7/8/2005 12:00 PM | Rob

# re: Trouble With MSDN Article on Reporting Services

Gravatar Greetings Gerry and everyone,

We're trying to implement single-sign-on in an ASP.Net application that uses the Microsoft sample ReportViewer. We want URL addressability for the reports so we can use interactive features, primarily drilldown. We stuck the ReportViewer in a "report launcher" page that provides ASP.Net controls for selecting parameters.

After logon, the user is directed to a "report menu" page. When the user selects an item from the menu, we redirect to the report launcher, passing the report ID in Session.

Running the app in Sleuth 1.4.2 you can see that the RS session auth cookie is never generated by our app, although I THINK we're doing everything in the MS sample Logon.aspx and UIlogon.aspx pages. When you run the MS sample logon pages you can see that the cookie is sent to the client after several calls to SetConfiguration (in Authorization.cs). In our app we never get to SetConfiguration, generating the well-known "Object has moved" error first.

Help?
Thanks
--Mike 7/10/2005 5:27 PM | Mike

# re: Trouble With MSDN Article on Reporting Services

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 7/18/2005 8:23 AM | Georg

# re: Trouble With MSDN Article on Reporting Services

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 8/26/2005 3:31 AM | Malarvannan

# re: Trouble With MSDN Article on Reporting Services

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 9/29/2005 6:32 PM | Gerry Whitworth

# re: Trouble With MSDN Article on Reporting Services

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.
10/12/2005 5:19 AM | Stefan

# re: Trouble With MSDN Article on Reporting Services

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? 12/27/2005 10:28 PM | Ravi

# re: Trouble With MSDN Article on Reporting Services

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


2/12/2006 5:09 PM | Richard

# re: Trouble With MSDN Article on Reporting Services

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 2/28/2006 7:22 AM | Shesh

# re: Trouble With MSDN Article on Reporting Services

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. 3/8/2006 9:25 PM | LingLing

# re: Trouble With MSDN Article on Reporting Services

Gravatar I manage to redirect to Folder.aspx. Instead of using localhost , type in servername
eg . http://<servername>/reports

It works .. 3/9/2006 10:34 PM | CTDino

# re: Trouble With MSDN Article on Reporting Services

Gravatar And remember to use the correct version of ReportService webservice in order to get te thing work. 3/9/2006 10:36 PM | CTDINO

# re: Trouble With MSDN Article on Reporting Services

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


3/12/2006 7:16 PM | Bhansali

# re: Trouble With MSDN Article on Reporting Services

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



3/14/2006 4:01 AM | Shesh

# re: Trouble With MSDN Article on Reporting Services

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 3/29/2006 4:21 AM | TomO

# re: Trouble With MSDN Article on Reporting Services

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. 3/30/2006 2:21 AM | TomO

# re: Trouble With MSDN Article on Reporting Services