No Mail icon in control panel?

This is too weird.
I'm following
http://support.microsoft.com/Default.../wct091301.asp
to troubleshoot why SQLAgentMail does not send notifications on our SQL 2000
server. Looks like I need to logon as the startup user account to get mail
profile configured. But after I logon the SQL server using the startup
domain account that runs both the server and the agent, I don't see any Mail
icon in the control panel. Logging on as other users does not have this
problem.
Any ideas?
Bing
Have you considered other alternatives?
http://www.aspfaq.com/2403
http://www.aspfaq.com/
(Reverse address to reply.)
"bing" <bing@.discussions.microsoft.com> wrote in message
news:3B45529C-D273-4B72-9DEA-B01E13BC6F2C@.microsoft.com...
> This is too weird.
> I'm following
>
http://support.microsoft.com/Default.../wct091301.asp
> to troubleshoot why SQLAgentMail does not send notifications on our SQL
2000
> server. Looks like I need to logon as the startup user account to get
mail
> profile configured. But after I logon the SQL server using the startup
> domain account that runs both the server and the agent, I don't see any
Mail
> icon in the control panel. Logging on as other users does not have this
> problem.
> Any ideas?
> Bing
|||That indicates that mail is not configured for the service
account you are logging in as. Follow the steps in the
following:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
-Sue
On Tue, 18 Jan 2005 14:57:02 -0800, "bing"
<bing@.discussions.microsoft.com> wrote:

>This is too weird.
>I'm following
>http://support.microsoft.com/Default.../wct091301.asp
>to troubleshoot why SQLAgentMail does not send notifications on our SQL 2000
>server. Looks like I need to logon as the startup user account to get mail
>profile configured. But after I logon the SQL server using the startup
>domain account that runs both the server and the agent, I don't see any Mail
>icon in the control panel. Logging on as other users does not have this
>problem.
>Any ideas?
>Bing
|||Yup, you said it right. Looks like Microsoft office outlook was upgraded
from 2000 to 2003 on our SQL server at some point. But the mail
configuration for the SQL service account was not maintained at the same
time. I just went into outlook 2003 and get mail configured for the service
account. SQLAgentMail works fine now. Thanks all who replied.
Bing
"Sue Hoegemeier" wrote:

> That indicates that mail is not configured for the service
> account you are logging in as. Follow the steps in the
> following:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/?id=263556
> -Sue
> On Tue, 18 Jan 2005 14:57:02 -0800, "bing"
> <bing@.discussions.microsoft.com> wrote:
>
>
|||Glad it was that easy to sort out. In my experience, it usually involves a
lot more hair- and teeth-pulling. :-)
http://www.aspfaq.com/
(Reverse address to reply.)
"bing" <bing@.discussions.microsoft.com> wrote in message
news:382E13A2-F995-4FE0-86F4-124CA6BB3210@.microsoft.com...
> Yup, you said it right. Looks like Microsoft office outlook was upgraded
> from 2000 to 2003 on our SQL server at some point. But the mail
> configuration for the SQL service account was not maintained at the same
> time. I just went into outlook 2003 and get mail configured for the
service
> account. SQLAgentMail works fine now. Thanks all who replied.
>

No Mail icon in control panel?

This is too weird.
I'm following
http://support.microsoft.com/Defaul...1/wct091301.asp
to troubleshoot why SQLAgentMail does not send notifications on our SQL 2000
server. Looks like I need to logon as the startup user account to get mail
profile configured. But after I logon the SQL server using the startup
domain account that runs both the server and the agent, I don't see any Mail
icon in the control panel. Logging on as other users does not have this
problem.
Any ideas?
BingHave you considered other alternatives?
http://www.aspfaq.com/2403
http://www.aspfaq.com/
(Reverse address to reply.)
"bing" <bing@.discussions.microsoft.com> wrote in message
news:3B45529C-D273-4B72-9DEA-B01E13BC6F2C@.microsoft.com...
> This is too weird.
> I'm following
>
http://support.microsoft.com/Defaul...1/wct091301.asp
> to troubleshoot why SQLAgentMail does not send notifications on our SQL
2000
> server. Looks like I need to logon as the startup user account to get
mail
> profile configured. But after I logon the SQL server using the startup
> domain account that runs both the server and the agent, I don't see any
Mail
> icon in the control panel. Logging on as other users does not have this
> problem.
> Any ideas?
> Bing|||That indicates that mail is not configured for the service
account you are logging in as. Follow the steps in the
following:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
-Sue
On Tue, 18 Jan 2005 14:57:02 -0800, "bing"
<bing@.discussions.microsoft.com> wrote:

