Emails Are Being Lost - Not Sent

I am running SQL Server 2000 Reporting Services SP2.
I have data driven subscriptions that are being logged in the
reporting services logs as being emailed successfully, but there is no
record of them in the email server logs. Only some of the recipeints
are not receiving the emails - most of them do go through succesfully.
Has anyone else experienced anything like this? Where should I look?I'm experiencing pretty much the same problem. I've got a few subscriptions
scheduled on a Windows 2000 SP4 Server with Reporting Services Enterprise
version 8.0.1038.00 that are displayed as successfully delivered, but there
is no trace of the emails being sent. If I restart the ReportServer service
and reschedule the subscription, it runs and the email is successfully
delivered, but I'm not sure why the subscriptions are failing. Anyone
experience this or have a resolution?
Thanks,
Derek
"leppes@.fei.org" wrote:
> I am running SQL Server 2000 Reporting Services SP2.
> I have data driven subscriptions that are being logged in the
> reporting services logs as being emailed successfully, but there is no
> record of them in the email server logs. Only some of the recipeints
> are not receiving the emails - most of them do go through succesfully.
> Has anyone else experienced anything like this? Where should I look?
>

email trigger

I'd like to setup a trigger to send an email, but can't use SQLMail because
I don't control the password to the account that is running the MSSQLSERVER
service. Is there any other way to have SQL send an email when an insert is
made to a particular table? Plus IT doesn't like the idea of Outlook
installed on a production server.You could use xp_smtp_mail. It requires that the ability to access a smtp
mail server. Quite 'safe' for a production server -unlike MAPI.
Mail -Sending
SQL 2000 - http://www.sqldev.net/xp/xpsmtp.htm
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Colin" <legendsfan@.spamhotmail.com> wrote in message
news:%23IQu$hjxGHA.3892@.TK2MSFTNGP03.phx.gbl...
> I'd like to setup a trigger to send an email, but can't use SQLMail
> because I don't control the password to the account that is running the
> MSSQLSERVER service. Is there any other way to have SQL send an email
> when an insert is made to a particular table? Plus IT doesn't like the
> idea of Outlook installed on a production server.
>|||Hi Colin
It is not really advisable to send emails from triggers as you will
potentially be increasing the transaction time significantly and therefore
increasing contention (blocking/deadlocking etc..). An alternative would be
to populate another table and then periodically have a process that emails
the information and clears the table down.
John
"Colin" wrote:

> I'd like to setup a trigger to send an email, but can't use SQLMail becaus
e
> I don't control the password to the account that is running the MSSQLSERVE
R
> service. Is there any other way to have SQL send an email when an insert
is
> made to a particular table? Plus IT doesn't like the idea of Outlook
> installed on a production server.
>
>

email subscription to hotmail?

Hello...

I have a Virtual PC running SSRS 2005. I keep getting the following error when I try to specify my hotmail account as the To line in the email subscription:

"The e-mail address of one or more recipients is not valid."

I am trying to set it up such that I can send email subscriptions to my hotmail account, or at least let the SMTP Service accept these emails. I don't necesarily need to have these emails delivered, but I would like them to at least be accepted by the SMTP Service. I have added the following to my rsreportserver.config file:

<PermittedHosts>
<HostName>hotmail.com</HostName>
</PermittedHosts>

I am sure I need to configure the IIS SMTP Server settings somehow, does anyone know how to configure my local SMTP Service to allow @.hotmail.com email addresses to be placed into the "Drop" folder?

TIA

All,

After reading through some more posts online (searching through Google groups, yes Google groups MS folks!!!) I found what I needed to do. In fact, what I found does a lot more than I needed to do, it actually sends the email to the external account.

