internal error after applying post Sp2 fix KB901383-v8.00.1042

This is the error from the logfile. Any idea anyone?
w3wp!webserver!1228!08/16/2005-15:27:04:: e ERROR: Internal error:
System.MissingMethodException: Method not found: Int32
Microsoft.ReportingServices.Library.Global.get_ResponseBufferSizeBytes().
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
w3wp!library!1228!08/16/2005-15:27:04:: 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.MissingMethodException: Method not found: Int32
Microsoft.ReportingServices.Library.Global.get_ResponseBufferSizeBytes().
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
-- End of inner exception stack trace --I had previously installed Sp2 and the server worked fine. The installer
package for KB901383 would not install (reported some error about components
not included in package), so I extracted that file and found a xxx.msp file
which semed to install fine. I restarted the server and now when I try to
show a report then the result is:
* An internal error occurred on the report server. See the error log
for more details. (rsInternalError) Get Online Help
o Method not found: Int32
Microsoft.ReportingServices.Library.Global.get_ResponseBufferSizeBytes().
"Fredrik" wrote:
> This is the error from the logfile. Any idea anyone?
> w3wp!webserver!1228!08/16/2005-15:27:04:: e ERROR: Internal error:
> System.MissingMethodException: Method not found: Int32
> Microsoft.ReportingServices.Library.Global.get_ResponseBufferSizeBytes().
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> w3wp!library!1228!08/16/2005-15:27:04:: 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.MissingMethodException: Method not found: Int32
> Microsoft.ReportingServices.Library.Global.get_ResponseBufferSizeBytes().
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> at
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> -- End of inner exception stack trace --

interesting sql login issue

Hi all,
I have a SQL 2005 server running on SERVERA. I have the management studio
installed on my desktop (Windows XP Pro SP2) and connect to the sql server
using my regular domain login account (windows auth). This worked fine until
I had to change my domain user account's password as it had expired (we have
to change it every 90 days). Now, ever since then, I have been unable to
connect to the sql server in management studio. I get:-
Login Failed for user ''. Error: 18452
If I remote into the server and try to connect to sql it works fine (I am
member of local admin group on the server)
Any ideas'http://support.microsoft.com/kb/555332
Is it possible that you have your Windows auth password hardcoded somewhere?
When worse comes to worse, you may have to drop and re-create your login on
a
SQL Server.
"param@.community.nospam" wrote:

> Hi all,
> I have a SQL 2005 server running on SERVERA. I have the management studio
> installed on my desktop (Windows XP Pro SP2) and connect to the sql server
> using my regular domain login account (windows auth). This worked fine unt
il
> I had to change my domain user account's password as it had expired (we ha
ve
> to change it every 90 days). Now, ever since then, I have been unable to
> connect to the sql server in management studio. I get:-
> Login Failed for user ''. Error: 18452
> If I remote into the server and try to connect to sql it works fine (I am
> member of local admin group on the server)
> Any ideas'
>
>|||Can you connect from the command line with sqlcmd?
It may also be worth a try of deleting the registration and
reregistering the server.
-Sue
On Wed, 21 Mar 2007 14:50:49 -0500, <param@.community.nospam>
wrote:

