Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fatalpuls3
Starting Member
6 Posts |
 Posted - 2010-06-09 : 15:10:06
|
| I have a deployment of XPe with SQL Server 2008 with Advance Services and Reporting Services installed and operating. We have noticed that every so many days (dont know exactly how many) we have to cycle the reporting services service to get the report server to serve up reports. Today we experienced a: Reporting services 2008 http status 401: Unauthorized error after attempting to log in with a successful login name and password. I cycled the service and was able to log in again and pull reports using the same login name and password. We are using the following configuration in the Report Server Configuration windows:-Service account: Network service-Webservice url Computername:8080\ReportServer_SQLEXPRESS-It is installed in Native ModeAny insight to this would be greatly appreciated as it is plaguing out support department and inadvertantly me since i have to go in and recent the service. |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-06-09 : 15:16:56
|
| If I understand your question, the Windows operating systems are know to have very poor memory management algorithms.The company I work for specifically does not use SQL Server because the dbms only runs on Windows and not any other platforms(unix, linux, etc).Windows servers need to be re-booted every few days.______________________________________________Talk sense to a fool and he calls you foolish. |
 |
|
|
fatalpuls3
Starting Member
6 Posts |
Posted - 2010-06-09 : 15:54:58
|
| Thanks for the reply. I understand windows systems have very poor memory management and Sql reporting services.exe can grow to enormous amounts of memory usage after running reports for a few days. |
|
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-06-09 : 16:01:10
|
| I believe in your initial post you stated that you recycled(stopped then re-started the service), which is a bit different then re-booting your server. I'm not a hardware or technical guru.______________________________________________Talk sense to a fool and he calls you foolish. |
|
|
|
fatalpuls3
Starting Member
6 Posts |
Posted - 2010-06-09 : 16:05:25
|
| For those looking at this post, i still need a resolution. I havent found the solution or culprit as of now. |
|
|
|
|
|
|
Reporting Services 2008 on XPe gets in bad state