>This is too weird.
>I'm following
>http://support.microsoft.com/Defaul...1/wct091301.asp
>to troubleshoot why SQLAgentMail does not send notifications on our SQL 200
0
>server. Looks like I need to logon as the startup user account to get mail
>profile configured. But after I logon the SQL server using the startup
>domain account that runs both the server and the agent, I don't see any Mai
l
>icon in the control panel. Logging on as other users does not have this
>problem.
>Any ideas?
>Bing|||Yup, you said it right. Looks like Microsoft office outlook was upgraded
from 2000 to 2003 on our SQL server at some point. But the mail
configuration for the SQL service account was not maintained at the same
time. I just went into outlook 2003 and get mail configured for the service
account. SQLAgentMail works fine now. Thanks all who replied.
Bing
"Sue Hoegemeier" wrote:

> That indicates that mail is not configured for the service
> account you are logging in as. Follow the steps in the
> following:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/?id=263556
> -Sue
> On Tue, 18 Jan 2005 14:57:02 -0800, "bing"
> <bing@.discussions.microsoft.com> wrote:
>
>|||Glad it was that easy to sort out. In my experience, it usually involves a
lot more hair- and teeth-pulling. :-)
http://www.aspfaq.com/
(Reverse address to reply.)
"bing" <bing@.discussions.microsoft.com> wrote in message
news:382E13A2-F995-4FE0-86F4-124CA6BB3210@.microsoft.com...
> Yup, you said it right. Looks like Microsoft office outlook was upgraded
> from 2000 to 2003 on our SQL server at some point. But the mail
> configuration for the SQL service account was not maintained at the same
> time. I just went into outlook 2003 and get mail configured for the
service
> account. SQLAgentMail works fine now. Thanks all who replied.
>

No Mail icon in control panel?

This is too weird.
I'm following
http://support.microsoft.com/Default.aspx?scid=http://support.microsoft.com/servicedesks/webcasts/en/wc091301/wct091301.asp
to troubleshoot why SQLAgentMail does not send notifications on our SQL 2000
server. Looks like I need to logon as the startup user account to get mail
profile configured. But after I logon the SQL server using the startup
domain account that runs both the server and the agent, I don't see any Mail
icon in the control panel. Logging on as other users does not have this
problem.
Any ideas?
BingHave you considered other alternatives?
http://www.aspfaq.com/2403
--
http://www.aspfaq.com/
(Reverse address to reply.)
"bing" <bing@.discussions.microsoft.com> wrote in message
news:3B45529C-D273-4B72-9DEA-B01E13BC6F2C@.microsoft.com...
> This is too weird.
> I'm following
>
http://support.microsoft.com/Default.aspx?scid=http://support.microsoft.com/servicedesks/webcasts/en/wc091301/wct091301.asp
> to troubleshoot why SQLAgentMail does not send notifications on our SQL
2000
> server. Looks like I need to logon as the startup user account to get
mail
> profile configured. But after I logon the SQL server using the startup
> domain account that runs both the server and the agent, I don't see any
Mail
> icon in the control panel. Logging on as other users does not have this
> problem.
> Any ideas?
> Bing|||That indicates that mail is not configured for the service
account you are logging in as. Follow the steps in the
following:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
-Sue
On Tue, 18 Jan 2005 14:57:02 -0800, "bing"
<bing@.discussions.microsoft.com> wrote:
>This is too weird.
>I'm following
>http://support.microsoft.com/Default.aspx?scid=http://support.microsoft.com/servicedesks/webcasts/en/wc091301/wct091301.asp
>to troubleshoot why SQLAgentMail does not send notifications on our SQL 2000
>server. Looks like I need to logon as the startup user account to get mail
>profile configured. But after I logon the SQL server using the startup
>domain account that runs both the server and the agent, I don't see any Mail
>icon in the control panel. Logging on as other users does not have this
>problem.
>Any ideas?
>Bing|||Yup, you said it right. Looks like Microsoft office outlook was upgraded
from 2000 to 2003 on our SQL server at some point. But the mail
configuration for the SQL service account was not maintained at the same
time. I just went into outlook 2003 and get mail configured for the service
account. SQLAgentMail works fine now. Thanks all who replied.
Bing
"Sue Hoegemeier" wrote:
> That indicates that mail is not configured for the service
> account you are logging in as. Follow the steps in the
> following:
> INF: How to Configure SQL Mail
> http://support.microsoft.com/?id=263556
> -Sue
> On Tue, 18 Jan 2005 14:57:02 -0800, "bing"
> <bing@.discussions.microsoft.com> wrote:
> >This is too weird.
> >
> >I'm following
> >http://support.microsoft.com/Default.aspx?scid=http://support.microsoft.com/servicedesks/webcasts/en/wc091301/wct091301.asp
> >to troubleshoot why SQLAgentMail does not send notifications on our SQL 2000
> >server. Looks like I need to logon as the startup user account to get mail
> >profile configured. But after I logon the SQL server using the startup
> >domain account that runs both the server and the agent, I don't see any Mail
> >icon in the control panel. Logging on as other users does not have this
> >problem.
> >
> >Any ideas?
> >
> >Bing
>|||Glad it was that easy to sort out. In my experience, it usually involves a
lot more hair- and teeth-pulling. :-)
--
http://www.aspfaq.com/
(Reverse address to reply.)
"bing" <bing@.discussions.microsoft.com> wrote in message
news:382E13A2-F995-4FE0-86F4-124CA6BB3210@.microsoft.com...
> Yup, you said it right. Looks like Microsoft office outlook was upgraded
> from 2000 to 2003 on our SQL server at some point. But the mail
> configuration for the SQL service account was not maintained at the same
> time. I just went into outlook 2003 and get mail configured for the
service
> account. SQLAgentMail works fine now. Thanks all who replied.
>