>Hi all,
>I have a SQL 2005 server running on SERVERA. I have the management studio
>installed on my desktop (Windows XP Pro SP2) and connect to the sql server
>using my regular domain login account (windows auth). This worked fine unti
l
>I had to change my domain user account's password as it had expired (we hav
e
>to change it every 90 days). Now, ever since then, I have been unable to
>connect to the sql server in management studio. I get:-
>Login Failed for user ''. Error: 18452
>If I remote into the server and try to connect to sql it works fine (I am
>member of local admin group on the server)
>Any ideas'
>|||What do you mean by hardcoded? I just login to my workstation using my
windows domain login and password?
I have tried dropping and re-creating the login in SQL Server.
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:D1639F71-646C-4286-983F-87AF7C25360A@.microsoft.com...[vbcol=seagreen]
> http://support.microsoft.com/kb/555332
> Is it possible that you have your Windows auth password hardcoded
> somewhere?
> When worse comes to worse, you may have to drop and re-create your login
> on a
> SQL Server.
> "param@.community.nospam" wrote:
>|||If you notice the username is empty in the error message below. Could it be
a bug where management studio is not passing credentials to the server?
"Leon Shargorodsky" <LeonShargorodsky@.discussions.microsoft.com> wrote in
message news:D1639F71-646C-4286-983F-87AF7C25360A@.microsoft.com...[vbcol=seagreen]
> http://support.microsoft.com/kb/555332
> Is it possible that you have your Windows auth password hardcoded
> somewhere?
> When worse comes to worse, you may have to drop and re-create your login
> on a
> SQL Server.
> "param@.community.nospam" wrote:
>

Integration with Sharepoint Server 2007 - Second instance of servi

