forms authentication problem

I've searched the newgroups, and have found others who had this problem, but
their solutions don't seem
to work for my case:
I installed the forms authentication sample and it works fine on my local
machine. I then installed it
on my production server, and http://machinename/reportserver works fine, but
the ReportManager
http://machinename/reports does not work. I seem to be able to register
users but can't login. Why would
logon.aspx work and not uilogon.aspx? I followed the directions for
setting up the config files to the letter, and am using the machine name
rather than localhost to connect.
Any suggestions?
Vince Nicotina
Thomson Delmar LearningI don't think the example indicates that you must change the web.config to
Forms authentication... That is also where the logon form is named..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Vincenet Nicotina" <vincent_no_spam_please_.nicotina@.delmar.com> wrote in
message news:OGnZ6b3aEHA.3944@.tk2msftngp13.phx.gbl...
> I've searched the newgroups, and have found others who had this problem,
but
> their solutions don't seem
> to work for my case:
> I installed the forms authentication sample and it works fine on my local
> machine. I then installed it
> on my production server, and http://machinename/reportserver works fine,
but
> the ReportManager
> http://machinename/reports does not work. I seem to be able to register
> users but can't login. Why would
> logon.aspx work and not uilogon.aspx? I followed the directions for
> setting up the config files to the letter, and am using the machine name
> rather than localhost to connect.
> Any suggestions?
> Vince Nicotina
> Thomson Delmar Learning
>|||The ReportServer web.config is set for Forms, in accordance with the
directions, but the
ReportManager web.config is not (i've read that it doesn't need to be).
I don't really understand how ReportManager and ReportServer interact. Can
anyone explain it?Any other ideas out there? Why do we need to seperate
login boxes anway?
"Wayne Snyder" <wayne.snyder@.mariner-usa.com> wrote in message
news:eF$rYzLbEHA.4032@.TK2MSFTNGP11.phx.gbl...
> I don't think the example indicates that you must change the web.config to
> Forms authentication... That is also where the logon form is named..
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
>
> "Vincenet Nicotina" <vincent_no_spam_please_.nicotina@.delmar.com> wrote in
> message news:OGnZ6b3aEHA.3944@.tk2msftngp13.phx.gbl...
> > I've searched the newgroups, and have found others who had this problem,
> but
> > their solutions don't seem
> > to work for my case:
> >
> > I installed the forms authentication sample and it works fine on my
local
> > machine. I then installed it
> > on my production server, and http://machinename/reportserver works fine,
> but
> > the ReportManager
> > http://machinename/reports does not work. I seem to be able to register
> > users but can't login. Why would
> > logon.aspx work and not uilogon.aspx? I followed the directions for
> > setting up the config files to the letter, and am using the machine name
> > rather than localhost to connect.
> >
> > Any suggestions?
> >
> > Vince Nicotina
> > Thomson Delmar Learning
> >
> >
>

Forms Authentication Problem

Hello,
I try (since days) to the sample for forms authentication running.
I realy checked everything more then twice and searched all posts I can find
in the whole web (many, many people have exact the same problem).
The following error I receive on the http://localhost/reports
Object reference not set to an instance of an object.
[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 can not get the code running in debug mode on the reportmanager call. It
works meanwhile for the reportserver (but not reportmanager). As mentoined
above I check configuration files many times, started from scratch, following
absolut exactly the instruction.
The web is overfload with people facing this problem and blaming the MSDN
Article. It is impossible, that it is not soved from somebody. Please, please
help.
My envoirenment:
W2K3 Server SP2
SQL Server 2005 Standard Edition
Visual Studio 2005 ProfessionellHere is what I found in the event log:
Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 1/16/2008
Time: 2:17:27 AM
User: N/A
Computer: DEV01
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 1/16/2008 2:17:27 AM
Event time (UTC): 1/16/2008 1:17:27 AM
Event ID: c78ec383608f4fc4952de607739a1a9f
Event sequence: 7
Event occurrence: 4
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/Reports-11-128449164206843494
Trust level: RosettaMgr
Application Virtual Path: /Reports
Application Path: C:\Program Files\Microsoft SQL
Server\MSSQL.3\Reporting Services\ReportManager\
Machine name: DEV01
Process information:
Process ID: 3008
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: NullReferenceException
Exception message: Object reference not set to an instance of an object.
Request information:
Request URL: http://localhost/Reports/Home.aspx
Request path: /Reports/Home.aspx
User host address: 127.0.0.1
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 9
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at
Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object sender, EventArgs e)
at
System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
"Dev Main" wrote:
> Hello,
> I try (since days) to the sample for forms authentication running.
> I realy checked everything more then twice and searched all posts I can find
> in the whole web (many, many people have exact the same problem).
> The following error I receive on the http://localhost/reports
> Object reference not set to an instance of an object.
> [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 can not get the code running in debug mode on the reportmanager call. It
> works meanwhile for the reportserver (but not reportmanager). As mentoined
> above I check configuration files many times, started from scratch, following
> absolut exactly the instruction.
> The web is overfload with people facing this problem and blaming the MSDN
> Article. It is impossible, that it is not soved from somebody. Please, please
> help.
> My envoirenment:
> W2K3 Server SP2
> SQL Server 2005 Standard Edition
> Visual Studio 2005 Professionell
>|||I found a working solution, see link below.
The article about the sample application is not complete and will not work
without the settings described in the article I found.
Thank you Microsoft for one more time wasting 2 days of my life!
http://groups.google.de/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/2531fa152c2b49fc/92bb051ebc9d7251?hl=de&lnk=st&q=forms+authentication+Report+manager#92bb051ebc9d7251
"Dev Main" wrote:
> Hello,
> I try (since days) to the sample for forms authentication running.
> I realy checked everything more then twice and searched all posts I can find
> in the whole web (many, many people have exact the same problem).
> The following error I receive on the http://localhost/reports
> Object reference not set to an instance of an object.
> [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 can not get the code running in debug mode on the reportmanager call. It
> works meanwhile for the reportserver (but not reportmanager). As mentoined
> above I check configuration files many times, started from scratch, following
> absolut exactly the instruction.
> The web is overfload with people facing this problem and blaming the MSDN
> Article. It is impossible, that it is not soved from somebody. Please, please
> help.
> My envoirenment:
> W2K3 Server SP2
> SQL Server 2005 Standard Edition
> Visual Studio 2005 Professionell
>

formatt telephone number

I have searched this forum and the web and am not finding the answer.

I have a local report using the Microsoft Report Viewer add in for VS 2005 Express. I am trying to format a text field in a report that is a telephone number.

Instead of 8008898890 I want (800) 889-8890

Any suggestions? I have tried all of the format options such as {0:(###) ###-####}

None of them are working.

Joe

For anyone who is wondering here is the answer:

=Format(CDbl(Fields!yourfield.value), "(###) ###-####")