Showing posts with label errors. Show all posts
Showing posts with label errors. Show all posts

Thursday, March 22, 2012

Authentication mode="none"

Has anyone gotten this to work?
I keep getting the following errors
w3wp!library!930!11/02/2004-14:43:34:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files, Could not load Authorization extension;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log files
w3wp!webserver!930!11/02/2004-14:43:37:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The Report Server has encountered a configuration error; more details in the
log filesI'll second that, and also throw in the call stack that makes it back to
UILogon.aspx:
at
Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
at
Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
at Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at
Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)"
Strangely, this says the error was thrown by get_AuthenticationExtension,
but the logged error is that the Authorization extension could not be loaded.
Anyone with any ideas on where to look to nail down the specifics of why
this is failing?
"lagalot" wrote:
> Has anyone gotten this to work?
> I keep getting the following errors
>
> w3wp!library!930!11/02/2004-14:43:34:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files, Could not load Authorization extension;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files
> w3wp!webserver!930!11/02/2004-14:43:37:: e ERROR: Reporting Services error
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The Report Server has encountered a configuration error; more details in the
> log files
>|||"Marc Lewandowski" wrote:
> I'll second that, and also throw in the call stack that makes it back to
> UILogon.aspx:
dont know if it helps but
for my deal i ended up doing something weird:
I set 2 virtuals. "ReportServer" (as per install), and a new one
"ReportsWeb", restricting ReportServer to only localhost (so the admin tools
still work) and setting ReportsWeb with IUSR browser role. This worked for
what i needed.
I've written a FAQ on this if any one is interested.|||Lagalot,
Well, it doesn't help, but that's not your fault. We were getting the same
error for the same underlying reason, but while trying to do very different
things.
The error arises because (apparently) RS requires a match between the
Authentication mode name in web.config and the Authentication Extension Name
in RSReportServer.config. You got the error because you changed the mode in
an effort to disable authentication entirely. I got the error because I
thought I could be creative and name my Authentication Extension something
other than "Forms."
So, FWIW, problem (sort of) solved.
-Marc
"lagalot" wrote:
> "Marc Lewandowski" wrote:
> dont know if it helps but
> for my deal i ended up doing something weird:
> I set 2 virtuals. "ReportServer" (as per install), and a new one
> "ReportsWeb", restricting ReportServer to only localhost (so the admin tools
> still work) and setting ReportsWeb with IUSR browser role. This worked for
> what i needed.
> I've written a FAQ on this if any one is interested.|||I am definitely interested. May I see the FAQ?
"lagalot" <lagalot@.discussions.microsoft.com> wrote in message
news:EECFB375-E975-4E61-9EBE-64C03B923192@.microsoft.com...
> "Marc Lewandowski" wrote:
>> I'll second that, and also throw in the call stack that makes it back to
>> UILogon.aspx:
> dont know if it helps but
> for my deal i ended up doing something weird:
> I set 2 virtuals. "ReportServer" (as per install), and a new one
> "ReportsWeb", restricting ReportServer to only localhost (so the admin
> tools
> still work) and setting ReportsWeb with IUSR browser role. This worked
> for
> what i needed.
> I've written a FAQ on this if any one is interested.|||May I please see this FAQ you have written? I believe it may help me
greatly.
"lagalot" <lagalot@.discussions.microsoft.com> wrote in message
news:EECFB375-E975-4E61-9EBE-64C03B923192@.microsoft.com...
> "Marc Lewandowski" wrote:
>> I'll second that, and also throw in the call stack that makes it back to
>> UILogon.aspx:
> dont know if it helps but
> for my deal i ended up doing something weird:
> I set 2 virtuals. "ReportServer" (as per install), and a new one
> "ReportsWeb", restricting ReportServer to only localhost (so the admin
> tools
> still work) and setting ReportsWeb with IUSR browser role. This worked
> for
> what i needed.
> I've written a FAQ on this if any one is interested.

Tuesday, March 20, 2012

Authentication errors after backing out changes for forms authentication