This is NOT a Reporting Services configuration issue. This is an SMTP Service configuration issue (as I suspected). Here is what I did. This may or may not be the "correct" way to do things, but it certainly works for my test environment (Note that this configuration probably shouldn't be used in a production enviornment!!!):

1. Open IIS Manager and right-click the "Default SMTP Virtual Server" and select "Properties".

2. On the Properties dialog, select the Access tab.

3. From the Access tab, click the "Relay..." button (near the bottom of the tab).

4. From the Relay Restrictions dialog, select the "All except the list below" option. Ensure that the "Allow all computers which successfully authenticate to relay, regardless of the list above" checkbox is checked.

5. Click OK on the Relay Restrictions dialog.

6. Click OK on the "Default SMTP Virtual Server Properties" dialog.

7. Stop, then Start the SMTP Service.

8. Setup your email subscription with your external email account and let it run.

Again, this worked for my development\test environment, but you should probably investigate further if you want to use this in a production environment as I am sure that setting up your SMTP Service for relay in this way probably opens it up to all sorts of attacks (like SPAM).

Hope that this helps others experiencing the same/similar issue!!

|||

Also:

9. I got rid of the items I added to the PermittedHosts element, this way I am not restricted to which domains I sent to. Obviously in a production enviornment you would not want to do this.

E-mail subscription not a option

Hi,
I'am running reporting services 2000 and I'am having a problem with e-mail
subscriptions. Here the low down.
My reports run without any problems but when I click on new subscription the
only option available is Report server file share. There's no option for
E-mail. At one point I was able to select the e-mail option but decided to
re-do my 2003 server. Any help with this issue would be more than welcomed.Hi,
Fairly simple. Go to ReportServer directory and open RSreportserver.config
search for <Delivery> and inside that find for "Report Server Email" and add
the required things like from:, SMTP server, account name etc...
and restart the reporting server once; you should be getting this option as
well.
Amarnath
"Robert Douglas" wrote:
> Hi,
> I'am running reporting services 2000 and I'am having a problem with e-mail
> subscriptions. Here the low down.
> My reports run without any problems but when I click on new subscription the
> only option available is Report server file share. There's no option for
> E-mail. At one point I was able to select the e-mail option but decided to
> re-do my 2003 server. Any help with this issue would be more than welcomed.|||Amarnath,
I've tried that serveral times already and still the e-mail option is not
available. I'am on a corporate domain. Keep in mind that the option was there
a one time, but after I re-did the server I noticed this problem. This is the
delivery section from my RSreportserver.config:
<Delivery>
<Extension Name="Report Server Email"
Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>smtprelay.montefiore.org</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory></SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing></SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From></From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL"
Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
"Amarnath" wrote:
> Hi,
> Fairly simple. Go to ReportServer directory and open RSreportserver.config
> search for <Delivery> and inside that find for "Report Server Email" and add
> the required things like from:, SMTP server, account name etc...
> and restart the reporting server once; you should be getting this option as
> well.
> Amarnath
> "Robert Douglas" wrote:
> > Hi,
> >
> > I'am running reporting services 2000 and I'am having a problem with e-mail
> > subscriptions. Here the low down.
> >
> > My reports run without any problems but when I click on new subscription the
> > only option available is Report server file share. There's no option for
> > E-mail. At one point I was able to select the e-mail option but decided to
> > re-do my 2003 server. Any help with this issue would be more than welcomed.|||Hi Robert,
Try giving IP address in <SMTPServer> section. I faced the same problem.
Amarnath
"Robert Douglas" wrote:
> Amarnath,
> I've tried that serveral times already and still the e-mail option is not
> available. I'am on a corporate domain. Keep in mind that the option was there
> a one time, but after I re-did the server I noticed this problem. This is the
> delivery section from my RSreportserver.config:
> <Delivery>
> <Extension Name="Report Server Email"
> Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> <MaxRetries>3</MaxRetries>
> <SecondsBeforeRetry>900</SecondsBeforeRetry>
> <Configuration>
> <RSEmailDPConfiguration>
> <SMTPServer>smtprelay.montefiore.org</SMTPServer>
> <SMTPServerPort></SMTPServerPort>
> <SMTPAccountName></SMTPAccountName>
> <SMTPConnectionTimeout></SMTPConnectionTimeout>
> <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> <SMTPUseSSL></SMTPUseSSL>
> <SendUsing></SendUsing>
> <SMTPAuthenticate></SMTPAuthenticate>
> <From></From>
> <EmbeddedRenderFormats>
> <RenderingExtension>MHTML</RenderingExtension>
> </EmbeddedRenderFormats>
> <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> <ExcludedRenderFormats>
> <RenderingExtension>HTMLOWC</RenderingExtension>
> <RenderingExtension>NULL</RenderingExtension>
> </ExcludedRenderFormats>
> <SendEmailToUserAlias>True</SendEmailToUserAlias>
> <DefaultHostName></DefaultHostName>
> <PermittedHosts></PermittedHosts>
> </RSEmailDPConfiguration>
> </Configuration>
> </Extension>
> <Extension Name="NULL"
> Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
> </Delivery>
>
> "Amarnath" wrote:
> > Hi,
> > Fairly simple. Go to ReportServer directory and open RSreportserver.config
> > search for <Delivery> and inside that find for "Report Server Email" and add
> > the required things like from:, SMTP server, account name etc...
> > and restart the reporting server once; you should be getting this option as
> > well.
> > Amarnath
> >
> > "Robert Douglas" wrote:
> >
> > > Hi,
> > >
> > > I'am running reporting services 2000 and I'am having a problem with e-mail
> > > subscriptions. Here the low down.
> > >
> > > My reports run without any problems but when I click on new subscription the
> > > only option available is Report server file share. There's no option for
> > > E-mail. At one point I was able to select the e-mail option but decided to
> > > re-do my 2003 server. Any help with this issue would be more than welcomed.|||Same problem
"Robert Douglas" wrote:
> Hi,
> I'am running reporting services 2000 and I'am having a problem with e-mail
> subscriptions. Here the low down.
> My reports run without any problems but when I click on new subscription the
> only option available is Report server file share. There's no option for
> E-mail. At one point I was able to select the e-mail option but decided to
> re-do my 2003 server. Any help with this issue would be more than welcomed.|||Well I managed to get the e-mail option back but e-mail still not working.
I'll keep on trying.
"Amarnath" wrote:
> Hi Robert,
> Try giving IP address in <SMTPServer> section. I faced the same problem.
> Amarnath
> "Robert Douglas" wrote:
> > Amarnath,
> >
> > I've tried that serveral times already and still the e-mail option is not
> > available. I'am on a corporate domain. Keep in mind that the option was there
> > a one time, but after I re-did the server I noticed this problem. This is the
> > delivery section from my RSreportserver.config:
> >
> > <Delivery>
> > <Extension Name="Report Server Email"
> > Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
> > <MaxRetries>3</MaxRetries>
> > <SecondsBeforeRetry>900</SecondsBeforeRetry>
> > <Configuration>
> > <RSEmailDPConfiguration>
> > <SMTPServer>smtprelay.montefiore.org</SMTPServer>
> > <SMTPServerPort></SMTPServerPort>
> > <SMTPAccountName></SMTPAccountName>
> > <SMTPConnectionTimeout></SMTPConnectionTimeout>
> > <SMTPServerPickupDirectory></SMTPServerPickupDirectory>
> > <SMTPUseSSL></SMTPUseSSL>
> > <SendUsing></SendUsing>
> > <SMTPAuthenticate></SMTPAuthenticate>
> > <From></From>
> > <EmbeddedRenderFormats>
> > <RenderingExtension>MHTML</RenderingExtension>
> > </EmbeddedRenderFormats>
> > <PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
> > <ExcludedRenderFormats>
> > <RenderingExtension>HTMLOWC</RenderingExtension>
> > <RenderingExtension>NULL</RenderingExtension>
> > </ExcludedRenderFormats>
> > <SendEmailToUserAlias>True</SendEmailToUserAlias>
> > <DefaultHostName></DefaultHostName>
> > <PermittedHosts></PermittedHosts>
> > </RSEmailDPConfiguration>
> > </Configuration>
> > </Extension>
> > <Extension Name="NULL"
> > Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
> > </Delivery>
> >
> >
> > "Amarnath" wrote:
> >
> > > Hi,
> > > Fairly simple. Go to ReportServer directory and open RSreportserver.config
> > > search for <Delivery> and inside that find for "Report Server Email" and add
> > > the required things like from:, SMTP server, account name etc...
> > > and restart the reporting server once; you should be getting this option as
> > > well.
> > > Amarnath
> > >
> > > "Robert Douglas" wrote:
> > >
> > > > Hi,
> > > >
> > > > I'am running reporting services 2000 and I'am having a problem with e-mail
> > > > subscriptions. Here the low down.
> > > >
> > > > My reports run without any problems but when I click on new subscription the
> > > > only option available is Report server file share. There's no option for
> > > > E-mail. At one point I was able to select the e-mail option but decided to
> > > > re-do my 2003 server. Any help with this issue would be more than welcomed.

Email Subscription into Excel

I am running Reporting Services 2000 and I have several email subscriptions
sending out reports rendered into Excel. On two of the reports the Excel
file contains a document map. How can I disable the document map from being
created? These subscriptions have been created using the standard reporting
services interface. Any help would be appreciated.
Thanks,
JeffJeff,
You have to disable the documentmap in the report itself. To my knowledge
you can not disbable this only when exporting (if you know how, let me know
:).
Perry
"Jeff McIntire" <JeffMcIntire@.discussions.microsoft.com> wrote in message
news:E3A7BB06-A11B-402C-A29E-79DE88A73F30@.microsoft.com...
>I am running Reporting Services 2000 and I have several email subscriptions
> sending out reports rendered into Excel. On two of the reports the Excel
> file contains a document map. How can I disable the document map from
> being
> created? These subscriptions have been created using the standard
> reporting
> services interface. Any help would be appreciated.
> Thanks,
> Jeff
>sql

Email subscription failing when report is included in email.

Hey All,

I am using SQL Server RS 2000 and I am running an issue. I create a subscription to email a report to a list of users. Everything works fine if I just setup the subscription so that a link to the report is to be sent in the email. But if I tell the subscription to include the report in the email, the sending of the email fails. What am I doing wrong? Is this a known issue? If so, is there a patch for it?

Thanks,

Jean

I ran into similar emailing issues a while ago when I created a data-driven subscription. I changed the RenderFormat from "Web archive" to "Web page for IE 5.0 or later" and it worked for me.

EMail Subscription Error

All of a sudden, the e-mail subscriptions for a report quit being sent.

Running Sql 2000

Microsoft SQL Server Reporting Services Version 8.00.743.00

Here is the log error:

aspnet_wp!processing!e40!12/11/2006-08:34:29:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
aspnet_wp!processing!e40!12/11/2006-08:34:29:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing.
aspnet_wp!processing!e40!12/11/2006-08:34:29:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!library!e08!12/11/2006-08:39:10:: i INFO: Call to GetPermissions:/Maximo/PO with Received Date Details
aspnet_wp!chunks!e08!12/11/2006-08:39:10:: i INFO: ### GetReportChunk('CompiledDefinition', Main), chunk was not found! this=00000000-0000-0000-0000-000000000000
aspnet_wp!processing!e08!12/11/2006-08:39:10:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext reportContext, GetReportChunk getCompiledDefinitionCallback, SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection dataSources, Boolean checkIfUsable, Boolean isSurrogatePresent)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean checkIfUsable)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, Guid reportID, Boolean checkIfUsable)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(CatalogItemContext reportContext, Boolean checkIfUsable, ReportSnapshot& compiledDefinition)
Microsoft.ReportingServices.Library.RSService._GetProperties(ItemNamespaceEnum itemNamespace, String item, Property[] requestedProperties)
Microsoft.ReportingServices.Library.RSService.GetProperties(ItemNamespaceEnum itemNamespace, String item, Property[] properties)
Microsoft.ReportingServices.WebServer.ReportingService.GetProperties(String Item, Property[] Properties, Property[]& Values)
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean isBinderDefault, Assembly caller, Boolean verifyAccess)
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean verifyAccess)
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
System.Web.Services.Protocols.WebServiceHandler.Invoke()
System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

