reportbuilder button not appearing

Hi Everyone,
I am not getting the reportbuilder button on the toolbar in report
server portal. I have implemented forms security on the reporting
services instance.
Can anyone please help me solve this problem?
Thanks in advance,
BharathHi All,
I got the resolution for this problem. I was implementing the sample
from SQL 2000 on an SQL 2005 platform. After implementing the forms
authentication using the sources from SQL 2005 the button is
appearing...
Bharath
bharath wrote:
> Hi Everyone,
> I am not getting the reportbuilder button on the toolbar in report
> server portal. I have implemented forms security on the reporting
> services instance.
> Can anyone please help me solve this problem?
> Thanks in advance,
> Bharath

ReportBuilder and Forms Authentication

We created a custom security extension for RS using Forms Authentication. The issue I am having is in ReportBuilder when the forms authentication ticket expires. Forms auth will attempt to redirect (send a HTTP 302) and the report builder will show the error message "Object moved to here" instead of prompt for credentials. I have been watching the IIS logs and I see the first time report builder start it attempt to connect using default windows credentials and after the FormsAuthenticationRequired exception it will prompt for credentials and invoke LogonUser method, but this only happens the first time or if change the server in the url. I was expecting ReportBuilder to consider the Forms Authentication expiration at any time.

Do you have any idea how to work around this?

Any help is really appreciated.

Thanks

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

RS using FBA deletes a cookie that is used in authenticating user. The fix is available on request( not released officially)
|||