We attempted to run the custom authentication sample from the RS
samples. We had issues and attempted to "back out" our changes - being
stupid, we didn't back up our config files. "How hard could it be?"
Well, 8 hours later, we're out of answers as to why we can't run RS
anymore. Yes, learn from our mistake.
We're hoping someone can help us with the following.
When going to http://localhost/Reports, I get the following:
System.Web.Services.Protocols.SoapException: Server was unable to
process request. --> System.NullReferenceException: Object reference
not set to an instance of an object. at
Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetExtensionConfigurationInfo(String
extensionType, String extensionName) at
Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
at Microsoft.ReportingServices.WebServer.ReportingService2005..ctor()
-- End of inner exception stack trace --
When going to http://localhost/ReportServer, I get a 404.
The log file ReportServerWebApp__01_17_2006_15_33_40 contains the
following stack dump:
'
aspnet_wp!ui!1!1/17/2006-15:34:06:: e ERROR:
System.Web.Services.Protocols.SoapException: Server was unable to
process request. --> System.NullReferenceException: Object reference
not set to an instance of an object.
at
Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetExtensionConfigurationInfo(String
extensionType, String extensionName)
at
Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
at
Microsoft.ReportingServices.WebServer.ReportingService2005..ctor()
-- End of inner exception stack trace --
aspnet_wp!ui!1!1/17/2006-15:34:06:: e ERROR: HTTP status code --> 500
--Details--
System.Web.Services.Protocols.SoapException:
System.Web.Services.Protocols.SoapException: Server was unable to
process request. --> System.NullReferenceException: Object reference
not set to an instance of an object.
at
Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetExtensionConfigurationInfo(String
extensionType, String extensionName)
at
Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
at
Microsoft.ReportingServices.WebServer.ReportingService2005..ctor()
-- End of inner exception stack trace --
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
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)
aspnet_wp!ui!1!1/17/2006-15:34:06:: 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)
I confirmed that the rsreportserver.config section that deals with
security/authentication looks as follows - this matches another server
whose RS is working:
<Security>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,Microsoft.ReportingServices.Authorization"/>
</Security>
<Authentication>
<Extension Name="Windows"
Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,Microsoft.ReportingServices.Authorization"/>
</Authentication>
And the web.configs in both ReportManager and ReportServer folders
reference the correct authentication extension:
Report Manager web.config:
<authentication mode="Windows" />
<identity impersonate="true" />
Report Server web.config:
<authentication mode="Windows" />
<identity impersonate="true" />
At this point, I'm considering spinning up a second instance of RS to
see if there's something more basic broken, but I thought I would ask
for any help/pointers on this.
Thank you!
MichaelSJust a followup, in case a search finds this topic. We never did solve
the problem. We ended up completely removing SQL/RS and reinstalling.
Our suspicion is that something was inadvertently deleted. Since this
was a dev box, it's assumed that a trashing every so often is
acceptable.
MS|||In our case, the pieces that disappeared were three files from
C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting
Services\ReportServer. Specifically:
global.asax, ModelGenerationRules.smgl, and ReportExecution2005.asmx.
Replacing those files (from a working installation) solved the problem.

Authentication errors after backing out changes for forms authentication

We attempted to run the custom authentication sample from the RS samples. We had issues and attempted to "back out" our changes - being stupid, we didn't back up our config files. "How hard could it be?" Well, 8 hours later, we're out of answers as to why we can't run RS anymore. Yes, learn from our mistake.

We're hoping someone can help us with the following.


When going to http://localhost/Reports, I get the following:

System.Web.Services.Protocols.SoapException: Server was unable to process request. > System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetExtensionConfigurationInfo(String extensionType, String extensionName) at Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension() at Microsoft.ReportingServices.WebServer.ReportingService2005..ctor() End of inner exception stack trace


When going to http://localhost/ReportServer, I get a 404.


The log file ReportServerWebApp__01_17_2006_15_33_40 contains the following stack dump:
'
aspnet_wp!ui!1!1/17/2006-15:34:06:: e ERROR: System.Web.Services.Protocols.SoapException: Server was unable to process request. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetExtensionConfigurationInfo(String extensionType, String extensionName)
at Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
at Microsoft.ReportingServices.WebServer.ReportingService2005..ctor()
End of inner exception stack trace
aspnet_wp!ui!1!1/17/2006-15:34:06:: e ERROR: HTTP status code --> 500
-Details--
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. > System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.GetExtensionConfigurationInfo(String extensionType, String extensionName)
at Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
at Microsoft.ReportingServices.WebServer.ReportingService2005..ctor()
End of inner exception stack trace

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()

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)
aspnet_wp!ui!1!1/17/2006-15:34:06:: 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)