Any suggestions? Anyone see this before?

Are you sure that you wanted to attach this logfile extract? You mention subscription problem as an original one. But the logfile extract is taken from UI (Reportmanager) logfile, not from the server logfile: reported by aspnet_wp component and stack starts from System.Web.Hosting.ISAPIRuntime.ProcessRequest. If your problem is related to the subscription that suddenly discontinued to work, please attach the corresponding piece from the reportserver_<date>.logh file.

|||

Ah, thanks for that help. Here is that log:

aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!chunks!c80!12/12/2006-10:48:06:: i INFO: ### GetReportChunk('CompiledDefinition', Main), chunk was not found! this=00000000-0000-0000-0000-000000000000
aspnet_wp!processing!c80!12/12/2006-10:48:06:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext reportContext, GetReportChunk getCompiledDefinitionCallback, SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection dataSources, Boolean checkIfUsable, Boolean isSurrogatePresent)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean checkIfUsable)
Microsoft.ReportingServices.Library.RSService.ProcessReportParameters(CatalogItemContext reportContext, ReportSnapshot compiledDefintion, ReportSnapshot snapshotData, DataSourceInfoCollection dataSources, ParameterInfoCollection newParameters, DateTime executionTime, Boolean isSnapshot)
Microsoft.ReportingServices.Library.RSService.InternalGetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values)
Microsoft.ReportingServices.Library.ProcessReportParametersCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RSService.GetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values, JobTypeEnum jobType)
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
Microsoft.ReportingServices.Library.RSService.GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
Microsoft.ReportingServices.WebServer.HTMLViewerBase.GetMergedParametersCollection(NameValueCollection userSpecifiedParams)
Microsoft.ReportingServices.WebServer.HTMLViewerBase.GetMergedReportCollections(ParameterInfoCollection& mergedParams, DataSourcePromptCollection& mergedDataSources, Boolean countsOnly)
Microsoft.ReportingServices.WebServer.HTML40Viewer.GetMergedReportCollections(ParameterInfoCollection& mergedParams, DataSourcePromptCollection& mergedDataSources, Boolean countsOnly)
Microsoft.ReportingServices.WebServer.HTML40Viewer.RenderViewer(String reportName, ReportUrl location, NameValueCollection reportParameters, DatasourceCredentialsCollection dataSourceCredentials, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, CreateAndRegisterStream createAndRegisterStream)
Microsoft.ReportingServices.WebServer.HTMLViewerBase.PreRender(RSService service, CatalogItemContext itemContext, CreateAndRegisterStream createAndRegisterStream, Boolean isSnapshot)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!library!c80!12/12/2006-10:48:30:: i INFO: Call to RenderFirst( '/Maximo/PO Details' )
aspnet_wp!chunks!c80!12/12/2006-10:48:30:: i INFO: ### GetReportChunk('CompiledDefinition', Main), chunk was not found! this=00000000-0000-0000-0000-000000000000
aspnet_wp!processing!c80!12/12/2006-10:48:30:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext reportContext, GetReportChunk getCompiledDefinitionCallback, SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection dataSources, Boolean checkIfUsable, Boolean isSurrogatePresent)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean checkIfUsable)
Microsoft.ReportingServices.Library.RSService.ProcessReportParameters(CatalogItemContext reportContext, ReportSnapshot compiledDefintion, ReportSnapshot snapshotData, DataSourceInfoCollection dataSources, ParameterInfoCollection newParameters, DateTime executionTime, Boolean isSnapshot)
Microsoft.ReportingServices.Library.RSService.InternalGetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values)
Microsoft.ReportingServices.Library.RSService.GetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values, JobTypeEnum jobType)
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequest(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

aspnet_wp!processing!c80!12/12/2006-10:48:30:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:30:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:30:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!library!c80!12/12/2006-10:48:31:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!c80!12/12/2006-10:48:31:: i INFO: Processed report. Report='/Maximo/PO Details', Stream=''
aspnet_wp!library!d4c!12/12/2006-10:49:06:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
aspnet_wp!session!c80!12/12/2006-10:49:38:: i INFO: LoadSnapshot: Item with session: cbm0l1yg4tjjvs55u2wxlp55, reportPath: /Maximo/PO By Material Received Date, userName: BNFLIDAHO\rosesi not found in the database
aspnet_wp!library!c80!12/12/2006-10:49:38:: i INFO: Call to RenderFirst( '/Maximo/PO By Material Received Date' )
aspnet_wp!library!c80!12/12/2006-10:49:39:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.

|||

James,

All attached errors are logged by the web service when you run report via the Report Manager. You can see that by the name of the process that is the first token in the every log entry: aspnet_wp; and by the initial call in the call stack: System.Web.Hosting.ISAPIRuntime.ProcessRequest. Attached errors may be valuable if they are related to the problem you have. They indicate that there is a problem with the retrieving data sources for a sub-report when you try to execute a report via the ReportManager.

For the subscription problem you reported originally you need to take a look on the logfile written by RS windows service. Something like ReportServerService__12_12_2006_13_05_41.log. Sorry , in my previous post I put a wrong name for it. Try to locate the logfile coresponding to the subscription using the timestamp in the logfile name, and then find the errors in the logfile corresponding to the subscription using timestamps within the file.

-Igor

Email Notifications

Hi All,
I have a sql2k running on w2k adv. svr and have a stored procedure which
sends email notifications to clients using xp_sendmail.
Out of the 25 email notifications 1 or 2 fails every other day which is
unacceptable to my clients.
Checking all my logs, I see that the xp_sendmail query runs successfully all
the time.
I need to understand why the query runs successfully all the time and yet
get 1 or 2 email failures?
ThanksIt can a problem with the mail system. Since SQL Server using MAPI to send a
mail, you should check your mail transport.
There are a lot of issues can happen during mail delivery. First of all try
to check is there everything is Ok with
your MS Outlook during the failure time. Then you can check MS Exchange
Server logs if you are using it.
It also can be network issue.
Regards
---
All information provided above AS IS.
"caddo65590" <caddo65590@.hotmail.com> wrote in message
news:%23tKMf4JpDHA.1096@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I have a sql2k running on w2k adv. svr and have a stored procedure which
> sends email notifications to clients using xp_sendmail.
> Out of the 25 email notifications 1 or 2 fails every other day which is
> unacceptable to my clients.
> Checking all my logs, I see that the xp_sendmail query runs successfully
all
> the time.
> I need to understand why the query runs successfully all the time and yet
> get 1 or 2 email failures?
> Thanks
>|||Thanks Sky,
I also forgot to add the error generated by sql, it might help.
The message below is generated anytime the email fails.
Msg 18025, Sev 16: xp_sendmail: failed with mail error 0x80004005
"SkyWalker" <tcp_43@.hotmail.com_TAKETHISOFF> wrote in message
news:Or72cUKpDHA.2444@.TK2MSFTNGP09.phx.gbl...
> It can a problem with the mail system. Since SQL Server using MAPI to send
a
> mail, you should check your mail transport.
> There are a lot of issues can happen during mail delivery. First of all
try
> to check is there everything is Ok with
> your MS Outlook during the failure time. Then you can check MS Exchange
> Server logs if you are using it.
> It also can be network issue.
>
> Regards
> ---
> All information provided above AS IS.
>
> "caddo65590" <caddo65590@.hotmail.com> wrote in message
> news:%23tKMf4JpDHA.1096@.TK2MSFTNGP11.phx.gbl...
> > Hi All,
> > I have a sql2k running on w2k adv. svr and have a stored procedure which
> > sends email notifications to clients using xp_sendmail.
> > Out of the 25 email notifications 1 or 2 fails every other day which is
> > unacceptable to my clients.
> > Checking all my logs, I see that the xp_sendmail query runs successfully
> all
> > the time.
> > I need to understand why the query runs successfully all the time and
yet
> > get 1 or 2 email failures?
> > Thanks
> >
> >
>|||Did you search KB for that return code. I found at least two articles for
that return code that referred to xp_sendmail.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"caddo65590" <caddo65590@.hotmail.com> wrote in message
news:OKuLYdKpDHA.2776@.tk2msftngp13.phx.gbl...
> Thanks Sky,
> I also forgot to add the error generated by sql, it might help.
> The message below is generated anytime the email fails.
> Msg 18025, Sev 16: xp_sendmail: failed with mail error 0x80004005
> "SkyWalker" <tcp_43@.hotmail.com_TAKETHISOFF> wrote in message
> news:Or72cUKpDHA.2444@.TK2MSFTNGP09.phx.gbl...
> > It can a problem with the mail system. Since SQL Server using MAPI to
send
> a
> > mail, you should check your mail transport.
> > There are a lot of issues can happen during mail delivery. First of all
> try
> > to check is there everything is Ok with
> > your MS Outlook during the failure time. Then you can check MS Exchange
> > Server logs if you are using it.
> > It also can be network issue.
> >
> >
> >
> > Regards
> > ---
> > All information provided above AS IS.
> >
> >
> > "caddo65590" <caddo65590@.hotmail.com> wrote in message
> > news:%23tKMf4JpDHA.1096@.TK2MSFTNGP11.phx.gbl...
> > > Hi All,
> > > I have a sql2k running on w2k adv. svr and have a stored procedure
which
> > > sends email notifications to clients using xp_sendmail.
> > > Out of the 25 email notifications 1 or 2 fails every other day which
is
> > > unacceptable to my clients.
> > > Checking all my logs, I see that the xp_sendmail query runs
successfully
> > all
> > > the time.
> > > I need to understand why the query runs successfully all the time and
> yet
> > > get 1 or 2 email failures?
> > > Thanks
> > >
> > >
> >
> >
>

Email Notification Problem

Hi All,
I have a couple of w2k adv. svrs which are also running sql 2000. My DBA has
configured sp_send_mail using outlook 2000 which is also installed on these
servers.
This sp_send_mail is configured to send notifications on daily basis. Out of
25 notifications each day, 2 or 3 fails.
They claim the sp_send_mail stored procedure executes properly so the
problem is with the exchange svr even though there is no trace of these
failed messages in exchange nor even on the client computers where outlooks
mapi32 is initiated.
Is there any way I can figure out in outlook, on the client computers if
these failed messages are even initiated by outlook or not, even though they
claim their stored procedure executes properly always?
Nobody in the company has mail delivery problem with the exchange box or
their outlook clients. I have tested sending emails from outlook on these
servers without any failures yet they claim its exchange 2000.
Any ideas on how to resolve this permanently'The mail support that ships with SQL Server is not fun to work with as it uses MAPI and MAPI was
never designed to be used from services. Have you considered using xp_smtp_sendmail from
www.sqldev.net?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"caddo65590" <caddo65590@.hotmail.com> wrote in message news:O0QAtnEtDHA.980@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I have a couple of w2k adv. svrs which are also running sql 2000. My DBA has
> configured sp_send_mail using outlook 2000 which is also installed on these
> servers.
> This sp_send_mail is configured to send notifications on daily basis. Out of
> 25 notifications each day, 2 or 3 fails.
> They claim the sp_send_mail stored procedure executes properly so the
> problem is with the exchange svr even though there is no trace of these
> failed messages in exchange nor even on the client computers where outlooks
> mapi32 is initiated.
> Is there any way I can figure out in outlook, on the client computers if
> these failed messages are even initiated by outlook or not, even though they
> claim their stored procedure executes properly always?
> Nobody in the company has mail delivery problem with the exchange box or
> their outlook clients. I have tested sending emails from outlook on these
> servers without any failures yet they claim its exchange 2000.
> Any ideas on how to resolve this permanently'
>

E-mail Notification

We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.
You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:

> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you need
> additional information. Thank you.
>
>
|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...[vbcol=seagreen]
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:

E-mail Notification

We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:

> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you nee
d
> additional information. Thank you.
>
>|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...[vbcol=seagreen]
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:
>

E-mail Notification

We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
Edition Server. We setup some maintenance jobs under Database Maintenance
and would like to setup e-mail notification. When we setup notifications,
we got the following error message: "Error 22022: SQLServerAgent Error:
The SQLServer Agent mail session is not running; check the mail profile
and/or the SQLServerAgent service startup account in the SQLServerAgent
Properties dialog." What do we need to do? Please let us know if you need
additional information. Thank you.You have to interactively login as thye service account that SQL is running
under and install Outlook and configure a mapi profile. If you are still
running as localsystem, you'll need to switch to a service account for it to
work. The SQL Server service account maust have rights to access the mapi
profile.
"Diane Walker" wrote:
> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
> Edition Server. We setup some maintenance jobs under Database Maintenance
> and would like to setup e-mail notification. When we setup notifications,
> we got the following error message: "Error 22022: SQLServerAgent Error:
> The SQLServer Agent mail session is not running; check the mail profile
> and/or the SQLServerAgent service startup account in the SQLServerAgent
> Properties dialog." What do we need to do? Please let us know if you need
> additional information. Thank you.
>
>|||Thanks very much for your prompt response, Jeffrey.
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:3DBDB121-D7D6-413C-BF3F-1B1F33CEDB4D@.microsoft.com...
> You have to interactively login as thye service account that SQL is
> running
> under and install Outlook and configure a mapi profile. If you are still
> running as localsystem, you'll need to switch to a service account for it
> to
> work. The SQL Server service account maust have rights to access the mapi
> profile.
> "Diane Walker" wrote:
>> We are running SQL 2000 Enterprise Edition under Windows 2003 Standard
>> Edition Server. We setup some maintenance jobs under Database
>> Maintenance
>> and would like to setup e-mail notification. When we setup
>> notifications,
>> we got the following error message: "Error 22022: SQLServerAgent Error:
>> The SQLServer Agent mail session is not running; check the mail profile
>> and/or the SQLServerAgent service startup account in the SQLServerAgent
>> Properties dialog." What do we need to do? Please let us know if you
>> need
>> additional information. Thank you.
>>

Email Alert

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. what is the most safe and
best way to achive this?Hi docsql,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You want to know
how to setup a email notification for an alert in SQL Server 2000. If I
misunderstood your concern, please feel free to point it out.
In SQL Server 2000, you can define the Response to an alert and choose the
email operator to notify.
To setup a SQL Mail, you need to configure a mail profile first.
SQL Mail must have a mail profile created in the same user domain account
or context that is used to start an instance of SQL Server. You can create
the profile with a mail client, such as Microsoft Outlook, that is
installed locally on the SQL Server computer.
You can find how to configure SQL Mail in the following article.
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_1_server_2ecs.asp
Also, following KB article may help you to set up a SQL Agent Mail.
263556 INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
315886 INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
321183 HOW TO: Troubleshoot Your SQL Mail Issue
http://support.microsoft.com/?id=321183
311231 INF: Frequently Asked Questions - SQL Server - SQL Mail
http://support.microsoft.com/?id=311231
Hope this will be helpful.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
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.

Email Alert

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. what is the most safe and
best way to achive this?
Hi docsql,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You want to know
how to setup a email notification for an alert in SQL Server 2000. If I
misunderstood your concern, please feel free to point it out.
In SQL Server 2000, you can define the Response to an alert and choose the
email operator to notify.
To setup a SQL Mail, you need to configure a mail profile first.
SQL Mail must have a mail profile created in the same user domain account
or context that is used to start an instance of SQL Server. You can create
the profile with a mail client, such as Microsoft Outlook, that is
installed locally on the SQL Server computer.
You can find how to configure SQL Mail in the following article.
http://msdn.microsoft.com/library/de...us/adminsql/ad
_1_server_2ecs.asp
Also, following KB article may help you to set up a SQL Agent Mail.
263556 INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
315886 INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
321183 HOW TO: Troubleshoot Your SQL Mail Issue
http://support.microsoft.com/?id=321183
311231 INF: Frequently Asked Questions - SQL Server - SQL Mail
http://support.microsoft.com/?id=311231
Hope this will be helpful.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
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.

Email Alert

I have a Windows 2003 server running SQL 2000 SP4. I want to start setting
up email alerts and reporting on the SQL server. what is the most safe and
best way to achive this?Hi docsql,
Welcome to use MSDN Managed Newsgroup Support.
From your description, my understanding of this issue is: You want to know
how to setup a email notification for an alert in SQL Server 2000. If I
misunderstood your concern, please feel free to point it out.
In SQL Server 2000, you can define the Response to an alert and choose the
email operator to notify.
To setup a SQL Mail, you need to configure a mail profile first.
SQL Mail must have a mail profile created in the same user domain account
or context that is used to start an instance of SQL Server. You can create
the profile with a mail client, such as Microsoft Outlook, that is
installed locally on the SQL Server computer.
You can find how to configure SQL Mail in the following article.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
_1_server_2ecs.asp
Also, following KB article may help you to set up a SQL Agent Mail.
263556 INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
315886 INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
321183 HOW TO: Troubleshoot Your SQL Mail Issue
http://support.microsoft.com/?id=321183
311231 INF: Frequently Asked Questions - SQL Server - SQL Mail
http://support.microsoft.com/?id=311231
Hope this will be helpful.
Sincerely yours,
Wei Lu
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
=====================================================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.

EM slows windows

Often, EM running on my desktop will cause all other
windows either to refresh very slowly or not at all. (I
may get a border with some of the display) I can't
navigate to any window completely until I shut down EM.
SQL 2000 running on Win2k.
Thanks.
One possibility is that you have ODBC tracing turned on. You
can check by going to Administrative Tools and then to the
ODBC Data Source Administrator. Click on the Tracing tab. If
caption on the command button says "Stop Tracing Now", click
that button. That will turn off ODBC tracing.
-Sue
On Wed, 9 Jun 2004 07:08:54 -0700, "Andy Mous"
<andymous@.discussions.microsoft.com> wrote:

>Often, EM running on my desktop will cause all other
>windows either to refresh very slowly or not at all. (I
>may get a border with some of the display) I can't
>navigate to any window completely until I shut down EM.
>SQL 2000 running on Win2k.
>Thanks.

EM running really slow

My EM and QA have started to run really slowly have have tried to find the
problem but I cannot seem to find it. Does anybody have any suggestions on
where to look to solve this problem?
Thanks
We are running SQL2K SP4 on a windows 2000 server.
"A.B." wrote:

> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks
|||A.B,
Are other applications on your machine running slowly as well? Does this
happen to other machines? Check out your resource usage on your machine
using Task Manager.
HTH
Jerry
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks
|||The CPU usage is low and the Memory usage is 1580636K/1942920K
They seem to work fine if I go to the server but if I remote desktop to them
they are slow. Our network is working fine though so i dont think it is that.
I am stumped. This just started happening 2 days ago.
"Jerry Spivey" wrote:

> A.B,
> Are other applications on your machine running slowly as well? Does this
> happen to other machines? Check out your resource usage on your machine
> using Task Manager.
> HTH
> Jerry
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
>
>
|||What if you remote desktop to the server using another machine? Is it slow
from that machine as well?
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...[vbcol=seagreen]
> The CPU usage is low and the Memory usage is 1580636K/1942920K
> They seem to work fine if I go to the server but if I remote desktop to
> them
> they are slow. Our network is working fine though so i dont think it is
> that.
> I am stumped. This just started happening 2 days ago.
> "Jerry Spivey" wrote:
|||I will have to try this tomorrow. Everybody has gone home and there are no
computers for me to use right now. I will respond tomorrow.
"Jerry Spivey" wrote:

> What if you remote desktop to the server using another machine? Is it slow
> from that machine as well?
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
>
>
|||You might check to see if ODBC tracing is turned on. This will slow down
these ODBC apps considerably.
Hope this helps.
Dan Guzman
SQL Server MVP
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...[vbcol=seagreen]
>I will have to try this tomorrow. Everybody has gone home and there are no
> computers for me to use right now. I will respond tomorrow.
> "Jerry Spivey" wrote:
|||That was the problem. Thanks guys for your help.
Adam
"Dan Guzman" wrote:

> You might check to see if ODBC tracing is turned on. This will slow down
> these ODBC apps considerably.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...
>
>

EM running really slow

My EM and QA have started to run really slowly have have tried to find the
problem but I cannot seem to find it. Does anybody have any suggestions on
where to look to solve this problem?
ThanksWe are running SQL2K SP4 on a windows 2000 server.
"A.B." wrote:
> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks|||A.B,
Are other applications on your machine running slowly as well? Does this
happen to other machines? Check out your resource usage on your machine
using Task Manager.
HTH
Jerry
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks|||The CPU usage is low and the Memory usage is 1580636K/1942920K
They seem to work fine if I go to the server but if I remote desktop to them
they are slow. Our network is working fine though so i dont think it is that.
I am stumped. This just started happening 2 days ago.
"Jerry Spivey" wrote:
> A.B,
> Are other applications on your machine running slowly as well? Does this
> happen to other machines? Check out your resource usage on your machine
> using Task Manager.
> HTH
> Jerry
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> > My EM and QA have started to run really slowly have have tried to find the
> > problem but I cannot seem to find it. Does anybody have any suggestions on
> > where to look to solve this problem?
> >
> > Thanks
>
>|||What if you remote desktop to the server using another machine? Is it slow
from that machine as well?
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
> The CPU usage is low and the Memory usage is 1580636K/1942920K
> They seem to work fine if I go to the server but if I remote desktop to
> them
> they are slow. Our network is working fine though so i dont think it is
> that.
> I am stumped. This just started happening 2 days ago.
> "Jerry Spivey" wrote:
>> A.B,
>> Are other applications on your machine running slowly as well? Does this
>> happen to other machines? Check out your resource usage on your machine
>> using Task Manager.
>> HTH
>> Jerry
>> "A.B." <AB@.discussions.microsoft.com> wrote in message
>> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
>> > My EM and QA have started to run really slowly have have tried to find
>> > the
>> > problem but I cannot seem to find it. Does anybody have any suggestions
>> > on
>> > where to look to solve this problem?
>> >
>> > Thanks
>>|||I will have to try this tomorrow. Everybody has gone home and there are no
computers for me to use right now. I will respond tomorrow.
"Jerry Spivey" wrote:
> What if you remote desktop to the server using another machine? Is it slow
> from that machine as well?
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
> > The CPU usage is low and the Memory usage is 1580636K/1942920K
> > They seem to work fine if I go to the server but if I remote desktop to
> > them
> > they are slow. Our network is working fine though so i dont think it is
> > that.
> > I am stumped. This just started happening 2 days ago.
> >
> > "Jerry Spivey" wrote:
> >
> >> A.B,
> >>
> >> Are other applications on your machine running slowly as well? Does this
> >> happen to other machines? Check out your resource usage on your machine
> >> using Task Manager.
> >>
> >> HTH
> >>
> >> Jerry
> >> "A.B." <AB@.discussions.microsoft.com> wrote in message
> >> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> >> > My EM and QA have started to run really slowly have have tried to find
> >> > the
> >> > problem but I cannot seem to find it. Does anybody have any suggestions
> >> > on
> >> > where to look to solve this problem?
> >> >
> >> > Thanks
> >>
> >>
> >>
>
>|||You might check to see if ODBC tracing is turned on. This will slow down
these ODBC apps considerably.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...
>I will have to try this tomorrow. Everybody has gone home and there are no
> computers for me to use right now. I will respond tomorrow.
> "Jerry Spivey" wrote:
>> What if you remote desktop to the server using another machine? Is it
>> slow
>> from that machine as well?
>> "A.B." <AB@.discussions.microsoft.com> wrote in message
>> news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
>> > The CPU usage is low and the Memory usage is 1580636K/1942920K
>> > They seem to work fine if I go to the server but if I remote desktop to
>> > them
>> > they are slow. Our network is working fine though so i dont think it is
>> > that.
>> > I am stumped. This just started happening 2 days ago.
>> >
>> > "Jerry Spivey" wrote:
>> >
>> >> A.B,
>> >>
>> >> Are other applications on your machine running slowly as well? Does
>> >> this
>> >> happen to other machines? Check out your resource usage on your
>> >> machine
>> >> using Task Manager.
>> >>
>> >> HTH
>> >>
>> >> Jerry
>> >> "A.B." <AB@.discussions.microsoft.com> wrote in message
>> >> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
>> >> > My EM and QA have started to run really slowly have have tried to
>> >> > find
>> >> > the
>> >> > problem but I cannot seem to find it. Does anybody have any
>> >> > suggestions
>> >> > on
>> >> > where to look to solve this problem?
>> >> >
>> >> > Thanks
>> >>
>> >>
>> >>
>>|||That was the problem. Thanks guys for your help.
Adam
"Dan Guzman" wrote:
> You might check to see if ODBC tracing is turned on. This will slow down
> these ODBC apps considerably.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...
> >I will have to try this tomorrow. Everybody has gone home and there are no
> > computers for me to use right now. I will respond tomorrow.
> >
> > "Jerry Spivey" wrote:
> >
> >> What if you remote desktop to the server using another machine? Is it
> >> slow
> >> from that machine as well?
> >>
> >> "A.B." <AB@.discussions.microsoft.com> wrote in message
> >> news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
> >> > The CPU usage is low and the Memory usage is 1580636K/1942920K
> >> > They seem to work fine if I go to the server but if I remote desktop to
> >> > them
> >> > they are slow. Our network is working fine though so i dont think it is
> >> > that.
> >> > I am stumped. This just started happening 2 days ago.
> >> >
> >> > "Jerry Spivey" wrote:
> >> >
> >> >> A.B,
> >> >>
> >> >> Are other applications on your machine running slowly as well? Does
> >> >> this
> >> >> happen to other machines? Check out your resource usage on your
> >> >> machine
> >> >> using Task Manager.
> >> >>
> >> >> HTH
> >> >>
> >> >> Jerry
> >> >> "A.B." <AB@.discussions.microsoft.com> wrote in message
> >> >> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> >> >> > My EM and QA have started to run really slowly have have tried to
> >> >> > find
> >> >> > the
> >> >> > problem but I cannot seem to find it. Does anybody have any
> >> >> > suggestions
> >> >> > on
> >> >> > where to look to solve this problem?
> >> >> >
> >> >> > Thanks
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

EM running really slow

My EM and QA have started to run really slowly have have tried to find the
problem but I cannot seem to find it. Does anybody have any suggestions on
where to look to solve this problem?
ThanksWe are running SQL2K SP4 on a Windows 2000 server.
"A.B." wrote:

> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks|||A.B,
Are other applications on your machine running slowly as well? Does this
happen to other machines? Check out your resource usage on your machine
using Task Manager.
HTH
Jerry
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
> My EM and QA have started to run really slowly have have tried to find the
> problem but I cannot seem to find it. Does anybody have any suggestions on
> where to look to solve this problem?
> Thanks|||The CPU usage is low and the Memory usage is 1580636K/1942920K
They seem to work fine if I go to the server but if I remote desktop to them
they are slow. Our network is working fine though so i dont think it is that
.
I am stumped. This just started happening 2 days ago.
"Jerry Spivey" wrote:

> A.B,
> Are other applications on your machine running slowly as well? Does this
> happen to other machines? Check out your resource usage on your machine
> using Task Manager.
> HTH
> Jerry
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:743DEAD5-A393-4818-808C-99E0731BBE00@.microsoft.com...
>
>|||What if you remote desktop to the server using another machine? Is it slow
from that machine as well?
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...[vbcol=seagreen]
> The CPU usage is low and the Memory usage is 1580636K/1942920K
> They seem to work fine if I go to the server but if I remote desktop to
> them
> they are slow. Our network is working fine though so i dont think it is
> that.
> I am stumped. This just started happening 2 days ago.
> "Jerry Spivey" wrote:
>|||I will have to try this tomorrow. Everybody has gone home and there are no
computers for me to use right now. I will respond tomorrow.
"Jerry Spivey" wrote:

> What if you remote desktop to the server using another machine? Is it slo
w
> from that machine as well?
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:0747F8A2-6115-4B1D-9A87-EF0B36D5E07A@.microsoft.com...
>
>|||You might check to see if ODBC tracing is turned on. This will slow down
these ODBC apps considerably.
Hope this helps.
Dan Guzman
SQL Server MVP
"A.B." <AB@.discussions.microsoft.com> wrote in message
news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...[vbcol=seagreen]
>I will have to try this tomorrow. Everybody has gone home and there are no
> computers for me to use right now. I will respond tomorrow.
> "Jerry Spivey" wrote:
>|||That was the problem. Thanks guys for your help.
Adam
"Dan Guzman" wrote:

> You might check to see if ODBC tracing is turned on. This will slow down
> these ODBC apps considerably.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "A.B." <AB@.discussions.microsoft.com> wrote in message
> news:B0967038-CEF2-48FC-A331-0DC4A693E77F@.microsoft.com...
>
>

EM locks up

On certain occasions, when I'm running a long-running query in Query
Analyzer, I can't get in to Enterprise Manager. What happens is the list of
tables can't be enumerated until the long-running query finishes. What's
odd to me is that the query only affects 1 or 2 tables. So why can't I get
into EM until this job finishes?
Thanks, Andre
Hi,
This might be because your ISQLW.EXE in client machine will be using the
CPU and Memory fully. If you have better processor PIII or higher +
512 MB ram you should have such issues.
Check your virtual memory definition in your client machine. Always try to
run the long running queries in text result mode.
Thanks
Hari
MCDBA
"Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
news:#O07UKgLEHA.1556@.TK2MSFTNGP10.phx.gbl...
> On certain occasions, when I'm running a long-running query in Query
> Analyzer, I can't get in to Enterprise Manager. What happens is the list
of
> tables can't be enumerated until the long-running query finishes. What's
> odd to me is that the query only affects 1 or 2 tables. So why can't I
get
> into EM until this job finishes?
> Thanks, Andre
>
|||Actually, the long-running query is running on a different box. For
example, if you and I were in the same office, and I was running the query,
you might not be able to get into EM.
Andre
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%23udrVlgLEHA.1032@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Hi,
> This might be because your ISQLW.EXE in client machine will be using the
> CPU and Memory fully. If you have better processor PIII or higher +
> 512 MB ram you should have such issues.
> Check your virtual memory definition in your client machine. Always try to
> run the long running queries in text result mode.
> Thanks
> Hari
> MCDBA
>
>
> "Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
> news:#O07UKgLEHA.1556@.TK2MSFTNGP10.phx.gbl...
list[vbcol=seagreen]
> of
What's
> get
>
|||Hi,
Means , you will be able to open the enterprise manager, but while expanding
your SQL Server it just hangs..
Can you check the SQLSERVR.exe CPU usage in server. If it is 100% then the
performance will be slow and cause a time out. The CPU usage in the log
running query can be minimized by tuning the query by effect sql statement
and adding proper indexes.
Did you installed SP3 in SQL server machine. If not install SP3.
Thanks
Hari
MCDBA
"Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
news:ep0$dzgLEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Actually, the long-running query is running on a different box. For
> example, if you and I were in the same office, and I was running the
query,[vbcol=seagreen]
> you might not be able to get into EM.
> Andre
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:%23udrVlgLEHA.1032@.tk2msftngp13.phx.gbl...
the[vbcol=seagreen]
to[vbcol=seagreen]
> list
> What's
I
>
|||sp3a was installed shortly after it was released. Yes, I (or other users)
can launch EM, can expand the server, but can't get a list of tables when
trying to expand the tables folder. Query analyzer works just fine. CPU
usage on the server is typically low when this is happening. sp_who2 shows
that the long running query is blocking the EM process. I just can't figure
out why a query that "might" have a lock on a table would prevent the list
of tables from being displayed in EM.
Andre
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:ODjXezpLEHA.3052@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Means , you will be able to open the enterprise manager, but while
expanding[vbcol=seagreen]
> your SQL Server it just hangs..
> Can you check the SQLSERVR.exe CPU usage in server. If it is 100% then the
> performance will be slow and cause a time out. The CPU usage in the log
> running query can be minimized by tuning the query by effect sql statement
> and adding proper indexes.
> Did you installed SP3 in SQL server machine. If not install SP3.
> Thanks
> Hari
> MCDBA
> "Andre" <AndreGetsEnoughSPAM@.nospam.com> wrote in message
> news:ep0$dzgLEHA.3292@.TK2MSFTNGP11.phx.gbl...
> query,
> the
try[vbcol=seagreen]
> to
can't
> I
>
|||Hi,
Do you have the problem yet? I am having a similar problem. I have 2 machines:
1 .- SQL server 2000 + SP3, without problems
2 .- SQL Server 2000 + SP3a, with performance problems
I am reinstalling Sql server + SP3 and I am testing machine 1. I am sending you information.
Lina
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...