My Server Stop Responding Every Few Weeks
Mar 4, 2008
Hi,
i've this phenomenon that my SQL SERVER 2005 SP2 Build 3042 (W2K3 STD SP2) stop responding to connections.
when i make stop and start to the sql server service it's back to life.
when i observer the windows event log and sql events i see those errors
from windows eventvs
AppDomain 24 (system.dbo[runtime].24) is marked for unload due to memory pressure.
AppDomain 24 (system.dbo[runtime].24) unloaded.
SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for information about possible related problems. [CLIENT: 10.165.2.173]
from SQL events
SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for information about possible related problems. [CLIENT: 10.165.2.173]
Could not connect because the maximum number of '1' dedicated administrator connections already exists. Before a new connection can be made, the existing dedicated administrator connection must be dropped, either by logging off or ending the process. [CLIENT: 127.0.0.1]
SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for information about possible related problems. [CLIENT: <local machine>]
Unsafe assembly 'hebfilts, version=0.0.0.0, culture=neutral, publickeytoken=null, processorarchitecture=msil' loaded into appdomain 28 (system.dbo[runtime].28).
Plz help me
Thx
View 4 Replies
ADVERTISEMENT
Apr 4, 2008
Hi, This is my firs time in this forum, we are getting this error and my sql server stop responding to users,
we have upgraded our server from sql 2000 to sql 2005 in jan 2008 and since jan it waz working f9 but from last month we are facing this problem,
we have Windows 2003 32bit and sql 2005 on HP Proliant server with RAID.
Is this a hardware problem or something wrong with sql server 2005.
followin the msg from sql log
SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F: empdbdata empdb.mdf] in database [tempdb] (2). The OS file handle is 0x00000A20. The offset of the latest long I/O is: 0x000000097a0000
-masroor
View 7 Replies
View Related
Apr 8, 2007
Hi, I have a problem with the region settings on SQL Server Compact Edition.
To begin with, in my C# Windows Mobile app, I start with fetching records for the
current month from SQL Server 2005 Express. That works without any problems,
however, when I try to filter these records locally by weeknumber something happends
SQL Server CE uses Sunday as the first day of the week, which is inconvenient
since I live in Europe.
I tried to "SET DATEFIRST 1" in a query prior to the one fetching weekly records
but that just result in an exception.
Does anyone know how to change the regional settings on SQL Server CE?
View 1 Replies
View Related
Sep 30, 2015
I need to create a week calendar from date in SQL 2012. Week date starts with Sunday regardless if first Sunday or last Sunday overlaps with previous or next month. For example, the first week in Sep 2015 starts on Sunday 8/30/2015 and ends in 9/5/2015. Too, the last week of Sep 2015 starts on 9/27/2015 and ends on 10/3/2015. Here is the final format:
WeekStartdate WeekEndDate WeekName
8/30/2015 9/5/2015 Sep_Week1
9/6/2015 9/12/2015 Sep_Week2
.....
9/27/2015 10/3/2015 Sep_Week5
View 9 Replies
View Related
Feb 4, 2015
I'm having problems filtering in my MDX query.
My requirements are to return the sales for each customer for each store, for the past 6 weeks.
The catch is that I only want those customers which have had sales over 10,000 within the last week.
This is my query:
WITH SET [CustomerList] AS
FILTER(
([Store].[Store Name].[Store Name], [Customer].[Customer Name].[Customer Name]),
[Measures].[Sales] >= 10000
AND [Date].[Fiscal Week Name].&[2015-01-26 to 2015-02-01]
[Code] ....
The dates are hard-coded for testing purposes.
View 0 Replies
View Related
Sep 12, 2007
Hello everyone,
I've noticed some strange behavior on my SQL Server. A little background first:
This server is strictly used for SQL Server
Active/Passive cluster
Windows Server 2003 Enterprise w/ SP1
SQL 2005 Enterprise w/ SP2
8GB of total memory in the server, SQL Server has min: 4GB, max: 6GB
Disk drives are on a SAN
4 hyperthreaded, Xeon 1.4GHz proccessors
Now, the issue I'm seeing...
Every once in a while, my users will start to complain about application slowness and we'll start getting application timeouts. I'll look at my SQL server and my server stops responding for a time period of 8-9 seconds. One minute after the server 'wakes up', the process starts again where it will not respond for 8-9 seconds. The clock on the server stops refreshing then will jump to the current time, and in perfmon, there is an actual break in the counters. This does not happen at all times throughout the day, but I do need to find out a solution for this behavior.
During this 8-9 seconds, all processing is put on hold and continues when the server 'wakes up'. Any new connections to the server are accepted during this timeframe, but have to wait through this 'dead' time as well.
Any and all comments, suggestions, concerns, or things I could be looking at are appreciated.
Jarret
View 4 Replies
View Related
Jul 12, 2006
Hi,
RS 2005 (sql 2005 SP1) on Windows 2003 SP1
The report server was running ok until this morning. Its just giving a "The report server is not responding. Verify that the report server is running and can be accessed from this computer." message when trying to open the report manager.
Any ideas?
In the SQLDUMPER_ERRORLog.log file there is this..
05/22/06 12:53:35, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 328
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x47405860
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
05/22/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
05/22/06 12:53:36, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
05/22/06 12:53:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
05/22/06 12:53:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFilesSQLDmpr0001.mdmp
05/22/06 12:53:37, ACTION, w3wp.exe, Watson Invoke: No
View 18 Replies
View Related
Nov 5, 2007
When I am browsing the http://localhost/reports i am getting the errr
The report server is not responding. Verify that the report server is running and can be accessed from this computer.
This error came when i just in the IIS in reports(Right Click) application change the asp.net(Edit Configuration) on tab authentication from WINDOWS to FORM while though i reverted back mine changes to windows its stated giving me the above exception
Please provide me the solution .All the reports are stopped due to mine adventure..
View 3 Replies
View Related
Aug 10, 2006
Hello!
When I try to access http://localhost/reportserver, I get
Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The parameter is incorrect.
Can someone help me? Here is the log!
Thank you!
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.
.....
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Configuration Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>
<body bgcolor="white">
<span><H1>Server Error in '/ReportServer' Application.<hr width=100% size=1 color=silver></H1>
<h2> <i>Configuration Error</i> </h2></span>
<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">
<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
<br><br>
<b> Parser Error Message: </b>Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))<br><br>
<b>Source Error:</b> <br><br>
<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>
Line 27: <assemblies>
Line 28: <clear />
<font color=red>Line 29: <add assembly="ReportingServicesWebServer" />
</font>Line 30: </assemblies>
Line 31: </compilation></pre></code>
</td>
</tr>
</table>
<br>
<b> Source File: </b> C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerweb.config<b> Line: </b> 29
<br><br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
</font>
</body>
</html>
<!--
[ArgumentException]: Element does not specify a class.
at System.Security.Policy.PolicyLevel.GenericResolve(Evidence evidence, Boolean& allConst)
at System.Security.Policy.PolicyLevel.Resolve(Evidence evidence, Int32 count, Char[] serializedEvidence)
at System.Security.PolicyManager.CodeGroupResolve(Evidence evidence, Boolean systemPolicy)
at System.Security.PolicyManager.ResolveHelper(Evidence evidence)
at System.Security.HostSecurityManager.ResolvePolicy(Evidence evidence)
at System.Security.PolicyManager.Resolve(Evidence evidence)
at System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Boolean checkExecutionPermission)
at System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Int32& securitySpecialFlags, Boolean checkExecutionPermission)
[FileLoadException]: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG))
at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
at System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective)
[ConfigurationErrorsException]: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG)) (C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerweb.config line 29)
at System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective)
at System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai)
at System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig)
at System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName)
at System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp)
at System.Web.Compilation.BuildManager.CompileGlobalAsax()
at System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled()
[HttpException]: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG)) (C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerweb.config line 29)
at System.Web.Compilation.BuildManager.ReportTopLevelCompilationException()
at System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled()
at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters)
[HttpException]: Could not load file or assembly 'ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG)) (C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesReportServerweb.config line 29)
at System.Web.HttpRuntime.FirstRequestInit(HttpContext context)
at System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context)
at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
View 6 Replies
View Related
Apr 15, 2008
Can't figure this one out. SSMSEE just stopped working. It's been working fine for about a year. All of a sudden I am getting a 'Not Responding' message and it hangs up. I can still get to the database with other 3rd party tools, so I don't think anything is wrong with the database. All the SQL Server services are still running. I tried repairing the installation. Didn't work. I uninstalled it and then reinstalled it from scratch and it still doesn't work. Anyone have any ideas how I can proceed from here to find out what's wrong?
View 1 Replies
View Related
Apr 9, 2002
Can anyone help me?
My brand new installation of SQL Server 6.5 running on Windows 2000 suddenly stops working for about 6 minutes, in this periods no one can use SQL 6.5 services because it stops responding. My logs is show below:
2002/04/08 15:50:22.60 ods Error : 17832, Severity: 18, State: 0
2002/04/08 15:50:22.60 ods Unable to read login packet(s).
2002/04/08 15:50:24.50 ods Error : 17832, Severity: 18, State: 0
2002/04/08 15:50:24.50 ods Unable to read login packet(s).
2002/04/08 15:50:26.79 ods Error : 17832, Severity: 18, State: 0
2002/04/08 15:50:26.79 ods Unable to read login packet(s).
2002/04/09 07:10:21.48 ods Error : 17832, Severity: 18, State: 0
2002/04/09 07:10:21.48 ods Unable to read login packet(s).
2002/04/09 07:53:33.76 ods Error : 17824, Severity: 10, State: 0
2002/04/09 07:53:33.76 ods Unable to write to ListenOn connection '.pipesqlquery', loginname 'sa', hostname '2M_ROSANNA'.
2002/04/09 07:53:33.76 ods OS Error : 232,
2002/04/09 07:53:33.78 spid75 Error : 1608, Severity: 21, State: 2
2002/04/09 07:53:33.78 spid75 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
2002/04/09 07:53:41.10 ods Error : 17824, Severity: 10, State: 0
2002/04/09 07:53:41.10 ods Unable to write to ListenOn connection '.pipesqlquery', loginname 'sa', hostname 'CE_SANDRA'.
2002/04/09 07:53:41.10 ods OS Error : 232,
2002/04/09 07:53:41.10 spid80 Error : 1608, Severity: 21, State: 2
2002/04/09 07:53:41.10 spid80 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
2002/04/09 07:55:42.20 ods Error : 17824, Severity: 10, State: 0
2002/04/09 07:55:42.20 ods Unable to write to ListenOn connection '.pipesqlquery', loginname 'sa', hostname 'CE_SANDRA'.
2002/04/09 07:55:42.20 ods OS Error : 232,
2002/04/09 07:55:42.20 spid53 Error : 1608, Severity: 21, State: 2
2002/04/09 07:55:42.20 spid53 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
2002/04/09 07:57:09.40 ods Error : 17824, Severity: 10, State: 0
2002/04/09 07:57:09.40 ods Unable to write to ListenOn connection '.pipesqlquery', loginname 'sa', hostname 'FE_FERTILIDAD'.
2002/04/09 07:57:09.40 ods OS Error : 232,
2002/04/09 07:57:09.40 spid91 Error : 1608, Severity: 21, State: 2
2002/04/09 07:57:09.40 spid91 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
2002/04/09 07:57:09.40 ods Error : 17824, Severity: 10, State: 0
2002/04/09 07:57:09.40 ods Unable to write to ListenOn connection '.pipesqlquery', loginname 'sa', hostname 'SF_ROSA'.
2002/04/09 07:57:09.40 ods OS Error : 232,
2002/04/09 07:57:09.40 spid11 Error : 1608, Severity: 21, State: 2
2002/04/09 07:57:09.40 spid11 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
2002/04/09 07:57:36.04 ods Error : 17824, Severity: 10, State: 0
2002/04/09 07:57:36.04 ods Unable to write to ListenOn connection '.pipesqlquery', loginname 'sa', hostname 'CE_MILAGROS'.
2002/04/09 07:57:36.04 ods OS Error : 232,
2002/04/09 07:57:36.04 spid60 Error : 1608, Severity: 21, State: 2
2002/04/09 07:57:36.04 spid60 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
The problems begin on 2002/04/09 at 7:53am. and it respond again at 7:57, there's no need to restart the service.
I will appreciate some help here.
View 1 Replies
View Related
Nov 30, 2007
Firstly I should say my Reporting Services were working fine until I changed a setting in IIS today - under the Virtual Directory for the site I clicked Properties>ASP.NET>Edit Configuration. Changed 'Authentication' to Forms and everything went wrong; changing it back to Windows made no difference.
Now when trying to navigate to Report Server / Report Manager I get these errors:
RS : An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Object reference not set to an instance of an object.
RM: The report server is not responding. Verify that the report server is running and can be accessed from this computer.
Following advice found elsewhere on the web, I checked my web.config file for an an erroneous xmlns entry... but it wasn't there. I have also deleted/recreated my virtual directories from within IIS/RSC. Also I have done a basic reinstall of Reporting Services (from within Add/Remove Programs>Change).
Below are my error logs and the listings for my web.config files; hopefully these will be of use in working out where the problem lies - I really need to get this fixed as soon as possible.
Thanks in advance,
Dan
SQLDmpor####.log
w3wp!library!1!11/30/2007-20:22:40:: i INFO: Exception dumped to: d:AppsSQL2005MSSQL.2Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
w3wp!library!1!11/30/2007-20:22:40:: 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.Library.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)
at Microsoft.ReportingServices.Library.WebConfigUtil.GetAuthenticationType()
at Microsoft.ReportingServices.Library.WebConfigUtil.get_UsingWindowsAuth()
at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()
at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)
SQLDUMPER_ERRORLOG.log
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: d:AppsSQL2005MSSQL.2Reporting ServicesLogFilesSQLDmpr0121.mdmp
11/30/07 20:22:40, ACTION, w3wp.exe, Watson Invoke: Yes
11/30/07 20:22:40, ACTION, w3wp.exe, Watson Invoked: C:PROGRA~1COMMON~1MICROS~1DWDW20.EXE dw20.exe -d "d:AppsSQL2005MSSQL.2Reporting ServicesLogFilesSQLDmpr0121.mft"
11/30/07 20:22:40, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 4696
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x47405860
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
11/30/07 20:22:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: d:AppsSQL2005MSSQL.2Reporting ServicesLogFilesSQLDmpr0122.mdmp
11/30/07 20:22:40, ACTION, w3wp.exe, Watson Invoke: Yes
11/30/07 20:22:40, ACTION, w3wp.exe, Watson Invoked: C:PROGRA~1COMMON~1MICROS~1DWDW20.EXE dw20.exe -d "d:AppsSQL2005MSSQL.2Reporting ServicesLogFilesSQLDmpr0122.mft"
web.config (ReportManager)
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="MicrosoftWebControls" type="System.Configuration.NameValueSectionHandler, System, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=##############, processorArchitecture=MSIL"/>
<section name="RStrace" type="Microsoft.ReportingServices.Diagnostics.RSTraceSectionHandler,Microsoft.ReportingServices.Diagnostics"/>
<section name="UIConfig" type="Microsoft.ReportingServices.UI.UIConfigSectionHandler,ReportingServicesWebUserInterface"/>
</configSections>
<system.net>
<defaultProxy enabled="false"/>
</system.net>
<system.web>
<pages validateRequest="false"/>
<compilation defaultLanguage="c#" debug="false"/>
<customErrors mode="Off"/>
<authentication mode="Windows"/>
<identity impersonate="true"/>
<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true"/>
<sessionState mode="InProc" cookieless="false" timeout="20"/>
<globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
<httpRuntime executionTimeout="9000"/>
<securityPolicy>
<trustLevel name="RosettaMgr" policyFile="rsmgrpolicy.config"/>
</securityPolicy>
<trust level="RosettaMgr" originUrl=""/>
<httpHandlers>
<add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=##############"/>
</httpHandlers>
</system.web>
<appSettings>
<add key="ReportViewerServerConnection" value="Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=##############"/>
<add key="ReportViewerTemporaryStorage" value="Microsoft.ReportingServices.UI.ReportViewerTemporaryStorage, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=##############"/>
</appSettings>
<RStrace>
<add name="FileName" value="ReportServerWebApp_"/>
<add name="Prefix" value="tid, time"/>
<add name="TraceListeners" value="debugwindow, file"/>
<add name="TraceFileMode" value="unique"/>
<add name="Components" value="all"/>
</RStrace>
<system.diagnostics>
<switches>
<!-- 1 = error, 2 = warning, 3 = info, 4 = verbose -->
<add name="DefaultTraceSwitch" value="3"/>
</switches>
</system.diagnostics>
<runtime>
<assemblyBinding xmlns="urnchemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.ReportingServices.Interfaces" publicKeyToken="##############" culture="neutral"/>
<bindingRedirect oldVersion="8.0.242.0" newVersion="9.0.242.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>
web.config (ReportServer)
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<section name="RStrace" type="Microsoft.ReportingServices.Diagnostics.RSTraceSectionHandler,Microsoft.ReportingServices.Diagnostics" />
</configSections>
<system.diagnostics>
<switches>
<!-- 1 = error, 2 = warning, 3 = info, 4 = verbose -->
<add name="DefaultTraceSwitch" value="3" />
</switches>
<assert assertuienabled="false" />
</system.diagnostics>
<RStrace>
<add name="FileName" value="ReportServer_" />
<add name="FileSizeLimitMb" value="32" />
<add name="KeepFilesForDays" value="14" />
<add name="Prefix" value="tid, time" />
<add name="TraceListeners" value="debugwindow, file" />
<add name="TraceFileMode" value="unique" />
<add name="Components" value="all,RunningJobs:3,SemanticQueryEngine:2,SemanticModelGenerator:2" />
</RStrace>
<system.web>
<pages validateRequest="false" />
<identity impersonate="true" />
<compilation defaultLanguage="c#">
<assemblies>
<clear />
<add assembly="ReportingServicesWebServer" />
</assemblies>
</compilation>
<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />
<httpHandlers>
<add verb="*" path="Reserved.ReportServer" type="Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler, ReportingServicesWebServer" />
<add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=##############" />
</httpHandlers>
<httpModules></httpModules>
<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
<httpRuntime executionTimeout="9000" />
<securityPolicy>
<trustLevel name="RosettaSrv" policyFile="rssrvpolicy.config" />
</securityPolicy>
<trust level="RosettaSrv" originUrl="" />
</system.web>
<runtime>
<legacyImpersonationPolicy enabled="true"/>
<assemblyBinding xmlns="urnchemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.ReportingServices.Interfaces"
publicKeyToken="##############"
culture="neutral" />
<bindingRedirect oldVersion="8.0.242.0"
newVersion="9.0.242.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>
View 3 Replies
View Related
Sep 1, 2015
I fail to view my deployed report from my computer. And then I remotely go to Report Manager (localhost/ Reports_MSSQLSERVER/ Pages/Folder. aspx) and get error msg "The report server is not responding. Verify that the report server is running and can be accessed from this computer."
View 3 Replies
View Related
Dec 15, 2007
Hi All,
I am having exchange server 2003.
With following details.
1.Operating System 2003 standerd with sp2.
2.Exchange server 2003. Service pack don't know ( How to check)
From last 2 months, every two days my exchange server stops responding to clients.
When I check the services, all the Exchange related services are ON. ( they are running fine).
Then I use to Restart All excahnge related services, i.e Microsoft Exchange Information Store & Ms Exchange System Attended service and things starts working fine again.
This I have to do every 2 days.
I don't know why this is happening.
Can anyone assist me to resolve as it is getting critical day-by-day.
Also How can I check which service pack of exchange is installed.
Many Thanks
Muzaffar
Network Admin.
Carrier - Saudi Arabia.
View 2 Replies
View Related
Apr 15, 2008
Can't figure this one out. SSMSE just stopped working. It's been working fine for about a year. Now, I am getting a 'Not Responding' message and it hangs up.
I can still get to the database with other 3rd party tools, so I don't think anything is wrong with the database. All the SQL Server services are still running. I restarted all the services and it didn't help. I tried repairing the SSMSE installation and the problem is the same. Didn't work. I uninstalled it and then reinstalled it from scratch and it still doesn't work. Anyone have any ideas how I can proceed from here to find out what's wrong?
View 1 Replies
View Related
May 30, 2015
We are using sql server 2008r2 standard edition.
We have replication set up. Publisher and distributor are on the same server, subscriber is in different server.
Suddenly the replication started failing and continued more than 12 hrs. When I tried to connect to the subscriber server, I am able to connect to the server but not able to run any queries or not able to open the error log from SSMS.
Is there any way to find from the default trace why the replication failed and the server is not responded?
What columns do I need to query from the trace?
View 5 Replies
View Related
Jan 15, 2008
For a week now, I have been reading every fix I can find for the infamous Reporting Services error(s) and none of the fixes have worked for me. I have checked permissions and memberships of the reporting services groups, removed xmlns as mentioned, made sure that the Classic App Pool was being used, started, stopped, reinstalled, made sure the RSWebApplication.config had the URL or not, either way nothing is working for me.
Is there some place where all of the various fixes are consolidated? Can anyone help me? I'm dying over here. It worked on a previous image and I rebuilt it and can't get it to work. I have SQL 2005 sp2 on Vista...all of the IIS requirements are met and the RS configuration utility reports that everything is fine.
Thanks,
Eric
View 2 Replies
View Related
Nov 10, 2006
Hi,
Sorry for the long post but I'll try to give a maximum of information.
I've tried to implement Form Authentication for Reporting Services. Right now, just about everything works as I would hope for, i.e.:
When I try to access http://<server>/ReportServer$SQLSERVER_2005, I am redirected to the authentication form.
When successfully authenticated, I can access the report
I can display reports throught the ReportViewer Web control by passing the authentication cookie.
Etc.
(Note: My implementation of Form Authentication was inspired by http://www.devx.com/dotnet/Article/26759/0/page/1 which seems similar to Microsoft Sample)
(The $SQLSERVER_2005 suffix is because SQL Server 2000 is also installed on the server, but I don't think Reporting Services 2000 is installed)
There is one thing which does not work however and it is the Report Manager.
When I try to access http://<server>/Reports$SQLSERVER_2005, I would expect to be redirected to the /Pages/UILogon.aspx page. Instead, I get an error page with the following message:
"The report server is not responding. Verify that the report server is running and can be accessed from this computer."
Both ReportServer and Reports are on the same server, both have the same security on the folder and in IIS (6.0), both have Anonymous security access "checked".
If I revert to the old .config files (prior to my modifications for Form Authentication) and remove Anonymous from IIS for both sites, everything works fine (like it did after the installation).
Here are excerpts from the config files I've modified in ReportManager:
RSWebApplication.config:
<UI>
<CustomAuthenticationUI>
<loginUrl>/Pages/UILogon.aspx</loginUrl>
<UseSSL>False</UseSSL>
</CustomAuthenticationUI>
<ReportServerUrl>http://<servername>/ReportServer$SQLSERVER_2005</ReportServerUrl>
</UI>
rsmgrpolicy.config:
<CodeGroup
class="FirstMatchCodeGroup"
version="1"
PermissionSetName="FullTrust"
Description="This code group grants MyComputer code Execution permission. ">
<IMembershipCondition
class="ZoneMembershipCondition"
version="1"
Zone="MyComputer" />
Web.config:
<identity impersonate="false" />
Here is the content of the log ReportServerWebApp_*.log (see error in bold):
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesLogFilesReportServerWebApp__11_10_2006_08_32_34.log</Path>
<SystemName>MSCAPP02</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: 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!5!11/10/2006-08:32:35:: 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!5!11/10/2006-08:32:35:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!5!11/10/2006-08:32:35:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!5!11/10/2006-08:32:39:: 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!11/10/2006-08:32:39:: 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)
w3wp!ui!5!11/10/2006-08:32:40:: 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)
So that's it. Thanks for any help you can provide.
Nicolas
View 16 Replies
View Related
Apr 11, 2007
Hi -
I got through the installation hoops for SQLEXPRESS Reporting Services in Vista and set up the default configurations in Report Services Configuration. I can explore the default directory for "Reports" in IIS7, but I can't browse in IE. I get the "The report server is not responding. verify that the report server..." message in the browser. This is after I migrated the app per the initial http 500 error using the preferred method - %systemroot%system32inetservAPPCMD.exe migrate config "Default Web Site/Reports".
I'm running Vista Ultimate, VS2005, SQLEXPRESS SP2. I've tried running IE as admin and also I've disabled UAC from gpedit.msc - ...Windows SettingsSecurity SettingsLocal PolicySecurity Options and unchecking UAC.
Thanks,
Mike
View 13 Replies
View Related
Apr 23, 2001
Hi all,
I am developing a 3-tier web app (IIS, MTS, SQLServer7). My problem is SQL Server 7 is not responding to MTS Server when there is a firewall in between.
However, when the firewall is removed, everything works fine, therefore I think the problem is not caused by the code.
I am very sure that port 1433 (the default port used by SQL7) is open in the firewall.
Please help because I am stuck with this problem for weeks and really stressed out.
Thanks in advance.
William
View 2 Replies
View Related
Mar 6, 2008
hi,
how can I get the first day of the week 12 weeks ago ?
View 10 Replies
View Related
Dec 12, 2007
do you mean first install SDK, then install IIS, then install report sever?
I have same problem.
any can help?
View 1 Replies
View Related
Mar 7, 2008
Im trying to get out all peoples names whos birthdays are coming up in the next 2 weeks, can anyone tell me why this : SELECT FullNameFROM UsersWHERE (CONVERT(datetime, DOBMonth + '/' + DOBDay + '/' + DOBYear) >= DATEADD(dd, -14, GETDATE())) AND (CONVERT(datetime, DOBMonth + '/' + DOBDay + '/' + DOBYear) <= DATEADD(day, 0, GETDATE()))returns nothing when I know theres a few birthdays that should be returned. Thanks Si!
View 2 Replies
View Related
Nov 26, 2004
This is one thats got me perplexed...
I need to find out all the weeks in a year,
then for each week work out the numbers of records entered into the table that week that fit a certain criteria,
and then report back the dates involved and the amount of records that were counted! Phew...
Basically I'm trying to find the week in a year(s) that had the most records entered into the table during that week...
And I'm stuck, I've got it working with individual dates but is it possible to group those dates into weeks???
Any help would be appreciated...
Cheers
View 6 Replies
View Related
Apr 28, 2008
hey all
i am trying to get a filter in a report that return the last 14 complete weeks. so sunday through to Monday but only display this week once it's comlete next week. i have this
FTDW.dbo.day.sql_date < dateadd(w,-1,getdate()) and FTDW.dbo.day.sql_date > dateadd(w,-15,getdate())
but i get incomplete week 3 and last week. any ideas?
View 2 Replies
View Related
May 23, 2008
I'm trying to find a simple way to see if a date in a week. I would like to try something like this, but haven't gotten it to work yet:
case when snapshot_date in (datepart(week,getdate())) then 'yes' else 'no' end as week1,
case when snapshot_date in (datepart(week,getdate())-1) then 'yes' else 'no' end as week2
What am I doing wrong and how would I correctly go about this?
View 5 Replies
View Related
Jul 20, 2005
SQL Server 2000 SP3Hi,How can I get the cumulative weeks from a givedate to the currentdate. I know I can get the weeknumber by using datepart(wk,getdate())but this will giveme the week number for this year. What if I want to know the number ofweeksthat have passed since june 1 2001. If I use datepart(wk,'20010106') Iwillget the week number for 2001 but I would like the number of weeksexpired between then now.Thanks,Reg
View 1 Replies
View Related
Sep 24, 2007
hi
i want to write query in such way that if employee who not worked from last 4 or 6 week will listed...
how we can do this?
thanx
View 10 Replies
View Related
Oct 9, 2007
When I trying to configure Reposrting services in IIS & XP. It hsows me error
"The report server is not responding. Verify that the report server is running and can be accessed from this computer."
I also configure with reposrting configuration tools which show all confuguration is perfect.
but when I try to open through IE http://localhost/Reports/Pages/Folder.aspx
or http://localhost/Reportserver
It shows error. I try all ways still not works ..Help me out
Thanks.
View 9 Replies
View Related
Feb 2, 2004
Hi all,
I have a problem with datepart. I want to obtain the week from one date. I have seen the documentation about datepart and the problem with the week counter but I have still problems.
For example.
I want to get the week from this date 29 Dec 2003. This week with DATEFIRST=1 must be the first of 2004 (datepart(ww,'12/29/2003')) but the system give me the 53 week from 2003
the first day of 2004 is on the same week an this function give me different results.
SELECT datepart(ww,'12/29/2003')
SELECT datepart(ww,'1/1/2004')
I don't understand anything ¿?
Thanks a lot.
View 2 Replies
View Related
Dec 23, 2012
I should check that the the number weeks of work for the five names is the same for all... that is, there can not be a person who works more or less of other...
I create a table `tbl_dates` where the primary key is the date and another field used for the holiday.
How do distribute equally these five names for the working weeks in the year?
[URL] ....
View 1 Replies
View Related
Apr 22, 2008
hi, I am trying to group my data into weeks in a month.
I am using :
GROUP BY DateAdd(day, -1 * datepart(dw, convert(char(10),date1,23)),
convert(char(10),date1,23))
Which works ok, but my first day is the monday of each week.
Do you know how I can group by weeks,
where dates run from monday to sunday ?
So IN march I would have
week begin 3/3
week begin 10/3
week begin 17/3
week begin 24/3
week begin 31/3
But for the last day I only want to count the 31st, not the entire week.
Same goes for the beginning of the month,
eg for april, I want it to show as week beginning 31st march but I only count aprils data.
I hope that makes sense.
can you help ?
View 3 Replies
View Related
Nov 21, 2007
All,
I am trying to design a graph to shows out build status for past 7-8 weeks. I have to write the SQL query first.
After spending a good chunk of time, I could get some basic chart going. Problem is that I could give it a starting time till now (static) but I am not sure how to get the results for past 7-8 wekks.
1) What is a good approach for this since time is not static and it is changing.
any example or piece of sql syntax is greately appreciated.
Thaks in advance,
aa-
View 6 Replies
View Related