No Mail for Me!

Hey all,

I've got a Enterprise SQL 2000 server setup for my websites. I wanted to use the operators and sqlmail SP's for some things. So i setup everything but i'm not able to actually send any email.

I have outlook 2002 installed on the server and the server account is set to the mail profile 'SQLMail' and this account is set to run both MSSQLServer and SQL Agent.

Here's the catch. We run exchange here on a domain XYZ. my server is a standalone and does not actully connect to the XYZ domain. Does this mean that i can't use the mail capabilities in SQL?

When setting things up i'm able to test connections to my profile and i get the A-OK messages i should expect BUT when i try to test an email or email pager account for an operator it fails. My SQL Agent log shows:

[260] Unable to start mail session (reason: Unable to logon (reason: Unable to get the default MAPI Message Store due to MAPI error 273:
The information store could not be opened); check the mail profile and/or the SQLSERVERAGENT service startup account)

Any ideas?Couple things you should test:

1. Can you send mail successfully when logged into the machine with Sql run account? This should answer your questions about the domain.

2. Is Outlook your default mail client when logged in with run account? Check Internet Options, Programs tab, Under Email.

3. Under Mail in the Control Panel make sure the mail profile you select in Sql Agent is used when starting Outlook and setup correctly.

Hope this helps.

No entries in Database Mail log (sysmail_event_log)

Hi. I've reviewed the following webpage http://msdn2.microsoft.com/en-us/library/ms189959.aspx and didn't get the answer I was looking for. (Service Broker is running in msdb.)

Essentially, Database Mail isn't logging entries. Using the following example script:

EXEC msdb.dbo.sp_send_dbmail
@.recipients=N'someone@.somewhere.com',
@.body='Message Body',
@.subject ='Message Subject'

I get the result "Mail queued," and I confirm I receive the email.

However, there are no records in the following tables:

select * from sysmail_event_log
select * from sysmail_faileditems
select * from sysmail_unsentitems

There are records that the send-off was a success:

select * from sysmail_sentitems

Database Mail's "Logging Level" to normally set to Normal. I've changed to Verbose and see no change.

Anyone see something I'm missing?

There should not be any records in

sysmail_event_log
sysmail_faileditems
sysmail_unsentitems

for a sucessfully sent email.

There should be a record in

sysmail_sentitems

for a sucessfully sent email.

Search Books Online for information on

sysmail_event_log
sysmail_faileditems
sysmail_unsentitems

|||I don't know... the other servers log messages in sysmail_event_log such as "Activation successful," "DatabaseMail process is started," and "Mail successfully sent" .|||

