Anyone else have this problem? I deployed a custom forms authentication
library with a ASP.NET login page when I go to http://server/reports it just
sits there for a minute with the progress icon spinning in IE then
eventually I get a Threading timeout from Reporting services (in the
attached debugger) and after that the page shows up... anyone else get this
with forms auth? anyone know why it does it or how to stop it?
here is the trace output from my remote debugging session from the time the
page starts to load until it shows the login page.. thanks!
========================== 'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Web.RegularExpressions\2.0.0.0__b03f5f7f11d50a3a\System.Web.RegularExpressions.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.JScript\8.0.0.0__b03f5f7f11d50a3a\Microsoft.JScript.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Web.Mobile\2.0.0.0__b03f5f7f11d50a3a\System.Web.Mobile.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\assembly\dl3\f180608d\00083daf_b16dc701\Microsoft.ReportingServices.Diagnostics.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\assembly\dl3\cd47089b\00f2a80e_f54cc701\Microsoft.ReportingServices.Interfaces.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\assembly\dl3\498aee86\00aa0b9e_9bd0c501\ReportingServicesCDOInterop.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\assembly\dl3\4a099978\00d01d81_fd4cc701\ReportingServicesEmailDeliveryProvider.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\assembly\dl3\a890e9c0\00d01d81_fd4cc701\ReportingServicesFileShareDeliveryProvider.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\assembly\dl3\23449648\00d01d81_fd4cc701\ReportingServicesNativeClient.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\assembly\dl3\de5a2332\00fd4e82_fd4cc701\ReportingServicesWebUserInterface.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\assembly\dl3\1d01d363\8d2fe1f3_4c83c701\Res.ReportServerCustomSecurity.DLL',
Symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization\3.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.IdentityModel\3.0.0.0__b77a5c561934e089\System.IdentityModel.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.ServiceModel\3.0.0.0__b77a5c561934e089\System.ServiceModel.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\App_global.asax.aerdpjqp.dll', No symbols
loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6B128700\msvcm80.dll',
No symbols loaded.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing MaxScheduleWait to
default value of '1' second(s) because it was not specified in Configuration
file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
DatabaseQueryTimeout to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
ProcessRecycleOptions to default value of '0' because it was not specified
in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
RunningRequestsScavengerCycle to default value of '30' second(s) because it
was not specified in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
RunningRequestsDbCycle to default value of '30' second(s) because it was not
specified in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing RunningRequestsAge
to default value of '30' second(s) because it was not specified in
Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing CleanupCycleMinutes
to default value of '10' minute(s) because it was not specified in
Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
because it was not specified in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing WatsonFlags to
default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
WatsonDumpOnExceptions to default value of
'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
because it was not specified in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
WatsonDumpExcludeIfContainsExceptions to default value of
'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
because it was not specified in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
SecureConnectionLevel to default value of '1' because it was not specified
in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing DisplayErrorLink to
'True' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\SMDiagnostics\3.0.0.0__b77a5c561934e089\SMDiagnostics.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\App_Web_xl5eznny.dll', No symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\System.Design\2.0.0.0__b03f5f7f11d50a3a\System.Design.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded 'A_29647c81_d809_491e_a780_1d24c9454e83', No
symbols loaded.
'w3wp.exe' (Managed): Loaded 'M_29647c81_d809_491e_a780_1d24c9454e83', No
symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\App_Web__fdcxoc7.dll', No symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports\2cbaf422\c4330628\App_Web_9fik4let.dll', No symbols loaded.
'w3wp.exe' (Managed): Loaded 'hufv1omo', No symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\78d258ab\00fd4e82_fd4cc701\ReportingServicesWebServer.DLL',
No symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reportserver\55a9c3a5\2dd8b450\App_global.asax.psttghhl.dll', No
symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\8a0c03f8\00d01d81_fd4cc701\ReportingServicesLibrary.DLL',
No symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\5e73b5dc\00083daf_b16dc701\Microsoft.ReportingServices.Diagnostics.DLL',
No symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\52f5e7af\00d01d81_fd4cc701\ReportingServicesNativeClient.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\cff58b2b\00f2a80e_f54cc701\Microsoft.ReportingServices.Interfaces.DLL',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
w3wp!webserver!1!4/20/2007-09:17:05:: i INFO: Reporting Web Server started
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing ConnectionType to
'0' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing IsSchedulingService
to 'True' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing IsEventService to
'True' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing PollingInterval to
'10' second(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
WindowsServiceUseFileShareStorage to 'False' as specified in Configuration
file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing MemoryLimit to '60'
percent as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing MaximumMemoryLimit
to '80' percent as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing MaxQueueThreads to
'0' thread(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing IsWebServiceEnabled
to 'True' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing MaxScheduleWait to
'5' second(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing RunningRequestsAge
to '30' second(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing CleanupCycleMinutes
to '10' minute(s) as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
because it was not specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing WatsonFlags to
'1064' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
WatsonDumpOnExceptions to
'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
WatsonDumpExcludeIfContainsExceptions to
'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing DisplayErrorLink to
'True' as specified in Configuration file.
w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!4/20/2007-09:17:06:: i INFO: Reporting Services
starting SKU: Developer
w3wp!resourceutilities!1!4/20/2007-09:17:06:: i INFO: Evaluation copy: 0
days left
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
w3wp!runningjobs!1!4/20/2007-09:17:06:: i INFO: Database Cleanup (Web
Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!4/20/2007-09:17:06:: i INFO: Running Requests Scavenger
timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!4/20/2007-09:17:06:: i INFO: Running Requests DB timer
enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!4/20/2007-09:17:06:: i INFO: Memory stats update timer
enabled: Next Event: 60 seconds. Cycle: 60 seconds
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\f792c3fd\8d2fe1f3_4c83c701\Res.ReportServerCustomSecurity.DLL',
Symbols loaded.
'w3wp.exe' (Managed): Loaded
'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualBasic\8.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll',
Skipped loading symbols. Module is optimized and the debugger option 'Just
My Code' is enabled.
setconfiguration
setconfiguration: exit
Start GetuserInfo for null
*** End GetUserInfo
w3wp!library!1!04/20/2007-09:17:07:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.NullReferenceException: Object reference not set to an
instance of an object.
at
Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at
Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String
item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.DispatchRequest(Boolean&
transferedToViewerPage)
at
Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
sender, EventArgs e)
-- End of inner exception stack trace --
The thread 0x7ec has exited with code 0 (0x0).
The thread 0x1734 has exited with code 0 (0x0).
w3wp!library!1!04/20/2007-09:17:10:: i INFO: Exception dumped to: C:\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!04/20/2007-09:17:10:: i INFO: Catalog SQL Server Edition = Developer
w3wp!ui!5!4/20/2007-09:17:12:: e ERROR: The report server is not responding.
Verify that the report server is running and can be accessed from this
computer.
w3wp!ui!5!4/20/2007-09:17:13:: e ERROR: HTTP status code --> 500
--Details--
Microsoft.ReportingServices.UI.Global+RSWebServiceWrapper+CantCommunicateWithReportServerException:
The report server is not responding. Verify that the report server is
running and can be accessed from this computer.
at
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
setconfiguration
setconfiguration: exit
Start GetuserInfo for null
*** End GetUserInfo
w3wp!library!a!04/20/2007-09:17:13:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.NullReferenceException: Object reference not set to an
instance of an object.
at
Microsoft.ReportingServices.WebServer.WebServiceHelper.ConstructRSServiceObjectFromSecurityExtension()
at
Microsoft.ReportingServices.WebServer.Global.ConstructRSServiceFromRequest(String
item)
at Microsoft.ReportingServices.WebServer.Global.get_Service()
at Microsoft.ReportingServices.WebServer.Global.DispatchRequest(Boolean&
transferedToViewerPage)
at
Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
sender, EventArgs e)
-- End of inner exception stack trace --
w3wp!library!a!04/20/2007-09:17:43:: i INFO: Exception dumped to: C:\Program
Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!ui!5!4/20/2007-09:17:44:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)Yes, I am having the same problem.
"Smokey Grindle" wrote:
> Anyone else have this problem? I deployed a custom forms authentication
> library with a ASP.NET login page when I go to http://server/reports it just
> sits there for a minute with the progress icon spinning in IE then
> eventually I get a Threading timeout from Reporting services (in the
> attached debugger) and after that the page shows up... anyone else get this
> with forms auth? anyone know why it does it or how to stop it?
> here is the trace output from my remote debugging session from the time the
> page starts to load until it shows the login page.. thanks!
> ==========================> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Web.RegularExpressions\2.0.0.0__b03f5f7f11d50a3a\System.Web.RegularExpressions.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.JScript\8.0.0.0__b03f5f7f11d50a3a\Microsoft.JScript.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Web.Mobile\2.0.0.0__b03f5f7f11d50a3a\System.Web.Mobile.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\assembly\dl3\f180608d\00083daf_b16dc701\Microsoft.ReportingServices.Diagnostics.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\assembly\dl3\cd47089b\00f2a80e_f54cc701\Microsoft.ReportingServices.Interfaces.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\assembly\dl3\498aee86\00aa0b9e_9bd0c501\ReportingServicesCDOInterop.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\assembly\dl3\4a099978\00d01d81_fd4cc701\ReportingServicesEmailDeliveryProvider.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\assembly\dl3\a890e9c0\00d01d81_fd4cc701\ReportingServicesFileShareDeliveryProvider.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\assembly\dl3\23449648\00d01d81_fd4cc701\ReportingServicesNativeClient.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\assembly\dl3\de5a2332\00fd4e82_fd4cc701\ReportingServicesWebUserInterface.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\assembly\dl3\1d01d363\8d2fe1f3_4c83c701\Res.ReportServerCustomSecurity.DLL',
> Symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization\3.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\System.IdentityModel\3.0.0.0__b77a5c561934e089\System.IdentityModel.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\System.ServiceModel\3.0.0.0__b77a5c561934e089\System.ServiceModel.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\App_global.asax.aerdpjqp.dll', No symbols
> loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6B128700\msvcm80.dll',
> No symbols loaded.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
> file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing MaxScheduleWait to
> default value of '1' second(s) because it was not specified in Configuration
> file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> DatabaseQueryTimeout to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> ProcessRecycleOptions to default value of '0' because it was not specified
> in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> RunningRequestsScavengerCycle to default value of '30' second(s) because it
> was not specified in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> RunningRequestsDbCycle to default value of '30' second(s) because it was not
> specified in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing RunningRequestsAge
> to default value of '30' second(s) because it was not specified in
> Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing CleanupCycleMinutes
> to default value of '10' minute(s) because it was not specified in
> Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
> because it was not specified in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing WatsonFlags to
> default value of '1064' because it was not specified in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> WatsonDumpOnExceptions to default value of
> 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
> because it was not specified in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> WatsonDumpExcludeIfContainsExceptions to default value of
> 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
> because it was not specified in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> SecureConnectionLevel to default value of '1' because it was not specified
> in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing DisplayErrorLink to
> 'True' as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
> WebServiceUseFileShareStorage to default value of 'False' because it was not
> specified in Configuration file.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\SMDiagnostics\3.0.0.0__b77a5c561934e089\SMDiagnostics.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\App_Web_xl5eznny.dll', No symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\assembly\GAC_MSIL\System.Design\2.0.0.0__b03f5f7f11d50a3a\System.Design.dll',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded 'A_29647c81_d809_491e_a780_1d24c9454e83', No
> symbols loaded.
> 'w3wp.exe' (Managed): Loaded 'M_29647c81_d809_491e_a780_1d24c9454e83', No
> symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\App_Web__fdcxoc7.dll', No symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports\2cbaf422\c4330628\App_Web_9fik4let.dll', No symbols loaded.
> 'w3wp.exe' (Managed): Loaded 'hufv1omo', No symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\78d258ab\00fd4e82_fd4cc701\ReportingServicesWebServer.DLL',
> No symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reportserver\55a9c3a5\2dd8b450\App_global.asax.psttghhl.dll', No
> symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\8a0c03f8\00d01d81_fd4cc701\ReportingServicesLibrary.DLL',
> No symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\5e73b5dc\00083daf_b16dc701\Microsoft.ReportingServices.Diagnostics.DLL',
> No symbols loaded.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\52f5e7af\00d01d81_fd4cc701\ReportingServicesNativeClient.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> 'w3wp.exe' (Managed): Loaded
> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\cff58b2b\00f2a80e_f54cc701\Microsoft.ReportingServices.Interfaces.DLL',
> Skipped loading symbols. Module is optimized and the debugger option 'Just
> My Code' is enabled.
> w3wp!webserver!1!4/20/2007-09:17:05:: i INFO: Reporting Web Server started
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing ConnectionType to
> '0' as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing IsSchedulingService
> to 'True' as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
> IsNotificationService to 'True' as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing IsEventService to
> 'True' as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing PollingInterval to
> '10' second(s) as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
> WindowsServiceUseFileShareStorage to 'False' as specified in Configuration
> file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing MemoryLimit to '60'
> percent as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing RecycleTime to
> '720' minute(s) as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing MaximumMemoryLimit
> to '80' percent as specified in Configuration file.
> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing|||anyone know why this is?
"RSAdmin" <RSAdmin@.discussions.microsoft.com> wrote in message
news:20D5AEF8-C030-4960-8AE7-5F7256ED04A0@.microsoft.com...
> Yes, I am having the same problem.
> "Smokey Grindle" wrote:
>> Anyone else have this problem? I deployed a custom forms authentication
>> library with a ASP.NET login page when I go to http://server/reports it
>> just
>> sits there for a minute with the progress icon spinning in IE then
>> eventually I get a Threading timeout from Reporting services (in the
>> attached debugger) and after that the page shows up... anyone else get
>> this
>> with forms auth? anyone know why it does it or how to stop it?
>> here is the trace output from my remote debugging session from the time
>> the
>> page starts to load until it shows the login page.. thanks!
>> ==========================>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\System.Web.RegularExpressions\2.0.0.0__b03f5f7f11d50a3a\System.Web.RegularExpressions.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\Microsoft.JScript\8.0.0.0__b03f5f7f11d50a3a\Microsoft.JScript.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\2.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\2.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\2.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\System.Web.Mobile\2.0.0.0__b03f5f7f11d50a3a\System.Web.Mobile.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\assembly\dl3\f180608d\00083daf_b16dc701\Microsoft.ReportingServices.Diagnostics.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\assembly\dl3\cd47089b\00f2a80e_f54cc701\Microsoft.ReportingServices.Interfaces.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\assembly\dl3\498aee86\00aa0b9e_9bd0c501\ReportingServicesCDOInterop.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\assembly\dl3\4a099978\00d01d81_fd4cc701\ReportingServicesEmailDeliveryProvider.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\assembly\dl3\a890e9c0\00d01d81_fd4cc701\ReportingServicesFileShareDeliveryProvider.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\assembly\dl3\23449648\00d01d81_fd4cc701\ReportingServicesNativeClient.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\assembly\dl3\de5a2332\00fd4e82_fd4cc701\ReportingServicesWebUserInterface.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\assembly\dl3\1d01d363\8d2fe1f3_4c83c701\Res.ReportServerCustomSecurity.DLL',
>> Symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization\3.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\System.IdentityModel\3.0.0.0__b77a5c561934e089\System.IdentityModel.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\System.ServiceModel\3.0.0.0__b77a5c561934e089\System.ServiceModel.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\App_global.asax.aerdpjqp.dll', No symbols
>> loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6B128700\msvcm80.dll',
>> No symbols loaded.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration
>> file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing MaxScheduleWait
>> to
>> default value of '1' second(s) because it was not specified in
>> Configuration
>> file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> DatabaseQueryTimeout to default value of '30' second(s) because it was
>> not
>> specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> ProcessRecycleOptions to default value of '0' because it was not
>> specified
>> in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> RunningRequestsScavengerCycle to default value of '30' second(s) because
>> it
>> was not specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> RunningRequestsDbCycle to default value of '30' second(s) because it was
>> not
>> specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> RunningRequestsAge
>> to default value of '30' second(s) because it was not specified in
>> Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> CleanupCycleMinutes
>> to default value of '10' minute(s) because it was not specified in
>> Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
>> because it was not specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing WatsonFlags to
>> default value of '1064' because it was not specified in Configuration
>> file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> WatsonDumpOnExceptions to default value of
>> 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
>> because it was not specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> WatsonDumpExcludeIfContainsExceptions to default value of
>> 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
>> because it was not specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> SecureConnectionLevel to default value of '1' because it was not
>> specified
>> in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing DisplayErrorLink
>> to
>> 'True' as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:16:49:: i INFO: Initializing
>> WebServiceUseFileShareStorage to default value of 'False' because it was
>> not
>> specified in Configuration file.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\SMDiagnostics\3.0.0.0__b77a5c561934e089\SMDiagnostics.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\App_Web_xl5eznny.dll', No symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\assembly\GAC_MSIL\System.Design\2.0.0.0__b03f5f7f11d50a3a\System.Design.dll',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded 'A_29647c81_d809_491e_a780_1d24c9454e83', No
>> symbols loaded.
>> 'w3wp.exe' (Managed): Loaded 'M_29647c81_d809_491e_a780_1d24c9454e83', No
>> symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\App_Web__fdcxoc7.dll', No symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reports\2cbaf422\c4330628\App_Web_9fik4let.dll', No symbols loaded.
>> 'w3wp.exe' (Managed): Loaded 'hufv1omo', No symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\78d258ab\00fd4e82_fd4cc701\ReportingServicesWebServer.DLL',
>> No symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reportserver\55a9c3a5\2dd8b450\App_global.asax.psttghhl.dll', No
>> symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\8a0c03f8\00d01d81_fd4cc701\ReportingServicesLibrary.DLL',
>> No symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\5e73b5dc\00083daf_b16dc701\Microsoft.ReportingServices.Diagnostics.DLL',
>> No symbols loaded.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\52f5e7af\00d01d81_fd4cc701\ReportingServicesNativeClient.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> 'w3wp.exe' (Managed): Loaded
>> 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
>> Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\cff58b2b\00f2a80e_f54cc701\Microsoft.ReportingServices.Interfaces.DLL',
>> Skipped loading symbols. Module is optimized and the debugger option
>> 'Just
>> My Code' is enabled.
>> w3wp!webserver!1!4/20/2007-09:17:05:: i INFO: Reporting Web Server
>> started
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing ConnectionType
>> to
>> '0' as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
>> IsSchedulingService
>> to 'True' as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
>> IsNotificationService to 'True' as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing IsEventService
>> to
>> 'True' as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing PollingInterval
>> to
>> '10' second(s) as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
>> WindowsServiceUseFileShareStorage to 'False' as specified in
>> Configuration
>> file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing MemoryLimit to
>> '60'
>> percent as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing RecycleTime to
>> '720' minute(s) as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializing
>> MaximumMemoryLimit
>> to '80' percent as specified in Configuration file.
>> w3wp!library!1!4/20/2007-09:17:06:: i INFO: Initializingsql
Showing posts with label custom. Show all posts
Showing posts with label custom. Show all posts
Tuesday, March 27, 2012
Forms Authentication Resulting in Blank Screen after a few minutes.
Hi – I hope someone can help,
I have developed a custom authentication extension to Reporting Services 2005, using Visual Studio 2005 C#.
In local integration tests the extension behaved as expected, honouring the role based security of our main system. Following the deployment steps laid out from numerous sources all worked perfectly. We were optimistic.
I've since deployed to a 'live' user acceptance staging server, using the same procedures used in Integration and it's behaving incorrectly.
Initially the log in page is displayed as expected, at this point SQL dumps occur in the RS Log directory, the same as is seen here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1750128&SiteID=1
Hopefully there'll be a resolution to that soon. As described in that topic, the main page of Report Manager appears.
After this it all goes wrong.
Sometimes we can browse to a folder and run a report. But after running the report, trying to run something else, or browse back to the containing folder we are presented with the error page with the message:
The permissions granted to user '' are insufficient for performing this operation.
Clicking on the home link brings up the top title and nothing else and you have no option but to close the site and re-login.
Sometimes you get the above message before you can even run a report. The error logs have the message listed at the end of this post.
Other times you log in to the website and the folders don't even appear, just the top title bar.
I have since added some verbose logging in each of the implemented methods in the extension DLL. The permission checking method return true and all the various data in each method appears as expected.
I have checked, checked again and re-checked all the configuration files, they match the local Integration files, barring the machine specific keys etc, they weren't just overwritten.
The location of the log directory where my internal logs are written is read from the configuration files via the SetConfiguration methods, if that wasn't set correctly then there wouldn't be any logs at all, so the configuration is being read correctly by the extension.
One other think that I've noticed is that the back door user that is configured in the config files works perfectly, but I can't see how this can make any sort of a difference as it returns the same result in the extension DLL as a 'normal' user does at the same point in the code.
Can someone please help me, and my poor scalp, it's losing hair at a rate of knots.
Set up:
Windows Server 2005
SQL Server 2005 Service Pack 2 (Developer)
IIS 6
Error message in the log files:
w3wp!library!1!27/06/2007-10:04:20:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.
w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: The permissions granted to user '' are insufficient for performing this operation.
w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: HTTP status code --> 500
-Details--
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.
w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
Additionally, once I get the error message above, and nothing is displayed apart from the headline bar, If I browse to the ReportServer web-service, in the same session, it works perfectly.This is terribly frustrating.
|||*bump*
Any Ideas?
|||*re bump*
Forms Authentication Resulting in Blank Screen after a few minutes.
Hi – I hope someone can help,
I have developed a custom authentication extension to Reporting Services 2005, using Visual Studio 2005 C#.
In local integration tests the extension behaved as expected, honouring the role based security of our main system. Following the deployment steps laid out from numerous sources all worked perfectly. We were optimistic.
I've since deployed to a 'live' user acceptance staging server, using the same procedures used in Integration and it's behaving incorrectly.
Initially the log in page is displayed as expected, at this point SQL dumps occur in the RS Log directory, the same as is seen here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1750128&SiteID=1
Hopefully there'll be a resolution to that soon. As described in that topic, the main page of Report Manager appears.
After this it all goes wrong.
Sometimes we can browse to a folder and run a report. But after running the report, trying to run something else, or browse back to the containing folder we are presented with the error page with the message:
The permissions granted to user '' are insufficient for performing this operation.
Clicking on the home link brings up the top title and nothing else and you have no option but to close the site and re-login.
Sometimes you get the above message before you can even run a report. The error logs have the message listed at the end of this post.
Other times you log in to the website and the folders don't even appear, just the top title bar.
I have since added some verbose logging in each of the implemented methods in the extension DLL. The permission checking method return true and all the various data in each method appears as expected.
I have checked, checked again and re-checked all the configuration files, they match the local Integration files, barring the machine specific keys etc, they weren't just overwritten.
The location of the log directory where my internal logs are written is read from the configuration files via the SetConfiguration methods, if that wasn't set correctly then there wouldn't be any logs at all, so the configuration is being read correctly by the extension.
One other think that I've noticed is that the back door user that is configured in the config files works perfectly, but I can't see how this can make any sort of a difference as it returns the same result in the extension DLL as a 'normal' user does at the same point in the code.
Can someone please help me, and my poor scalp, it's losing hair at a rate of knots.
Set up:
Windows Server 2005
SQL Server 2005 Service Pack 2 (Developer)
IIS 6
Error message in the log files:
w3wp!library!1!27/06/2007-10:04:20:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.
w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: The permissions granted to user '' are insufficient for performing this operation.
w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: HTTP status code --> 500
-Details--
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.
w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
Additionally, once I get the error message above, and nothing is displayed apart from the headline bar, If I browse to the ReportServer web-service, in the same session, it works perfectly.This is terribly frustrating.
|||*bump*
Any Ideas?
|||*re bump*
Forms authentication problems
Hi,
I'm implementing a custom security extension for Reporting Services,
based on the forms authentication sample, and am having a couple of
problems with authentication.
Here's some background on my set-up.
- We intend to expose reports to our customers over the internet.
Since we already have a main web application with a logon form and
authentication framework, we are sharing the authentication cookies
with that application (which lives on a different server), according
to the MSDN article 'Forms Authentication Across Applications'.
- I have implemented an authentication extension which uses this
framework to authenticate users, and it works. (I can call LogonUser
and get a cookie back if my credentials are valid, among other things.)
- Rather than having a separate logon form for Reporting Services, we
want to redirect users to/from our main logon form on the other server.
First problem: Report Manager isn't redirecting to the logon page that I
specified in the RSWebApplication.config file. Instead it is trying to
call the web service when not authenticated, and failing. (It gets
redirected to the logon page, and doesn't know what to do with it.)
The UFAIRS article doesn't say how RM works out whether the user has
an authentication cookie for the web service which needs forwarding.
Presumably it looks for one in the request, and redirects to the logon
page if the cookie isn't there. But how does it know what the cookie's
called? How does it even know that the web service is using forms
authentication (without first trying it)?
I don't know how what I'm doing is any different to the sample, which
does work. The only thing I've changed (in the Report Manager
configuration) is the loginUrl element within CustomAuthenticationUI,
but RM isn't even trying to redirect the client.
I'm also getting what I think is the same problem using Report Designer
in Visual Studio. When the sample was installed, Report Designer would
pop up a box asking for username and password whenever it tried to use
the web service, but now it just gives me an error message stating "a
connection could not be made to the report server". Again, I'm not sure
how it's trying to determine what it has to do to authenticate itself.
Second problem: redirection from the web service works, but it isn't
respecting the useFullyQualifiedRedirectUrl setting in web.config
(attribute of the httpRuntime element), which I've set to 'true'. The
URL it generates and puts in the query string is relative to the local
server root. Since my logon page is on a different server, I need it to
include the full URL.
Sorry for the long post, and thanks for reading if you got this far.
Please let me know any ideas you might have. I can post details from my
configuration files on request, and please ask if there's something I
haven't made clear. Thanks.
StephenThe name of the authentication cookie is configured in web.config under the
<forms> tag.
Perhaps you can make a call SOAP to LogonUser from your application before
the user gets to report manager. Then send the cookie to the client. Further
access to report server should be authenticated. For report manager to work
in this configuration you need to set the AllowPassthroughCookies - see the
SP1 readme for the exact name.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Kell" <skell@.opaltelecom.co.uk> wrote in message
news:pan.2004.08.04.15.24.00.797000@.opaltelecom.co.uk...
> Hi,
> I'm implementing a custom security extension for Reporting Services,
> based on the forms authentication sample, and am having a couple of
> problems with authentication.
> Here's some background on my set-up.
> - We intend to expose reports to our customers over the internet.
> Since we already have a main web application with a logon form and
> authentication framework, we are sharing the authentication cookies
> with that application (which lives on a different server), according
> to the MSDN article 'Forms Authentication Across Applications'.
> - I have implemented an authentication extension which uses this
> framework to authenticate users, and it works. (I can call LogonUser
> and get a cookie back if my credentials are valid, among other things.)
> - Rather than having a separate logon form for Reporting Services, we
> want to redirect users to/from our main logon form on the other server.
> First problem: Report Manager isn't redirecting to the logon page that I
> specified in the RSWebApplication.config file. Instead it is trying to
> call the web service when not authenticated, and failing. (It gets
> redirected to the logon page, and doesn't know what to do with it.)
> The UFAIRS article doesn't say how RM works out whether the user has
> an authentication cookie for the web service which needs forwarding.
> Presumably it looks for one in the request, and redirects to the logon
> page if the cookie isn't there. But how does it know what the cookie's
> called? How does it even know that the web service is using forms
> authentication (without first trying it)?
> I don't know how what I'm doing is any different to the sample, which
> does work. The only thing I've changed (in the Report Manager
> configuration) is the loginUrl element within CustomAuthenticationUI,
> but RM isn't even trying to redirect the client.
> I'm also getting what I think is the same problem using Report Designer
> in Visual Studio. When the sample was installed, Report Designer would
> pop up a box asking for username and password whenever it tried to use
> the web service, but now it just gives me an error message stating "a
> connection could not be made to the report server". Again, I'm not sure
> how it's trying to determine what it has to do to authenticate itself.
> Second problem: redirection from the web service works, but it isn't
> respecting the useFullyQualifiedRedirectUrl setting in web.config
> (attribute of the httpRuntime element), which I've set to 'true'. The
> URL it generates and puts in the query string is relative to the local
> server root. Since my logon page is on a different server, I need it to
> include the full URL.
> Sorry for the long post, and thanks for reading if you got this far.
> Please let me know any ideas you might have. I can post details from my
> configuration files on request, and please ask if there's something I
> haven't made clear. Thanks.
> Stephen
>|||Firstly, thanks for the reply.
> The name of the authentication cookie is configured in web.config under the
> <forms> tag.
Maybe I misunderstood, but I thought that this was only for the web
service (i.e. in ReportServer/web.config). Report Manager is using Windows
authentication itself, and doesn't have a <forms> element in its
web.config. Let me know if this is not correct.
> Perhaps you can make a call SOAP to LogonUser from your application before
> the user gets to report manager. Then send the cookie to the client. Further
> access to report server should be authenticated. For report manager to work
> in this configuration you need to set the AllowPassthroughCookies - see the
> SP1 readme for the exact name.
Thanks -- I set the PassThroughCookies configuration as required and now I
can access Report Manager. It's still not redirecting in the case of an
unauthenticated request, which would be nice to have working, but not
essential as I can log on using our form first, which generates a valid
cookie. Unfortunately though, I still get the error I described with
Report Designer, and don't have any possibility of working around that
similarly. Please let me know if you have any ideas.
Stephen|||Report manager reads the name of the authentication cookie which is sent by
the report server as an HTTP header.
Unfortunately I don't know of any solution that would allow report designer
to work in this case. As a workaround you could write your own application
that would publish reports using SOAP calls. In the SOAP client, you can
manage your custom cookies as you wish.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Kell" <skell@.opaltelecom.co.uk> wrote in message
news:pan.2004.08.05.14.48.01.766000@.opaltelecom.co.uk...
> Firstly, thanks for the reply.
> > The name of the authentication cookie is configured in web.config under
the
> > <forms> tag.
> Maybe I misunderstood, but I thought that this was only for the web
> service (i.e. in ReportServer/web.config). Report Manager is using Windows
> authentication itself, and doesn't have a <forms> element in its
> web.config. Let me know if this is not correct.
> > Perhaps you can make a call SOAP to LogonUser from your application
before
> > the user gets to report manager. Then send the cookie to the client.
Further
> > access to report server should be authenticated. For report manager to
work
> > in this configuration you need to set the AllowPassthroughCookies - see
the
> > SP1 readme for the exact name.
> Thanks -- I set the PassThroughCookies configuration as required and now I
> can access Report Manager. It's still not redirecting in the case of an
> unauthenticated request, which would be nice to have working, but not
> essential as I can log on using our form first, which generates a valid
> cookie. Unfortunately though, I still get the error I described with
> Report Designer, and don't have any possibility of working around that
> similarly. Please let me know if you have any ideas.
> Stephen
>|||Thanks. I will look into implementing a separate application to deploy
reports.
I am still a bit puzzled about how what I'm doing is substantially
different to the sample -- there's nothing special about my cookies, and
valid cookies can be generated by the RS web service as well as by our own
login page (or at least that's the idea). I'll try to investigate whether
the HTTP requests issued by RM/RD (or the responses they get) are any
different when using the sample, compared to my current installation. (Not
managed to do so yet as I don't currently have a machine with the sample
installed.)
Going back to another issue I mentioned in my first post, I don't suppose
there's any clues about why the web service doesn't generate
fully-qualified redirect URLs? I thought this was all handled by ASP.NET's
underlying FormsAuthentication implementation, but it seems like RS has
altered the normal behaviour, unless I've misunderstood something. Any
suggestions appreciated.
Stephen|||Yes, the redirect in Report manager is done only into the report manager
directory.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Kell" <skell@.opaltelecom.co.uk> wrote in message
news:pan.2004.08.06.15.52.29.703000@.opaltelecom.co.uk...
> Thanks. I will look into implementing a separate application to deploy
> reports.
> I am still a bit puzzled about how what I'm doing is substantially
> different to the sample -- there's nothing special about my cookies, and
> valid cookies can be generated by the RS web service as well as by our own
> login page (or at least that's the idea). I'll try to investigate whether
> the HTTP requests issued by RM/RD (or the responses they get) are any
> different when using the sample, compared to my current installation. (Not
> managed to do so yet as I don't currently have a machine with the sample
> installed.)
> Going back to another issue I mentioned in my first post, I don't suppose
> there's any clues about why the web service doesn't generate
> fully-qualified redirect URLs? I thought this was all handled by ASP.NET's
> underlying FormsAuthentication implementation, but it seems like RS has
> altered the normal behaviour, unless I've misunderstood something. Any
> suggestions appreciated.
> Stephen
>|||(I don't know if anyone's still reading this thread, but if so, I finally
worked out the solution and thought I'd share it.)
Thanks -- it did turn out to be something to do with the redirect
destination being outside of the application's virtual directory, but not
quite what you said. (I won't claim that my explanation matches the
intended logic behind the Reporting Services code, only that it allowed me
to understand and solve the problem I was having.)
In fact, both the RS web service and Report Manager are quite happy to
redirect outside of their virtual directory. The problem is in how their
clients interpret this.
Both Report Manager and Report Designer need some way of determining
whether to call LogonUser. If the web service redirects them to a location
inside its virtual directory, they assume this is a logon page, and do
their ask-for-credentials thing. (For Report Manager it's redirecting to
the page specified in the CustomAuthenticationUI configuration element,
while for Report Designer it's popping up that dialog asking for
credentials.) Once they have the credentials, they call LogonUser to get
their cookie.
If the web service redirects them elsewhere, they don't do any of this,
and instead fall over, in the end generating generic error messages
claiming that the report server isn't working.
I got around this by configuring the web service to redirect to a simple
aspx page (called Logon.aspx, though the name doesn't matter) in its own
virtual directory. In the Page_Load event I test whether a the User-Agent
header was received. This is a bit of magic intended to determine whether
the client is interactive (i.e. a web browser) and therefore capable of
logging in using a form, or not (e.g. a web service client like Report
Designer or Report Manager).
In the case of an interactive client, the page redirects to the (external)
login page. (The URL of the login page is read from a label in the aspx
page, so you don't need to recompile in order to change it.) You must make
sure that you also include the ReturnUrl query string parameter in your
redirect destination URL, *and* that you translate it to a fully-qualified
URL (since RS doesn't seem to do this).
For non-interactive clients, it just serves a blank page (or actually,
since I was feeling helpful, a short message about why the client wasn't
redirected, followed by the aforementioned label showing the login page
URL).
Report Manager and Report Designer now work fine. You can specify the
external login page for RM just like any other.
Sorry for the long-winded explanation -- I hope it proves useful for
someone.
Stephen
I'm implementing a custom security extension for Reporting Services,
based on the forms authentication sample, and am having a couple of
problems with authentication.
Here's some background on my set-up.
- We intend to expose reports to our customers over the internet.
Since we already have a main web application with a logon form and
authentication framework, we are sharing the authentication cookies
with that application (which lives on a different server), according
to the MSDN article 'Forms Authentication Across Applications'.
- I have implemented an authentication extension which uses this
framework to authenticate users, and it works. (I can call LogonUser
and get a cookie back if my credentials are valid, among other things.)
- Rather than having a separate logon form for Reporting Services, we
want to redirect users to/from our main logon form on the other server.
First problem: Report Manager isn't redirecting to the logon page that I
specified in the RSWebApplication.config file. Instead it is trying to
call the web service when not authenticated, and failing. (It gets
redirected to the logon page, and doesn't know what to do with it.)
The UFAIRS article doesn't say how RM works out whether the user has
an authentication cookie for the web service which needs forwarding.
Presumably it looks for one in the request, and redirects to the logon
page if the cookie isn't there. But how does it know what the cookie's
called? How does it even know that the web service is using forms
authentication (without first trying it)?
I don't know how what I'm doing is any different to the sample, which
does work. The only thing I've changed (in the Report Manager
configuration) is the loginUrl element within CustomAuthenticationUI,
but RM isn't even trying to redirect the client.
I'm also getting what I think is the same problem using Report Designer
in Visual Studio. When the sample was installed, Report Designer would
pop up a box asking for username and password whenever it tried to use
the web service, but now it just gives me an error message stating "a
connection could not be made to the report server". Again, I'm not sure
how it's trying to determine what it has to do to authenticate itself.
Second problem: redirection from the web service works, but it isn't
respecting the useFullyQualifiedRedirectUrl setting in web.config
(attribute of the httpRuntime element), which I've set to 'true'. The
URL it generates and puts in the query string is relative to the local
server root. Since my logon page is on a different server, I need it to
include the full URL.
Sorry for the long post, and thanks for reading if you got this far.
Please let me know any ideas you might have. I can post details from my
configuration files on request, and please ask if there's something I
haven't made clear. Thanks.
StephenThe name of the authentication cookie is configured in web.config under the
<forms> tag.
Perhaps you can make a call SOAP to LogonUser from your application before
the user gets to report manager. Then send the cookie to the client. Further
access to report server should be authenticated. For report manager to work
in this configuration you need to set the AllowPassthroughCookies - see the
SP1 readme for the exact name.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Kell" <skell@.opaltelecom.co.uk> wrote in message
news:pan.2004.08.04.15.24.00.797000@.opaltelecom.co.uk...
> Hi,
> I'm implementing a custom security extension for Reporting Services,
> based on the forms authentication sample, and am having a couple of
> problems with authentication.
> Here's some background on my set-up.
> - We intend to expose reports to our customers over the internet.
> Since we already have a main web application with a logon form and
> authentication framework, we are sharing the authentication cookies
> with that application (which lives on a different server), according
> to the MSDN article 'Forms Authentication Across Applications'.
> - I have implemented an authentication extension which uses this
> framework to authenticate users, and it works. (I can call LogonUser
> and get a cookie back if my credentials are valid, among other things.)
> - Rather than having a separate logon form for Reporting Services, we
> want to redirect users to/from our main logon form on the other server.
> First problem: Report Manager isn't redirecting to the logon page that I
> specified in the RSWebApplication.config file. Instead it is trying to
> call the web service when not authenticated, and failing. (It gets
> redirected to the logon page, and doesn't know what to do with it.)
> The UFAIRS article doesn't say how RM works out whether the user has
> an authentication cookie for the web service which needs forwarding.
> Presumably it looks for one in the request, and redirects to the logon
> page if the cookie isn't there. But how does it know what the cookie's
> called? How does it even know that the web service is using forms
> authentication (without first trying it)?
> I don't know how what I'm doing is any different to the sample, which
> does work. The only thing I've changed (in the Report Manager
> configuration) is the loginUrl element within CustomAuthenticationUI,
> but RM isn't even trying to redirect the client.
> I'm also getting what I think is the same problem using Report Designer
> in Visual Studio. When the sample was installed, Report Designer would
> pop up a box asking for username and password whenever it tried to use
> the web service, but now it just gives me an error message stating "a
> connection could not be made to the report server". Again, I'm not sure
> how it's trying to determine what it has to do to authenticate itself.
> Second problem: redirection from the web service works, but it isn't
> respecting the useFullyQualifiedRedirectUrl setting in web.config
> (attribute of the httpRuntime element), which I've set to 'true'. The
> URL it generates and puts in the query string is relative to the local
> server root. Since my logon page is on a different server, I need it to
> include the full URL.
> Sorry for the long post, and thanks for reading if you got this far.
> Please let me know any ideas you might have. I can post details from my
> configuration files on request, and please ask if there's something I
> haven't made clear. Thanks.
> Stephen
>|||Firstly, thanks for the reply.
> The name of the authentication cookie is configured in web.config under the
> <forms> tag.
Maybe I misunderstood, but I thought that this was only for the web
service (i.e. in ReportServer/web.config). Report Manager is using Windows
authentication itself, and doesn't have a <forms> element in its
web.config. Let me know if this is not correct.
> Perhaps you can make a call SOAP to LogonUser from your application before
> the user gets to report manager. Then send the cookie to the client. Further
> access to report server should be authenticated. For report manager to work
> in this configuration you need to set the AllowPassthroughCookies - see the
> SP1 readme for the exact name.
Thanks -- I set the PassThroughCookies configuration as required and now I
can access Report Manager. It's still not redirecting in the case of an
unauthenticated request, which would be nice to have working, but not
essential as I can log on using our form first, which generates a valid
cookie. Unfortunately though, I still get the error I described with
Report Designer, and don't have any possibility of working around that
similarly. Please let me know if you have any ideas.
Stephen|||Report manager reads the name of the authentication cookie which is sent by
the report server as an HTTP header.
Unfortunately I don't know of any solution that would allow report designer
to work in this case. As a workaround you could write your own application
that would publish reports using SOAP calls. In the SOAP client, you can
manage your custom cookies as you wish.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Kell" <skell@.opaltelecom.co.uk> wrote in message
news:pan.2004.08.05.14.48.01.766000@.opaltelecom.co.uk...
> Firstly, thanks for the reply.
> > The name of the authentication cookie is configured in web.config under
the
> > <forms> tag.
> Maybe I misunderstood, but I thought that this was only for the web
> service (i.e. in ReportServer/web.config). Report Manager is using Windows
> authentication itself, and doesn't have a <forms> element in its
> web.config. Let me know if this is not correct.
> > Perhaps you can make a call SOAP to LogonUser from your application
before
> > the user gets to report manager. Then send the cookie to the client.
Further
> > access to report server should be authenticated. For report manager to
work
> > in this configuration you need to set the AllowPassthroughCookies - see
the
> > SP1 readme for the exact name.
> Thanks -- I set the PassThroughCookies configuration as required and now I
> can access Report Manager. It's still not redirecting in the case of an
> unauthenticated request, which would be nice to have working, but not
> essential as I can log on using our form first, which generates a valid
> cookie. Unfortunately though, I still get the error I described with
> Report Designer, and don't have any possibility of working around that
> similarly. Please let me know if you have any ideas.
> Stephen
>|||Thanks. I will look into implementing a separate application to deploy
reports.
I am still a bit puzzled about how what I'm doing is substantially
different to the sample -- there's nothing special about my cookies, and
valid cookies can be generated by the RS web service as well as by our own
login page (or at least that's the idea). I'll try to investigate whether
the HTTP requests issued by RM/RD (or the responses they get) are any
different when using the sample, compared to my current installation. (Not
managed to do so yet as I don't currently have a machine with the sample
installed.)
Going back to another issue I mentioned in my first post, I don't suppose
there's any clues about why the web service doesn't generate
fully-qualified redirect URLs? I thought this was all handled by ASP.NET's
underlying FormsAuthentication implementation, but it seems like RS has
altered the normal behaviour, unless I've misunderstood something. Any
suggestions appreciated.
Stephen|||Yes, the redirect in Report manager is done only into the report manager
directory.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stephen Kell" <skell@.opaltelecom.co.uk> wrote in message
news:pan.2004.08.06.15.52.29.703000@.opaltelecom.co.uk...
> Thanks. I will look into implementing a separate application to deploy
> reports.
> I am still a bit puzzled about how what I'm doing is substantially
> different to the sample -- there's nothing special about my cookies, and
> valid cookies can be generated by the RS web service as well as by our own
> login page (or at least that's the idea). I'll try to investigate whether
> the HTTP requests issued by RM/RD (or the responses they get) are any
> different when using the sample, compared to my current installation. (Not
> managed to do so yet as I don't currently have a machine with the sample
> installed.)
> Going back to another issue I mentioned in my first post, I don't suppose
> there's any clues about why the web service doesn't generate
> fully-qualified redirect URLs? I thought this was all handled by ASP.NET's
> underlying FormsAuthentication implementation, but it seems like RS has
> altered the normal behaviour, unless I've misunderstood something. Any
> suggestions appreciated.
> Stephen
>|||(I don't know if anyone's still reading this thread, but if so, I finally
worked out the solution and thought I'd share it.)
Thanks -- it did turn out to be something to do with the redirect
destination being outside of the application's virtual directory, but not
quite what you said. (I won't claim that my explanation matches the
intended logic behind the Reporting Services code, only that it allowed me
to understand and solve the problem I was having.)
In fact, both the RS web service and Report Manager are quite happy to
redirect outside of their virtual directory. The problem is in how their
clients interpret this.
Both Report Manager and Report Designer need some way of determining
whether to call LogonUser. If the web service redirects them to a location
inside its virtual directory, they assume this is a logon page, and do
their ask-for-credentials thing. (For Report Manager it's redirecting to
the page specified in the CustomAuthenticationUI configuration element,
while for Report Designer it's popping up that dialog asking for
credentials.) Once they have the credentials, they call LogonUser to get
their cookie.
If the web service redirects them elsewhere, they don't do any of this,
and instead fall over, in the end generating generic error messages
claiming that the report server isn't working.
I got around this by configuring the web service to redirect to a simple
aspx page (called Logon.aspx, though the name doesn't matter) in its own
virtual directory. In the Page_Load event I test whether a the User-Agent
header was received. This is a bit of magic intended to determine whether
the client is interactive (i.e. a web browser) and therefore capable of
logging in using a form, or not (e.g. a web service client like Report
Designer or Report Manager).
In the case of an interactive client, the page redirects to the (external)
login page. (The URL of the login page is read from a label in the aspx
page, so you don't need to recompile in order to change it.) You must make
sure that you also include the ReturnUrl query string parameter in your
redirect destination URL, *and* that you translate it to a fully-qualified
URL (since RS doesn't seem to do this).
For non-interactive clients, it just serves a blank page (or actually,
since I was feeling helpful, a short message about why the client wasn't
redirected, followed by the aforementioned label showing the login page
URL).
Report Manager and Report Designer now work fine. You can specify the
external login page for RM just like any other.
Sorry for the long-winded explanation -- I hope it proves useful for
someone.
Stephen
Forms authentication and VB
Does anyone have forms authentication working with calls from VB? We've got
the custom security working through the standard interface, but can't get
LogonUser calls to work from a VB.NET app. Any input would be appreciated.Are you calling the web service using VB? I imagine you'll need to
implement a report server proxy, similar to the code in the forms
authentication sample. I haven't heard back from Microsoft or anyone with
experience yet whether the application will need to be a web service or web
app itself to have visibility to the formsAuthCookie.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"R. Hamilton" <roark.hamilton@.cionex.com> wrote in message
news:%23oLfkL38EHA.2600@.TK2MSFTNGP09.phx.gbl...
> Does anyone have forms authentication working with calls from VB? We've
> got
> the custom security working through the standard interface, but can't get
> LogonUser calls to work from a VB.NET app. Any input would be
> appreciated.
>
the custom security working through the standard interface, but can't get
LogonUser calls to work from a VB.NET app. Any input would be appreciated.Are you calling the web service using VB? I imagine you'll need to
implement a report server proxy, similar to the code in the forms
authentication sample. I haven't heard back from Microsoft or anyone with
experience yet whether the application will need to be a web service or web
app itself to have visibility to the formsAuthCookie.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"R. Hamilton" <roark.hamilton@.cionex.com> wrote in message
news:%23oLfkL38EHA.2600@.TK2MSFTNGP09.phx.gbl...
> Does anyone have forms authentication working with calls from VB? We've
> got
> the custom security working through the standard interface, but can't get
> LogonUser calls to work from a VB.NET app. Any input would be
> appreciated.
>
Monday, March 26, 2012
Forms authentication & SQL RS 2000 - which versions supported?
Hi,
I was told recently that the SP2 release for SQL RS 2000 made custom (i.e.
Forms) authentication available in the SQL Server 2K Standard edition -
where it had only been available in Enterprise prior to SP2.
Can anyone confirm if this is correct?
Thanks,
ChrisI think this is incorrect. However, my understanding is that custom security
will be available with RS 2005 Standard.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Chris Lewis" <chris.lewis@.xntra.co.uk> wrote in message
news:eAF1EhZ%23FHA.2036@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I was told recently that the SP2 release for SQL RS 2000 made custom (i.e.
> Forms) authentication available in the SQL Server 2K Standard edition -
> where it had only been available in Enterprise prior to SP2.
> Can anyone confirm if this is correct?
> Thanks,
> Chris
>
I was told recently that the SP2 release for SQL RS 2000 made custom (i.e.
Forms) authentication available in the SQL Server 2K Standard edition -
where it had only been available in Enterprise prior to SP2.
Can anyone confirm if this is correct?
Thanks,
ChrisI think this is incorrect. However, my understanding is that custom security
will be available with RS 2005 Standard.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Chris Lewis" <chris.lewis@.xntra.co.uk> wrote in message
news:eAF1EhZ%23FHA.2036@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I was told recently that the SP2 release for SQL RS 2000 made custom (i.e.
> Forms) authentication available in the SQL Server 2K Standard edition -
> where it had only been available in Enterprise prior to SP2.
> Can anyone confirm if this is correct?
> Thanks,
> Chris
>
Forms Authentication
Hi,
After two days of work I can't resolve my problem. I implemented the
Custom Security Sample. The http://myMachineName/Reportserver work
properly when I connected it.
I started getting the following error when I try to connect to Report
Manager:
Access denied
The Report Service is installed in my machine and the Report Server
Database in another server.
Can anybody help me please?
Thanks.Gave,
Did you disable impersonation for the Report Manager Virtual Directory?
Are you logging into Report Manager with the same username defined in
the node
<AdminConfiguration>
<UserName>username</UserName>
</AdminConfiguration>
in the RSReportServer.config file?
Andy Potter
Andy Potter|||Andy,
Thanks for the reply
Yes, in Report Manager Virtual Directory the anonymous access is
checked and I used the same user that are in RSReportServer.config
file.
What other issue can be?
Thanks.
Potter ha escrito:
> Gave,
> Did you disable impersonation for the Report Manager Virtual Directory?
> Are you logging into Report Manager with the same username defined in
> the node
> <AdminConfiguration>
> <UserName>username</UserName>
> </AdminConfiguration>
> in the RSReportServer.config file?
> Andy Potter
>
>
> Andy Potter|||Gave,
Put some breakpoints in your extension and step through the CheckAccess
overloads in the Authorization.cs class. Specifically, look at the
comparison that checks to see if the user logging in matches the
administrator username.
// If the user is the administrator, allow unrestricted access.
if (0 == String.Compare(userName, m_adminUserName, true,
CultureInfo.CurrentCulture))
return true;
Andy Potter|||Andy,
Thanks again. I resolved my problem; I forgot to change <identity
impersonate="true"/> to <identity impersonate="false"/>.
Sorry and Thanks a lot for your time.
Gave.
Potter ha escrito:
> Gave,
> Put some breakpoints in your extension and step through the CheckAccess
> overloads in the Authorization.cs class. Specifically, look at the
> comparison that checks to see if the user logging in matches the
> administrator username.
> // If the user is the administrator, allow unrestricted access.
> if (0 == String.Compare(userName, m_adminUserName, true,
> CultureInfo.CurrentCulture))
> return true;
> Andy Pottersql
After two days of work I can't resolve my problem. I implemented the
Custom Security Sample. The http://myMachineName/Reportserver work
properly when I connected it.
I started getting the following error when I try to connect to Report
Manager:
Access denied
The Report Service is installed in my machine and the Report Server
Database in another server.
Can anybody help me please?
Thanks.Gave,
Did you disable impersonation for the Report Manager Virtual Directory?
Are you logging into Report Manager with the same username defined in
the node
<AdminConfiguration>
<UserName>username</UserName>
</AdminConfiguration>
in the RSReportServer.config file?
Andy Potter
Andy Potter|||Andy,
Thanks for the reply
Yes, in Report Manager Virtual Directory the anonymous access is
checked and I used the same user that are in RSReportServer.config
file.
What other issue can be?
Thanks.
Potter ha escrito:
> Gave,
> Did you disable impersonation for the Report Manager Virtual Directory?
> Are you logging into Report Manager with the same username defined in
> the node
> <AdminConfiguration>
> <UserName>username</UserName>
> </AdminConfiguration>
> in the RSReportServer.config file?
> Andy Potter
>
>
> Andy Potter|||Gave,
Put some breakpoints in your extension and step through the CheckAccess
overloads in the Authorization.cs class. Specifically, look at the
comparison that checks to see if the user logging in matches the
administrator username.
// If the user is the administrator, allow unrestricted access.
if (0 == String.Compare(userName, m_adminUserName, true,
CultureInfo.CurrentCulture))
return true;
Andy Potter|||Andy,
Thanks again. I resolved my problem; I forgot to change <identity
impersonate="true"/> to <identity impersonate="false"/>.
Sorry and Thanks a lot for your time.
Gave.
Potter ha escrito:
> Gave,
> Put some breakpoints in your extension and step through the CheckAccess
> overloads in the Authorization.cs class. Specifically, look at the
> comparison that checks to see if the user logging in matches the
> administrator username.
> // If the user is the administrator, allow unrestricted access.
> if (0 == String.Compare(userName, m_adminUserName, true,
> CultureInfo.CurrentCulture))
> return true;
> Andy Pottersql
Friday, March 23, 2012
Formatting Problem
I would like to change the background of a cell if its value is 'Test'
I have tried this thru both custom code and just thru a simple iif statement both which produce errors. I put the following iif statemnt in
I have tried this thru both custom code and just thru a simple iif statement both which produce errors. I put the following iif statemnt in
=iif(Fields!change_type.value="Test","Cyan","Red")
and get the following error:
c:\variset4\reports_microsoft\ToolPredByOp.rdl The background color expression for the textbox 'CHANGE_TYPE' refers to the field 'change_type'. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.
Any suggestions?disregard my last message - my line was correct - the problem was that Reporting services is Case sensitive. I should have had my field names in all caps. I found a good ei was trying to do at:
http://www.sqlservercentral.com/columnists/bknight/reportingservicesconditionalformatting.asp
if anyone is interested...|||
Hi.....
May be ur Prblm is Caps letter..or U Can also try Like this....
=iif(Fields!change_type.value="Test","Cyan","Red")
As
use ur Text Box Name instead of Field value.... ok write this Code in BackGround -- <Expression...>
=iif(ReportItems!textbox1.value="Test","Cyan","Red")
Best Regards......
Wednesday, March 21, 2012
Formatting Issues
Hi all,
Im using the custom code to format the string returned by the
stored procedure in the reports.
Public Function ResourceCategory(ByVal stat As String) As String
Dim str As String
Dim arr As String()
arr = stat.Split(",")
Dim i As Integer
For i = 0 To arr.Length -1
If arr(i) = "'PART'" Then
str = str & "Partner/"
End If
If arr(i) = "'ADM'" Then
str = str & "Administration/"
End If
If arr(i) = "'DIR'" Then
str = str & "Director/"
End If
If arr(i) = "'ENG'" Then
str = str & "Engineer/"
End If
if arr(i) = "'PM'" Then
str = str & "Project Manager/"
End If
if arr(i) = "'SE'" Then
str = str & "Senior Engineer/"
End If
if arr(i) = "'VALGRE'" Then
str = str & "Validation Engineer Greenville/"
End If
if arr(i) = "'VALSEN'" Then
str = str & "Senior Validation Engineer SFO/"
End If
if arr(i) = "'VALSFO'" Then
str = str & "Validation Engineer/"
End If
if arr(i) = "All" Then
str = str & "All/"
End If
Next
str = str.Remove(str.LastIndexOf("/"), 1)
Return str
End Function
But if the condition fails the report prints "#Error"
Can I in any way avoid this'
hanks In Advance,Provide an Else condition for anything that does NOT satisfy the other
conditions like "NA"... But if the function fails, you can not override the
error...
--
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
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:8871344E-22EB-45C9-BF69-6A2D68E38093@.microsoft.com...
> Hi all,
> Im using the custom code to format the string returned by the
> stored procedure in the reports.
> Public Function ResourceCategory(ByVal stat As String) As String
> Dim str As String
> Dim arr As String()
> arr = stat.Split(",")
> Dim i As Integer
> For i = 0 To arr.Length -1
> If arr(i) = "'PART'" Then
> str = str & "Partner/"
> End If
> If arr(i) = "'ADM'" Then
> str = str & "Administration/"
> End If
> If arr(i) = "'DIR'" Then
> str = str & "Director/"
> End If
> If arr(i) = "'ENG'" Then
> str = str & "Engineer/"
> End If
> if arr(i) = "'PM'" Then
> str = str & "Project Manager/"
> End If
> if arr(i) = "'SE'" Then
> str = str & "Senior Engineer/"
> End If
> if arr(i) = "'VALGRE'" Then
> str = str & "Validation Engineer Greenville/"
> End If
> if arr(i) = "'VALSEN'" Then
> str = str & "Senior Validation Engineer SFO/"
> End If
> if arr(i) = "'VALSFO'" Then
> str = str & "Validation Engineer/"
> End If
> if arr(i) = "All" Then
> str = str & "All/"
> End If
> Next
> str = str.Remove(str.LastIndexOf("/"), 1)
> Return str
> End Function
> But if the condition fails the report prints "#Error"
> Can I in any way avoid this'
> hanks In Advance,|||Thanks Wayne ,
this is wat im trying to accomplish.
Hope u will help me out in this'
Im displaying the parameters selected by the user in a textbox.
The selection mode is multiple.
Im passing the code selected to the stored procedure,so it displays the
code.
if i give,
Parameters!Category.Value
So i wrote the code which i posted previously,
IS there a way i can load the description from the database '
Can i connect to the Database from the Code to achieve this'
"Wayne Snyder" wrote:
> Provide an Else condition for anything that does NOT satisfy the other
> conditions like "NA"... But if the function fails, you can not override the
> error...
> --
> 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
> "Chandra" <Chandra@.discussions.microsoft.com> wrote in message
> news:8871344E-22EB-45C9-BF69-6A2D68E38093@.microsoft.com...
> > Hi all,
> > Im using the custom code to format the string returned by the
> > stored procedure in the reports.
> >
> > Public Function ResourceCategory(ByVal stat As String) As String
> > Dim str As String
> > Dim arr As String()
> > arr = stat.Split(",")
> > Dim i As Integer
> > For i = 0 To arr.Length -1
> > If arr(i) = "'PART'" Then
> > str = str & "Partner/"
> > End If
> > If arr(i) = "'ADM'" Then
> > str = str & "Administration/"
> > End If
> > If arr(i) = "'DIR'" Then
> > str = str & "Director/"
> > End If
> > If arr(i) = "'ENG'" Then
> > str = str & "Engineer/"
> > End If
> > if arr(i) = "'PM'" Then
> > str = str & "Project Manager/"
> > End If
> > if arr(i) = "'SE'" Then
> > str = str & "Senior Engineer/"
> > End If
> > if arr(i) = "'VALGRE'" Then
> > str = str & "Validation Engineer Greenville/"
> > End If
> > if arr(i) = "'VALSEN'" Then
> > str = str & "Senior Validation Engineer SFO/"
> > End If
> > if arr(i) = "'VALSFO'" Then
> > str = str & "Validation Engineer/"
> > End If
> > if arr(i) = "All" Then
> > str = str & "All/"
> > End If
> > Next
> > str = str.Remove(str.LastIndexOf("/"), 1)
> > Return str
> > End Function
> >
> > But if the condition fails the report prints "#Error"
> > Can I in any way avoid this'
> > hanks In Advance,
>
Im using the custom code to format the string returned by the
stored procedure in the reports.
Public Function ResourceCategory(ByVal stat As String) As String
Dim str As String
Dim arr As String()
arr = stat.Split(",")
Dim i As Integer
For i = 0 To arr.Length -1
If arr(i) = "'PART'" Then
str = str & "Partner/"
End If
If arr(i) = "'ADM'" Then
str = str & "Administration/"
End If
If arr(i) = "'DIR'" Then
str = str & "Director/"
End If
If arr(i) = "'ENG'" Then
str = str & "Engineer/"
End If
if arr(i) = "'PM'" Then
str = str & "Project Manager/"
End If
if arr(i) = "'SE'" Then
str = str & "Senior Engineer/"
End If
if arr(i) = "'VALGRE'" Then
str = str & "Validation Engineer Greenville/"
End If
if arr(i) = "'VALSEN'" Then
str = str & "Senior Validation Engineer SFO/"
End If
if arr(i) = "'VALSFO'" Then
str = str & "Validation Engineer/"
End If
if arr(i) = "All" Then
str = str & "All/"
End If
Next
str = str.Remove(str.LastIndexOf("/"), 1)
Return str
End Function
But if the condition fails the report prints "#Error"
Can I in any way avoid this'
hanks In Advance,Provide an Else condition for anything that does NOT satisfy the other
conditions like "NA"... But if the function fails, you can not override the
error...
--
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
"Chandra" <Chandra@.discussions.microsoft.com> wrote in message
news:8871344E-22EB-45C9-BF69-6A2D68E38093@.microsoft.com...
> Hi all,
> Im using the custom code to format the string returned by the
> stored procedure in the reports.
> Public Function ResourceCategory(ByVal stat As String) As String
> Dim str As String
> Dim arr As String()
> arr = stat.Split(",")
> Dim i As Integer
> For i = 0 To arr.Length -1
> If arr(i) = "'PART'" Then
> str = str & "Partner/"
> End If
> If arr(i) = "'ADM'" Then
> str = str & "Administration/"
> End If
> If arr(i) = "'DIR'" Then
> str = str & "Director/"
> End If
> If arr(i) = "'ENG'" Then
> str = str & "Engineer/"
> End If
> if arr(i) = "'PM'" Then
> str = str & "Project Manager/"
> End If
> if arr(i) = "'SE'" Then
> str = str & "Senior Engineer/"
> End If
> if arr(i) = "'VALGRE'" Then
> str = str & "Validation Engineer Greenville/"
> End If
> if arr(i) = "'VALSEN'" Then
> str = str & "Senior Validation Engineer SFO/"
> End If
> if arr(i) = "'VALSFO'" Then
> str = str & "Validation Engineer/"
> End If
> if arr(i) = "All" Then
> str = str & "All/"
> End If
> Next
> str = str.Remove(str.LastIndexOf("/"), 1)
> Return str
> End Function
> But if the condition fails the report prints "#Error"
> Can I in any way avoid this'
> hanks In Advance,|||Thanks Wayne ,
this is wat im trying to accomplish.
Hope u will help me out in this'
Im displaying the parameters selected by the user in a textbox.
The selection mode is multiple.
Im passing the code selected to the stored procedure,so it displays the
code.
if i give,
Parameters!Category.Value
So i wrote the code which i posted previously,
IS there a way i can load the description from the database '
Can i connect to the Database from the Code to achieve this'
"Wayne Snyder" wrote:
> Provide an Else condition for anything that does NOT satisfy the other
> conditions like "NA"... But if the function fails, you can not override the
> error...
> --
> 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
> "Chandra" <Chandra@.discussions.microsoft.com> wrote in message
> news:8871344E-22EB-45C9-BF69-6A2D68E38093@.microsoft.com...
> > Hi all,
> > Im using the custom code to format the string returned by the
> > stored procedure in the reports.
> >
> > Public Function ResourceCategory(ByVal stat As String) As String
> > Dim str As String
> > Dim arr As String()
> > arr = stat.Split(",")
> > Dim i As Integer
> > For i = 0 To arr.Length -1
> > If arr(i) = "'PART'" Then
> > str = str & "Partner/"
> > End If
> > If arr(i) = "'ADM'" Then
> > str = str & "Administration/"
> > End If
> > If arr(i) = "'DIR'" Then
> > str = str & "Director/"
> > End If
> > If arr(i) = "'ENG'" Then
> > str = str & "Engineer/"
> > End If
> > if arr(i) = "'PM'" Then
> > str = str & "Project Manager/"
> > End If
> > if arr(i) = "'SE'" Then
> > str = str & "Senior Engineer/"
> > End If
> > if arr(i) = "'VALGRE'" Then
> > str = str & "Validation Engineer Greenville/"
> > End If
> > if arr(i) = "'VALSEN'" Then
> > str = str & "Senior Validation Engineer SFO/"
> > End If
> > if arr(i) = "'VALSFO'" Then
> > str = str & "Validation Engineer/"
> > End If
> > if arr(i) = "All" Then
> > str = str & "All/"
> > End If
> > Next
> > str = str.Remove(str.LastIndexOf("/"), 1)
> > Return str
> > End Function
> >
> > But if the condition fails the report prints "#Error"
> > Can I in any way avoid this'
> > hanks In Advance,
>
Subscribe to:
Posts (Atom)