I confirmed that the rsreportserver.config section that deals with security/authentication looks as follows - this matches another server whose RS is working:

<Security>
<Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization,Microsoft.ReportingServices.Authorization"/>
</Security>
<Authentication>
<Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication,Microsoft.ReportingServices.Authorization"/>
</Authentication>


And the web.configs in both ReportManager and ReportServer folders reference the correct authentication extension:

Report Manager web.config:
<authentication mode="Windows" />
<identity impersonate="true" />

Report Server web.config:
<authentication mode="Windows" />
<identity impersonate="true" />


At this point, I'm considering spinning up a second instance of RS to see if there's something more basic broken, but I thought I would ask for any help/pointers on this.

Thank you!

Michael Shorten

Just as a followup, in case someone else searches for this problem and finds my post - we never solved it. We recovered the config files to what they were supposed to be, but things never still worked. We now believe that we somehow deleted a file(s) - given the error message, that seems plausible. We ended up having to completely removed SQL Server and RS from our system, physically deleting the MSSQL and MSSQLRS directories and reinstalling. This time, we backed everything up before working on it and of course, it worked.

Michael S

sql

Authentication Error with HTTP EndPoints

I keep getting these errors when I try to access an
endpoint I created. I have double checked and it is setup
for integrated authentication, grant connect has been
done on the account I am trying to access as and I still
get this error.
Any ideas or suggestions are welcome and appreciated.
Walt
Event Type:Error
Event Source:MSSQLSERVER
Event Category:Logon
Event ID:26026
Date:6/4/2005
Time:7:36:37 PM
User:N/A
Computer:HWCVS17
Description:
HTTP authentication failed. [CLIENT: X.X.X.X]
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: aa 65 00 00 0e 00 00 00 e.....
0008: 08 00 00 00 48 00 57 00 ...H.W.
0010: 43 00 56 00 53 00 31 00 C.V.S.1.
0018: 37 00 00 00 00 00 00 00 7......
Hi Jim,
Could you please post the exact steps you performed to create the HTTP
EndPoints and the URL you used to connect to the SQL Server? This will help
us get a clear picture of the problem.
You may want to refer to the SQLXML chapter and sub-chapters in MSDN for
more information:
http://msdn.microsoft.com/library/en...nch_SQLXML.asp
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.

Authentication Error with HTTP EndPoints

I keep getting these errors when I try to access an
endpoint I created. I have double checked and it is setup
for integrated authentication, grant connect has been
done on the account I am trying to access as and I still
get this error.
Any ideas or suggestions are welcome and appreciated.
Walt
Event Type: Error
Event Source: MSSQLSERVER
Event Category: Logon
Event ID: 26026
Date: 6/4/2005
Time: 7:36:37 PM
User: N/A
Computer: HWCVS17
Description:
HTTP authentication failed. [CLIENT: X.X.X.X]
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: aa 65 00 00 0e 00 00 00 e.....
0008: 08 00 00 00 48 00 57 00 ...H.W.
0010: 43 00 56 00 53 00 31 00 C.V.S.1.
0018: 37 00 00 00 00 00 00 00 7......Hi Jim,
Could you please post the exact steps you performed to create the HTTP
EndPoints and the URL you used to connect to the SQL Server? This will help
us get a clear picture of the problem.
You may want to refer to the SQLXML chapter and sub-chapters in MSDN for
more information:
http://msdn.microsoft.com/library/e...anch_SQLXML.asp
Sincerely,
William Wang
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
This posting is provided "AS IS" with no warranties, and confers no rights.

Sunday, February 12, 2012

AttachDBfilename

I was getting SQL Server errors trying to run the Time Tracker kit, soI tried to establish a connection with the timetracker.mdf from the
VWD Database Explorer - but no luck:

Data Source: Microsoft SQL Server Database File (SqlClient)

Database File name: Visual Studio2005\WebSites\TimeTracker1\App_Data\TimeTracker.mdf

Using either Windows or SQLServer authentication, they both fail when I test the connection.

Any ideas ? I gave myself and the ASPNET account every permission possible in SQLServer.Create a connection from a datasource control to test it or add a connection in VWD in server explorer ( i hope they have that hehe I use VS.NET 2005 pro ). Test the connection until it works. I had to play with it until I got it to work but I had the same problem. Make sure you are saying that you want a user instantce. First make a connection to your db and make sure that works. Then try to attach with the db.