Contains one row for each Windows or SQL Server message returned by the Database Mail system. (Message in this context refers to a message such as an error message, not an e-mail message.) As suggested Use sysmail_sentitems when you want to see which messages were successfully sent.

BOL confirms:

When troubleshooting Database Mail, search the sysmail_event_log view for events related to e-mail failures. Some messages, such as the failure of the Database Mail external program, are not associated with specific e-mails. To search for errors related to specific e-mails, look up the mailitem_id of the failed e-mail in the sysmail_faileditems view and then search the sysmail_event_log for messages related to that mailitem_id. When an error is returned from sp_send_dbmail, the e-mail is not submitted to the Database Mail system and the error is not displayed in this view.

When individual account delivery attempts fail, Database Mail holds the error messages during retry attempts until the mail item delivery either succeeds or fails. In case of ultimate success, all of the accumulated errors get logged as separate warnings including the account_id. This can cause warnings to appear, even though the e-mail was sent. In case of ultimate delivery failure, all previous warnings get logged as one error message without an account_id, since all accounts have failed.

No entries in Database Mail log (sysmail_event_log)

Hi. I've reviewed the following webpage http://msdn2.microsoft.com/en-us/library/ms189959.aspx and didn't get the answer I was looking for. (Service Broker is running in msdb.)

Essentially, Database Mail isn't logging entries. Using the following example script:

EXEC msdb.dbo.sp_send_dbmail
@.recipients=N'someone@.somewhere.com',
@.body='Message Body',
@.subject ='Message Subject'

I get the result "Mail queued," and I confirm I receive the email.

However, there are no records in the following tables:

select * from sysmail_event_log
select * from sysmail_faileditems
select * from sysmail_unsentitems

There are records that the send-off was a success:

select * from sysmail_sentitems

Database Mail's "Logging Level" to normally set to Normal. I've changed to Verbose and see no change.

Anyone see something I'm missing?

There should not be any records in

sysmail_event_log
sysmail_faileditems
sysmail_unsentitems

for a sucessfully sent email.

There should be a record in

sysmail_sentitems

for a sucessfully sent email.

Search Books Online for information on

sysmail_event_log
sysmail_faileditems
sysmail_unsentitems

|||I don't know... the other servers log messages in sysmail_event_log such as "Activation successful," "DatabaseMail process is started," and "Mail successfully sent" .|||

Contains one row for each Windows or SQL Server message returned by the Database Mail system. (Message in this context refers to a message such as an error message, not an e-mail message.) As suggested Use sysmail_sentitems when you want to see which messages were successfully sent.

BOL confirms:

When troubleshooting Database Mail, search the sysmail_event_log view for events related to e-mail failures. Some messages, such as the failure of the Database Mail external program, are not associated with specific e-mails. To search for errors related to specific e-mails, look up the mailitem_id of the failed e-mail in the sysmail_faileditems view and then search the sysmail_event_log for messages related to that mailitem_id. When an error is returned from sp_send_dbmail, the e-mail is not submitted to the Database Mail system and the error is not displayed in this view.

When individual account delivery attempts fail, Database Mail holds the error messages during retry attempts until the mail item delivery either succeeds or fails. In case of ultimate success, all of the accumulated errors get logged as separate warnings including the account_id. This can cause warnings to appear, even though the e-mail was sent. In case of ultimate delivery failure, all previous warnings get logged as one error message without an account_id, since all accounts have failed.

sql

No attachments in subscription mail messages