Ok, I have a SQL 2005 sp2 server running reporting service on one server, and
Sharepoint Portal 2007 on another server. As I have reports setup and want
to continue using reports manager, I installed a second instance of Report
services on my SQL server. I installed Portal server on the SQL server (as
front end server) and it appears as a member of the Sharepoint farm. I setup
a new database using the Reporting services Config wizard in integrated mode.
I am using a domain user for the windows and web service accounts.
On the sql server when browsing to the virtual directory for the reports
server "http://servername/reportserver" I get the following error:
"The report server has encountered a configuration error. See the report
server log files for more information. (rsServerConfigurationError) Get
Online Help "
from other network locations, I get a request for authentication that always
fails.
The log file contains the following:
w3wp!webserver!1!6/11/2007-10:24:13:: i INFO: Reporting Web Server started
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing ConnectionType to
'0' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing IsSchedulingService
to 'True' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing IsEventService to
'True' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing PollingInterval to
'10' second(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
WindowsServiceUseFileShareStorage to 'False' as specified in Configuration
file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing MemoryLimit to '60'
percent as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing MaximumMemoryLimit
to '80' percent as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing MaxQueueThreads to
'0' thread(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing IsWebServiceEnabled
to 'True' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing MaxScheduleWait to
'5' second(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration
file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing RunningRequestsAge
to '30' second(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing CleanupCycleMinutes
to '10' minute(s) as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
because it was not specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing WatsonFlags to
'1064' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
WatsonDumpOnExceptions to
'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
WatsonDumpExcludeIfContainsExceptions to
'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing DisplayErrorLink to
'True' as specified in Configuration file.
w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!6/11/2007-10:24:13:: i INFO: Reporting Services
starting SKU: Standard
w3wp!resourceutilities!1!6/11/2007-10:24:13:: i INFO: Evaluation copy: 0
days left
w3wp!resourceutilities!1!6/11/2007-10:24:13:: i INFO: Running on 1 physical
processors, 2 logical processors
w3wp!runningjobs!1!6/11/2007-10:24:13:: i INFO: Database Cleanup (Web
Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!6/11/2007-10:24:13:: i INFO: Running Requests Scavenger
timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!6/11/2007-10:24:13:: i INFO: Running Requests DB timer
enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!6/11/2007-10:24:13:: i INFO: Memory stats update timer
enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1!06/11/2007-10:24:14:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information., SharePoint content service is null.
Report Server may not have joined the SharePoint farm, or Report Server
service account may not have been granted access to farm.;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information.
w3wp!library!7!6/11/2007-10:25:13:: i INFO: Catalog SQL Server Edition = Standard
I have read a large number of posts, and went through installation steps
repeatedly. I setup SPN for the webservice account. I just can't see what I
am missing.
Please advise.
--
Fredrick A. Zilz
Director IT
InterHealth N.I.I made one step forward. I found I had a duplicate SPN which was preventing
a log in to the Reportserver web site. So I can now browse to the
http://machinename/reportserver site. I am, however still not able to set
the default settings on the Sharepoint Portal side. I may need to move this
to a sharepoint group.
Thanks in advance for any advice.
--
Fredrick A. Zilz
Director IT
InterHealth N.I.
"Fred Zilz" wrote:
> Ok, I have a SQL 2005 sp2 server running reporting service on one server, and
> Sharepoint Portal 2007 on another server. As I have reports setup and want
> to continue using reports manager, I installed a second instance of Report
> services on my SQL server. I installed Portal server on the SQL server (as
> front end server) and it appears as a member of the Sharepoint farm. I setup
> a new database using the Reporting services Config wizard in integrated mode.
> I am using a domain user for the windows and web service accounts.
> On the sql server when browsing to the virtual directory for the reports
> server "http://servername/reportserver" I get the following error:
> "The report server has encountered a configuration error. See the report
> server log files for more information. (rsServerConfigurationError) Get
> Online Help "
> from other network locations, I get a request for authentication that always
> fails.
> The log file contains the following:
> w3wp!webserver!1!6/11/2007-10:24:13:: i INFO: Reporting Web Server started
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing ConnectionType to
> '0' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing IsSchedulingService
> to 'True' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> IsNotificationService to 'True' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing IsEventService to
> 'True' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing PollingInterval to
> '10' second(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> WindowsServiceUseFileShareStorage to 'False' as specified in Configuration
> file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing MemoryLimit to '60'
> percent as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing RecycleTime to
> '720' minute(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing MaximumMemoryLimit
> to '80' percent as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing MaxQueueThreads to
> '0' thread(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing IsWebServiceEnabled
> to 'True' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing MaxScheduleWait to
> '5' second(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> ProcessRecycleOptions to '0' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration
> file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing RunningRequestsAge
> to '30' second(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing CleanupCycleMinutes
> to '10' minute(s) as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> DailyCleanupMinuteOfDay to default value of '120' minutes since midnight
> because it was not specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing WatsonFlags to
> '1064' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> WatsonDumpOnExceptions to
> 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'
> as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> WatsonDumpExcludeIfContainsExceptions to
> 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'
> as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> SecureConnectionLevel to '0' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing DisplayErrorLink to
> 'True' as specified in Configuration file.
> w3wp!library!1!6/11/2007-10:24:13:: i INFO: Initializing
> WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
> w3wp!resourceutilities!1!6/11/2007-10:24:13:: i INFO: Reporting Services
> starting SKU: Standard
> w3wp!resourceutilities!1!6/11/2007-10:24:13:: i INFO: Evaluation copy: 0
> days left
> w3wp!resourceutilities!1!6/11/2007-10:24:13:: i INFO: Running on 1 physical
> processors, 2 logical processors
> w3wp!runningjobs!1!6/11/2007-10:24:13:: i INFO: Database Cleanup (Web
> Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
> w3wp!runningjobs!1!6/11/2007-10:24:13:: i INFO: Running Requests Scavenger
> timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
> w3wp!runningjobs!1!6/11/2007-10:24:13:: i INFO: Running Requests DB timer
> enabled: Next Event: 60 seconds. Cycle: 60 seconds
> w3wp!runningjobs!1!6/11/2007-10:24:13:: i INFO: Memory stats update timer
> enabled: Next Event: 60 seconds. Cycle: 60 seconds
> w3wp!library!1!06/11/2007-10:24:14:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The report server has encountered a configuration error. See the report
> server log files for more information., SharePoint content service is null.
> Report Server may not have joined the SharePoint farm, or Report Server
> service account may not have been granted access to farm.;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
> The report server has encountered a configuration error. See the report
> server log files for more information.
> w3wp!library!7!6/11/2007-10:25:13:: i INFO: Catalog SQL Server Edition => Standard
>
> I have read a large number of posts, and went through installation steps
> repeatedly. I setup SPN for the webservice account. I just can't see what I
> am missing.
> Please advise.
>
> --
> Fredrick A. Zilz
> Director IT
> InterHealth N.I.