Thanks for your response. I saw this fix before writing in this forum. (I found it here http://support.microsoft.com/kb/939942/ ) What I am concerned is that it is touching only the sharepoint dll. I am not using sharepoint. I do not even have RS configured for sharepoint integration. I am using Forms Authentication in the ReportServer and ReportBuilder displays the "object moved" error when the authentication ticket expires and gets a HTTP redirect while requesting a method in the web service after ticket expired. I suspect this is a bug. To workaround this I had to increase the timeout of the forms authentication in the web.config for ReportServer to 48 hours.

However if a user keeps a report open in the ReportBuilder application for more than 48 hours the changes will be lost because he will get the error and will not be able to save the changes. I think this is a bug. Microsoft has been saying Reporting Service 2005 supports Forms Authentication thru a custom security extension but I am not sure they have tested properly.

I have been inspecting the code for ReportBuilder application using .net Reflector and I noticed it prompts for credentials only when the main form is loaded and the first attemp using default Network Credentials fails because Forms Authentication is required. Then the LogonUser is invoked and the authentication cookie is created. However if this cookie expires they never attempt to connect again unless the server path change. In my opinion this is wrong. They should be consistent with the forms authentication and prompt for credentials again.

Increase the timeout in my opinion is a workaround but not the solution. If I am wrong and someone knows the answer to this, please, I will really appreciate it. In the other hand, I will try to get this fix for sharepoint. Maybe it will consist in more than sharepoint dll and it will "automagically" fix the issue

Thanks for your reply.

Report Viewer and Forms Authentication

Hello All,
I'm using forms authentication on Reporting Services with no worries but I'm having trouble getting Report Viewer authenticating from a web page.
I've found a example in C# (I think) but being a VB user it's proving a little difficult.
http://blogs.msdn.com/bimusings/archive/2005/11/04/489100.aspx
Has anyone an example of this in VB or could provide a way of converting the out statement/argument into something VB might accept?

public bool GetFormsCredentials(out Cookie authCookie,
out string user, out string password, out string authority)
{
authCookie = m_authCookie;
user = password = authority = null;
return true; // Use forms credentials to authenticate.
}
Cheers

Public Function GetFormsCredentials(ByRef authCookie As System.Net.Cookie, ByRef user As String, ByRef password As String, ByRef authority As String) As Boolean

authCookie = m_authCookie

user = password = authority = Nothing

Return True

End Function

|||Yeah, that's what I ended up with too, but thanks
Is there any funky trick with implementing Microsoft.Reporting.WebForms.IReportServerCredentials? I'm getting an error "Implenting property must have matching 'ReadOnly' or 'WriteOnly' specifiers". Following the code from the blog, there are ReadOnly properties for both ImpersonationUser and NetworkCredentials, but adding the matching WriteOnly properties doesn't make it all happy.
I must be missing something somewhere but I've been looking at it too long.

Report Server errors in Form Authentication example

Hi there:-
Anyone have any ideas on this one'
I was trying to implement the Form Authentication example (Using Forms
Authentication in Reporting Services) from the MSDN but I am keep getting
this error message â'rsFailedToDecryptConfigInformationâ'.
I followed all the necessary steps from the example to set up both Report
Server and Report Manager and ran the sql script to generate the
â'UserAccountâ' databasae. I have been able to generate two users from the
â'UILogon.aspxâ' page by pressing the â'Registerâ' button. But when I tried to
logon with the â'Logonâ' button. The same error message would appear.
The actual error message:-
Reporting Services Erro
----
The encrypted value for configuration setting Dsn cannot be decrypted.
(rsFailedToDecryptConfigInformation) Get Online Help
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
----
Microsoft Reporting Services
I also did a check on the Report Server Service by right click to â'Restartâ'
it from the Administrative Tools à Services and an error message appear:-
â'Could not start the ReportServer service on Local Computer. The service did
not return an error. This could be an internal Windows error or an internal
service error. If the problem persists, contact your system administrator.â'
I know the Report Server and Report Manager were running properly before I
changed the setup to Form Authentication. So what else do I need to change'
Or how do I fix the Report Server?
Thanks for reading this message.It sounds like something in your RS configuration got corrupted -- perhaps
the setting for the Report Server database. You can check the log files and
event log for more clues, and look here:
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/search?group=microsoft.public.sqlserver.reportingsvcs&q=rsFailedToDecryptConfigInformation&qt_g=1
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Help" <Help@.discussions.microsoft.com> wrote in message
news:92DCE258-975D-4DCF-B705-7E1B05FF7985@.microsoft.com...
> Hi there:-
> Anyone have any ideas on this one'
> I was trying to implement the Form Authentication example (Using Forms
> Authentication in Reporting Services) from the MSDN but I am keep getting
> this error message "rsFailedToDecryptConfigInformation".
> I followed all the necessary steps from the example to set up both Report
> Server and Report Manager and ran the sql script to generate the
> "UserAccount" databasae. I have been able to generate two users from the
> "UILogon.aspx" page by pressing the "Register" button. But when I tried to
> logon with the "Logon" button. The same error message would appear.
> The actual error message:-
>
> Reporting Services Error
> ----
> The encrypted value for configuration setting Dsn cannot be decrypted.
> (rsFailedToDecryptConfigInformation) Get Online Help
> An internal error occurred on the report server. See the error log for
> more
> details. (rsInternalError) Get Online Help
> ----
> Microsoft Reporting Services
> I also did a check on the Report Server Service by right click to
> "Restart"
> it from the Administrative Tools à Services and an error message appear:-
> "Could not start the ReportServer service on Local Computer. The service
> did
> not return an error. This could be an internal Windows error or an
> internal
> service error. If the problem persists, contact your system
> administrator."
> I know the Report Server and Report Manager were running properly before I
> changed the setup to Form Authentication. So what else do I need to
> change'
> Or how do I fix the Report Server?
> Thanks for reading this message.
>|||Hi Jeff:-
Thanks for your advice. You are right I make a mistake in my
rsReportServer.config file. So I went back to check through all the other
config files on both ReportManager and ReportServer. Then I ran rsKeymgmt
utility to delete all existing encrypted keys in Database and I ran rsConfig
utility to regenerate the connection, followed by rsActivate utility to
reactivate the report server with the correct rsReportServer.config file.
I have been able to restart the Report Server Service after the changes
without any error message in the Event Viewer but I still not been able
access the Report Server via the Form Authentication "Logon" button. I get an
error message for:-
The report server installation is not initialized. Check the documentation
for more information. (rsReportServerNotActivated)
What would it be'
"Jeff A. Stucker" wrote:
> It sounds like something in your RS configuration got corrupted -- perhaps
> the setting for the Report Server database. You can check the log files and
> event log for more clues, and look here:
> http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/search?group=microsoft.public.sqlserver.reportingsvcs&q=rsFailedToDecryptConfigInformation&qt_g=1
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Help" <Help@.discussions.microsoft.com> wrote in message
> news:92DCE258-975D-4DCF-B705-7E1B05FF7985@.microsoft.com...
> > Hi there:-
> >
> > Anyone have any ideas on this one'
> >
> > I was trying to implement the Form Authentication example (Using Forms
> > Authentication in Reporting Services) from the MSDN but I am keep getting
> > this error message "rsFailedToDecryptConfigInformation".
> >
> > I followed all the necessary steps from the example to set up both Report
> > Server and Report Manager and ran the sql script to generate the
> > "UserAccount" databasae. I have been able to generate two users from the
> > "UILogon.aspx" page by pressing the "Register" button. But when I tried to
> > logon with the "Logon" button. The same error message would appear.
> >
> > The actual error message:-
> >
> >
> > Reporting Services Error
> > ----
> >
> > The encrypted value for configuration setting Dsn cannot be decrypted.
> > (rsFailedToDecryptConfigInformation) Get Online Help
> > An internal error occurred on the report server. See the error log for
> > more
> > details. (rsInternalError) Get Online Help
> >
> > ----
> > Microsoft Reporting Services
> >
> > I also did a check on the Report Server Service by right click to
> > "Restart"
> > it from the Administrative Tools à Services and an error message appear:-
> >
> > "Could not start the ReportServer service on Local Computer. The service
> > did
> > not return an error. This could be an internal Windows error or an
> > internal
> > service error. If the problem persists, contact your system
> > administrator."
> >
> > I know the Report Server and Report Manager were running properly before I
> > changed the setup to Form Authentication. So what else do I need to
> > change'
> > Or how do I fix the Report Server?
> >
> > Thanks for reading this message.
> >
>
>|||Have you tried rsactivate?
http://www.msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_customizing_v1_4hys.asp
If that doesn't work, I'd just uninstall and reinstall at this point.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Help" <Help@.discussions.microsoft.com> wrote in message
news:B158D92E-80AE-4DE1-BBA7-CF0DA382B0AD@.microsoft.com...
> Hi Jeff:-
> Thanks for your advice. You are right I make a mistake in my
> rsReportServer.config file. So I went back to check through all the other
> config files on both ReportManager and ReportServer. Then I ran rsKeymgmt
> utility to delete all existing encrypted keys in Database and I ran
> rsConfig
> utility to regenerate the connection, followed by rsActivate utility to
> reactivate the report server with the correct rsReportServer.config file.
> I have been able to restart the Report Server Service after the changes
> without any error message in the Event Viewer but I still not been able
> access the Report Server via the Form Authentication "Logon" button. I get
> an
> error message for:-
> The report server installation is not initialized. Check the documentation
> for more information. (rsReportServerNotActivated)
> What would it be'
>
>
>
> "Jeff A. Stucker" wrote:
>> It sounds like something in your RS configuration got corrupted --
>> perhaps
>> the setting for the Report Server database. You can check the log files
>> and
>> event log for more clues, and look here:
>> http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/search?group=microsoft.public.sqlserver.reportingsvcs&q=rsFailedToDecryptConfigInformation&qt_g=1
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Help" <Help@.discussions.microsoft.com> wrote in message
>> news:92DCE258-975D-4DCF-B705-7E1B05FF7985@.microsoft.com...
>> > Hi there:-
>> >
>> > Anyone have any ideas on this one'
>> >
>> > I was trying to implement the Form Authentication example (Using Forms
>> > Authentication in Reporting Services) from the MSDN but I am keep
>> > getting
>> > this error message "rsFailedToDecryptConfigInformation".
>> >
>> > I followed all the necessary steps from the example to set up both
>> > Report
>> > Server and Report Manager and ran the sql script to generate the
>> > "UserAccount" databasae. I have been able to generate two users from
>> > the
>> > "UILogon.aspx" page by pressing the "Register" button. But when I tried
>> > to
>> > logon with the "Logon" button. The same error message would appear.
>> >
>> > The actual error message:-
>> >
>> >
>> > Reporting Services Error
>> > ----
>> >
>> > The encrypted value for configuration setting Dsn cannot be decrypted.
>> > (rsFailedToDecryptConfigInformation) Get Online Help
>> > An internal error occurred on the report server. See the error log for
>> > more
>> > details. (rsInternalError) Get Online Help
>> >
>> > ----
>> > Microsoft Reporting Services
>> >
>> > I also did a check on the Report Server Service by right click to
>> > "Restart"
>> > it from the Administrative Tools à Services and an error message
>> > appear:-
>> >
>> > "Could not start the ReportServer service on Local Computer. The
>> > service
>> > did
>> > not return an error. This could be an internal Windows error or an
>> > internal
>> > service error. If the problem persists, contact your system
>> > administrator."
>> >
>> > I know the Report Server and Report Manager were running properly
>> > before I
>> > changed the setup to Form Authentication. So what else do I need to
>> > change'
>> > Or how do I fix the Report Server?
>> >
>> > Thanks for reading this message.
>> >
>>