We have reportingservices installed on the sql box. It's a W2K SP4 server
with sql2000 SP3a.
We have deployed several reports. All reports we have deployed after
installing SP1 do not contain an attached report (PDF, TIFF, Excel, CSV) but
when the report is rendered in the body of the message or when we view it in
the viewer there are no problems at all.
Reports deployed before installing SP1 are functioning correctly.
The following message we find in the logfiles:
aspnet_wp!library!c48!03/08/2005-14:29:41:: i INFO: Call to RenderFirst(
'/GMA_Test' )
aspnet_wp!library!c48!03/08/2005-14:29:51:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!c48!03/08/2005-14:29:51:: i INFO: Processed report.
Report='/GMA_Test', Stream=''
aspnet_wp!library!c48!03/08/2005-14:29:52:: i INFO: Call to RenderNext(
'/GMA_Test' )
aspnet_wp!chunks!c48!03/08/2005-14:29:52:: i INFO: ###
GetReportChunk('RenderingInfo_HTML4.0', 2), chunk was not found!
this=8b4f21e9-99c6-45e0-a642-91bf34101b25
aspnet_wp!cache!c48!03/08/2005-14:29:52:: i INFO: Session live: /GMA_Test
aspnet_wp!webserver!c48!03/08/2005-14:29:52:: i INFO: Processed report.
Report='/GMA_Test', Stream=''
aspnet_wp!webserver!c48!03/08/2005-14:29:52:: i INFO: Processed report.
Report='/GMA_Test', Stream='524d8435-4afe-4a86-a02e-1bc9b4cb7f9d'
We have absolutly no clue!
Please help!Odd. Try http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
I've sent posts by MSFT stating that hotfix fixes more than Lotus Notes
attachment issues.
--
Adrian M.
MCP
"Stefan Cremers" <s.cremers@.fritom.com> wrote in message
news:e%23jZcUJJFHA.3500@.TK2MSFTNGP14.phx.gbl...
> We have reportingservices installed on the sql box. It's a W2K SP4 server
> with sql2000 SP3a.
> We have deployed several reports. All reports we have deployed after
> installing SP1 do not contain an attached report (PDF, TIFF, Excel, CSV)
> but when the report is rendered in the body of the message or when we view
> it in the viewer there are no problems at all.
> Reports deployed before installing SP1 are functioning correctly.
> The following message we find in the logfiles:
> aspnet_wp!library!c48!03/08/2005-14:29:41:: i INFO: Call to RenderFirst(
> '/GMA_Test' )
> aspnet_wp!library!c48!03/08/2005-14:29:51:: i INFO: Initializing
> EnableExecutionLogging to 'True' as specified in Server system
> properties.
> aspnet_wp!webserver!c48!03/08/2005-14:29:51:: i INFO: Processed report.
> Report='/GMA_Test', Stream=''
> aspnet_wp!library!c48!03/08/2005-14:29:52:: i INFO: Call to RenderNext(
> '/GMA_Test' )
> aspnet_wp!chunks!c48!03/08/2005-14:29:52:: i INFO: ###
> GetReportChunk('RenderingInfo_HTML4.0', 2), chunk was not found!
> this=8b4f21e9-99c6-45e0-a642-91bf34101b25
> aspnet_wp!cache!c48!03/08/2005-14:29:52:: i INFO: Session live: /GMA_Test
> aspnet_wp!webserver!c48!03/08/2005-14:29:52:: i INFO: Processed report.
> Report='/GMA_Test', Stream=''
> aspnet_wp!webserver!c48!03/08/2005-14:29:52:: i INFO: Processed report.
> Report='/GMA_Test', Stream='524d8435-4afe-4a86-a02e-1bc9b4cb7f9d'
>
> We have absolutly no clue!
> Please help!
>|||Adrian,
Thanks for your help.
I installed the hotfix but nithing chanced. Our problem still exists.
"Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
news:uARmooKJFHA.1476@.TK2MSFTNGP09.phx.gbl...
> Odd. Try http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
> I've sent posts by MSFT stating that hotfix fixes more than Lotus Notes
> attachment issues.
> --
> Adrian M.
> MCP
>|||I have seen this similar issue. In my case I can send a link but if I send
the report nothing gets sent. I gave up and decided to wait for SP2 (this
month) and see if that fixes the problem.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stefan Cremers" <s.cremers@.fritom.com> wrote in message
news:OubUtTOJFHA.732@.TK2MSFTNGP12.phx.gbl...
> Adrian,
> Thanks for your help.
> I installed the hotfix but nithing chanced. Our problem still exists.
>
> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
> news:uARmooKJFHA.1476@.TK2MSFTNGP09.phx.gbl...
> > Odd. Try http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
> >
> > I've sent posts by MSFT stating that hotfix fixes more than Lotus Notes
> > attachment issues.
> >
> > --
> > Adrian M.
> > MCP
> >
>|||This is odd. In my web app I programmatically create subscriptions that
include the report as an attachment and it works fine.
--
Adrian M.
MCP
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uILWefOJFHA.3500@.TK2MSFTNGP14.phx.gbl...
>I have seen this similar issue. In my case I can send a link but if I send
> the report nothing gets sent. I gave up and decided to wait for SP2 (this
> month) and see if that fixes the problem.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stefan Cremers" <s.cremers@.fritom.com> wrote in message
> news:OubUtTOJFHA.732@.TK2MSFTNGP12.phx.gbl...
>> Adrian,
>> Thanks for your help.
>> I installed the hotfix but nithing chanced. Our problem still exists.
>>
>> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
>> news:uARmooKJFHA.1476@.TK2MSFTNGP09.phx.gbl...
>> > Odd. Try http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
>> >
>> > I've sent posts by MSFT stating that hotfix fixes more than Lotus Notes
>> > attachment issues.
>> >
>> > --
>> > Adrian M.
>> > MCP
>> >
>|||One thing I was told (but it was more than I wanted to do) was that the most
reliable method is to have the subscription be put in a directory for pickup
by your mail service. Might be something you would want to try.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
news:uAA4RzOJFHA.580@.TK2MSFTNGP15.phx.gbl...
> This is odd. In my web app I programmatically create subscriptions that
> include the report as an attachment and it works fine.
> --
> Adrian M.
> MCP
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uILWefOJFHA.3500@.TK2MSFTNGP14.phx.gbl...
> >I have seen this similar issue. In my case I can send a link but if I
send
> > the report nothing gets sent. I gave up and decided to wait for SP2
(this
> > month) and see if that fixes the problem.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Stefan Cremers" <s.cremers@.fritom.com> wrote in message
> > news:OubUtTOJFHA.732@.TK2MSFTNGP12.phx.gbl...
> >> Adrian,
> >>
> >> Thanks for your help.
> >>
> >> I installed the hotfix but nithing chanced. Our problem still exists.
> >>
> >>
> >>
> >> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
> >> news:uARmooKJFHA.1476@.TK2MSFTNGP09.phx.gbl...
> >> > Odd. Try
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
> >> >
> >> > I've sent posts by MSFT stating that hotfix fixes more than Lotus
Notes
> >> > attachment issues.
> >> >
> >> > --
> >> > Adrian M.
> >> > MCP
> >> >
> >>
> >
> >
>|||Here are some other things to check:
- Make sure the firewall (if one is being used) is set up to allow the MIME
type of the exported report to go out (PDF, Excel, etc). On most firewalls
you have to set up specific firewall rules to allow this (at least we had
to)
- On the SMTP server, make sure the 'Limit message size to (KB)' checkbox on
the SMTP Virtual Server property sheet Messages tab, is unchecked or specify
a sufficiently large enough value in the textbox. The default is is 2048KB.
If the default is checked and a report is bigger than this, the email will
not go with the attachment.
--
Adrian M.
MCP
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eEI2b4OJFHA.3916@.TK2MSFTNGP14.phx.gbl...
> One thing I was told (but it was more than I wanted to do) was that the
> most
> reliable method is to have the subscription be put in a directory for
> pickup
> by your mail service. Might be something you would want to try.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
> news:uAA4RzOJFHA.580@.TK2MSFTNGP15.phx.gbl...
>> This is odd. In my web app I programmatically create subscriptions that
>> include the report as an attachment and it works fine.
>> --
>> Adrian M.
>> MCP
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uILWefOJFHA.3500@.TK2MSFTNGP14.phx.gbl...
>> >I have seen this similar issue. In my case I can send a link but if I
> send
>> > the report nothing gets sent. I gave up and decided to wait for SP2
> (this
>> > month) and see if that fixes the problem.
>> >
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "Stefan Cremers" <s.cremers@.fritom.com> wrote in message
>> > news:OubUtTOJFHA.732@.TK2MSFTNGP12.phx.gbl...
>> >> Adrian,
>> >>
>> >> Thanks for your help.
>> >>
>> >> I installed the hotfix but nithing chanced. Our problem still exists.
>> >>
>> >>
>> >>
>> >> "Adrian M." <absolutelynospam@.nodomain_.com> wrote in message
>> >> news:uARmooKJFHA.1476@.TK2MSFTNGP09.phx.gbl...
>> >> > Odd. Try
> http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
>> >> >
>> >> > I've sent posts by MSFT stating that hotfix fixes more than Lotus
> Notes
>> >> > attachment issues.
>> >> >
>> >> > --
>> >> > Adrian M.
>> >> > MCP
>> >> >
>> >>
>> >
>> >
>>
>

newbie: setting up SQL MAIL

My system:
I have installed Sql Server 2000 on my server (MS windows server 2003
enterprise edtion)
In addition Exchange Server 2003 standard edition is installed on this
server.
Every users on my network, have an e-mail account in exchange
On the clients, every user have Outlook Express with a MAPI profile.
My problem is that when I in SqlServer properties specifies SQL Mail profile
and
push the Test-button I get this error message:
"Error 18025: xp_test_mapi_profile : failed with mail error 0x80040111".
And if I just push the Ok-button in the dialoge specifying SQL Mail profile.
I get this message:
"The MAPI profile was not found on the server, Are you this is what you
want?" (yes/no-button)
The profile name i specified is used in Outllook express to send email using
MAPI...
so why do I get this error..'?. (remember I'm a newbie)
Eh, I know that running Exchange and SqlServer on the same server is not a
good thing,
slow performance..etc... I´d setup this system in the porpose of learning
about
sqlserver&exchange&win2k3server...
JeffI was sure that a MAPI-compliant client, such as Outlook, had to be
installed *on* the SQL Server machine, and that it had to use an account
that SQL Server was privy to...
I think there's a way to make it work with Outlook Express, but I'm not sure
it's supported.
Maybe some helpful links here (including the possibility of using SMTP
instead of Exchange/MAPI/SQL Mail)?
http://www.aspfaq.com/2403
"Jeff" <it_consultant1@.hotmail.com> wrote in message
news:uQeBHVweDHA.3528@.tk2msftngp13.phx.gbl...
> My system:
> I have installed Sql Server 2000 on my server (MS windows server 2003
> enterprise edtion)
> In addition Exchange Server 2003 standard edition is installed on this
> server.
> Every users on my network, have an e-mail account in exchange
> On the clients, every user have Outlook Express with a MAPI profile.
> My problem is that when I in SqlServer properties specifies SQL Mail
profile
> and
> push the Test-button I get this error message:
> "Error 18025: xp_test_mapi_profile : failed with mail error 0x80040111".
> And if I just push the Ok-button in the dialoge specifying SQL Mail
profile.
> I get this message:
> "The MAPI profile was not found on the server, Are you this is what you
> want?" (yes/no-button)
> The profile name i specified is used in Outllook express to send email
using
> MAPI...
> so why do I get this error..'?. (remember I'm a newbie)
> Eh, I know that running Exchange and SqlServer on the same server is not a
> good thing,
> slow performance..etc... I´d setup this system in the porpose of learning
> about
> sqlserver&exchange&win2k3server...
> Jeff
>
>|||If you continue to have problems try smtp mail. It's much simpler and more
reliable than mapi.
http://sqldev.net/xp/xpsmtp.htm
Paul
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23XB1%23pyeDHA.1748@.TK2MSFTNGP10.phx.gbl...
> I was sure that a MAPI-compliant client, such as Outlook, had to be
> installed *on* the SQL Server machine, and that it had to use an account
> that SQL Server was privy to...
> I think there's a way to make it work with Outlook Express, but I'm not
sure
> it's supported.
> Maybe some helpful links here (including the possibility of using SMTP
> instead of Exchange/MAPI/SQL Mail)?
> http://www.aspfaq.com/2403
>
>
> "Jeff" <it_consultant1@.hotmail.com> wrote in message
> news:uQeBHVweDHA.3528@.tk2msftngp13.phx.gbl...
> > My system:
> > I have installed Sql Server 2000 on my server (MS windows server 2003
> > enterprise edtion)
> > In addition Exchange Server 2003 standard edition is installed on this
> > server.
> >
> > Every users on my network, have an e-mail account in exchange
> >
> > On the clients, every user have Outlook Express with a MAPI profile.
> >
> > My problem is that when I in SqlServer properties specifies SQL Mail
> profile
> > and
> > push the Test-button I get this error message:
> > "Error 18025: xp_test_mapi_profile : failed with mail error
0x80040111".
> >
> > And if I just push the Ok-button in the dialoge specifying SQL Mail
> profile.
> > I get this message:
> > "The MAPI profile was not found on the server, Are you this is what you
> > want?" (yes/no-button)
> >
> > The profile name i specified is used in Outllook express to send email
> using
> > MAPI...
> >
> > so why do I get this error..'?. (remember I'm a newbie)
> >
> > Eh, I know that running Exchange and SqlServer on the same server is not
a
> > good thing,
> > slow performance..etc... I´d setup this system in the porpose of
learning
> > about
> > sqlserver&exchange&win2k3server...
> >
> > Jeff
> >
> >
> >
>