| Author |
Message |
|
ktric
#1 / 12
|
 SQL Mail behavior problems. Hi All, I am running 2 instances of SQL on one win2k server. The
default instance is version 7.00.961, sp3 has been
applied.
The second instance is version 8.00.384 sp1 has been
applied.
The reason for 2 instances is that I had 3 databases that
are used by 3rd party apps and could not go up to 8.00.
On the 7.x instance I have scheduled jobs for maintenance
plans and one scheduled job that queries a database for
overdue work orders and emails the reports as an
attachment to group of supervisors. Its supposed to run at
6 am every morning. The job has failed to run 3 times
since the move and upgrade. The error logs indicate a mapi
login error.
The 8x instance also has scheduled jobs, that reports to
me for failed maintenance plans. I have not had any SQL
mail problems with it yet.
Digging into the problem I checked the profile settings
SQL Agent settings, and test SQL Mail. Doing all that and
not having any errors. I try starting the job it still
fails. I try the script in Query Analyzer it also fails
with a mapi login failure.
Then I try stopping and restarting SQL Mail and run the
script. Amazingly it works this time! I rerun the job and
it works!
I’m wondering if the dual instances of services are
confusing mapi services? Has anyone else encountered this
behavior?
|
| Sat, 22 May 2004 06:07:48 GMT |
|
 |
|
Jasper Smit
#2 / 12
|
SQL Mail behavior problems. Have you tried setting 2 profiles, one for SQL7 and one for 2000 ?
Quote: > Hi All, > I am running 2 instances of SQL on one win2k server. The
> default instance is version 7.00.961, sp3 has been
> applied.
> The second instance is version 8.00.384 sp1 has been
> applied.
> The reason for 2 instances is that I had 3 databases that
> are used by 3rd party apps and could not go up to 8.00.
> On the 7.x instance I have scheduled jobs for maintenance
> plans and one scheduled job that queries a database for
> overdue work orders and emails the reports as an
> attachment to group of supervisors. Its supposed to run at
> 6 am every morning. The job has failed to run 3 times
> since the move and upgrade. The error logs indicate a mapi
> login error.
> The 8x instance also has scheduled jobs, that reports to
> me for failed maintenance plans. I have not had any SQL
> mail problems with it yet.
> Digging into the problem I checked the profile settings
> SQL Agent settings, and test SQL Mail. Doing all that and
> not having any errors. I try starting the job it still
> fails. I try the script in Query Analyzer it also fails
> with a mapi login failure.
> Then I try stopping and restarting SQL Mail and run the
> script. Amazingly it works this time! I rerun the job and
> it works!
> Im wondering if the dual instances of services are
> confusing mapi services? Has anyone else encountered this
> behavior?
|
| Sat, 22 May 2004 08:11:59 GMT |
|
|
|
Lee Johnson [M
#3 / 12
|
SQL Mail behavior problems. The following article may also be helpful to you: INF: How to Configure SQL Mail [sqlserver]
http://support.microsoft.com/support/kb/articles/q263/5/56.asp
---------------------
This posting is provided ?AS IS? with no warranties, and confers no
rights.
|
| Sat, 22 May 2004 11:51:27 GMT |
|
|
|
ktric
#4 / 12
|
SQL Mail behavior problems. I have read the article, sql mail is configured properly on ten other servers all using the same mail profile. Quote: >-----Original Message----- >The following article may also be helpful to you: >INF: How to Configure SQL
Mail [sqlserver] Quote: >http://support.microsoft.com/support/kb/articles/q263/5/56 .asp >--------------------- >This posting is provided ?AS IS? with no warranties, and confers no >rights. >.
|
| Sat, 22 May 2004 23:14:14 GMT |
|
|
|
ktric
#5 / 12
|
SQL Mail behavior problems. I'll try it. but my email admins wont like it. they always want to know why. Quote: >-----Original Message----- >Have you tried setting 2 profiles, one for SQL7 and one for 2000 ?
>> Hi All,
>> I am running 2 instances of SQL on one win2k server. The
>> default instance is version 7.00.961, sp3 has been
>> applied.
>> The second instance is version 8.00.384 sp1 has been
>> applied.
>> The reason for 2 instances is that I had 3 databases
that
>> are used by 3rd party apps and could not go up to 8.00.
>> On the 7.x instance I have scheduled jobs for
maintenance
>> plans and one scheduled job that queries a database for
>> overdue work orders and emails the reports as an
>> attachment to group of supervisors. Its supposed to run
at
>> 6 am every morning. The job has failed to run 3 times
>> since the move and upgrade. The error logs indicate a
mapi
>> login error.
>> The 8x instance also has scheduled jobs, that reports to
>> me for failed maintenance plans. I have not had any SQL
>> mail problems with it yet.
>> Digging into the problem I checked the profile settings
>> SQL Agent settings, and test SQL Mail. Doing all that
and
>> not having any errors. I try starting the job it still
>> fails. I try the script in Query Analyzer it also fails
>> with a mapi login failure.
>> Then I try stopping and restarting SQL Mail and run the
>> script. Amazingly it works this time! I rerun the job
and
>> it works!
>> I’m wondering if the dual instances of services are
>> confusing mapi services? Has anyone else encountered
this
>> behavior?
>.
|
| Sat, 22 May 2004 23:17:05 GMT |
|
|
|
ktric
#6 / 12
|
SQL Mail behavior problems. Im wondering if Im getting a variation of the bugs found with SQL Mail as listed in Q300414 that is suposed to be fixed by applying SP2 for SQL2K Quote: >-----Original Message----- >The following article may also be helpful to you: >INF: How to Configure SQL
Mail [sqlserver] Quote: >http://support.microsoft.com/support/kb/articles/q263/5/56 .asp >--------------------- >This posting is provided ?AS IS? with no warranties, and confers no >rights. >.
|
| Sat, 22 May 2004 23:26:23 GMT |
|
|
|
ktric
#7 / 12
|
SQL Mail behavior problems. If I run the following script using Query Analyzer on the
8x instance it properly sends the mail. (Keep in mind that
2 instances of SQL Server is running on the same machine.)
Next when I run the above script on the 7x instance using
Query Analyzer I get the mapi login error.
"Server: Msg 17903, Level 18, State 1, Line 0
MAPI login failure."
Then I run the following script against the 7x instance
use master
go
xp_stopmail
go
xp_startmail
go
It stops and starts succefully and mail is sent. The 8x
instance is not releasing the MAPI Session. I tested it in
reverse, 7x did not hang on to the MAPI Session. I'm going
to add to my 7x jobs the stop and start commands as a work-
around. This Issue looks like a bug that should be
reported.
Quote: >-----Original Message----- >Hi All, >I am running 2 instances of SQL on one win2k server. The
>default instance is version 7.00.961, sp3 has been
>applied.
>The second instance is version 8.00.384 sp1 has been
>applied.
>The reason for 2 instances is that I had 3 databases that
>are used by 3rd party apps and could not go up to 8.00.
>On the 7.x instance I have scheduled jobs for maintenance
>plans and one scheduled job that queries a database for
>overdue work orders and emails the reports as an
>attachment to group of supervisors. Its supposed to run
at
>6 am every morning. The job has failed to run 3 times
>since the move and upgrade. The error logs indicate a
mapi
>login error.
>The 8x instance also has scheduled jobs, that reports to
>me for failed maintenance plans. I have not had any SQL
>mail problems with it yet.
>Digging into the problem I checked the profile settings
>SQL Agent settings, and test SQL Mail. Doing all that and
>not having any errors. I try starting the job it still
>fails. I try the script in Query Analyzer it also fails
>with a mapi login failure.
>Then I try stopping and restarting SQL Mail and run the
>script. Amazingly it works this time! I rerun the job and
>it works!
>I’m wondering if the dual instances of services are
>confusing mapi services? Has anyone else encountered this
>behavior?
>.
|
| Sun, 23 May 2004 02:10:57 GMT |
|
|
|
Dwayne Lanclos [M
#8 / 12
|
SQL Mail behavior problems. This is a known issue with SQL Mail. Thanks. ------
Dwayne Lanclos
Microsoft SQL Server Support
Please reply only to the newsgroup so that others can benefit.
When posting, please state the version of SQL Server being used and the
error number/exact error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
Quote: > Content-Class: urn:content-classes:message
> If I run the following script using Query Analyzer on the
> 8x instance it properly sends the mail. (Keep in mind that
> 2 instances of SQL Server is running on the same machine.)
> Next when I run the above script on the 7x instance using
> Query Analyzer I get the mapi login error.
> "Server: Msg 17903, Level 18, State 1, Line 0
> MAPI login failure."
> Then I run the following script against the 7x instance
> use master
> go
> xp_stopmail
> go
> xp_startmail
> go
> It stops and starts succefully and mail is sent. The 8x
> instance is not releasing the MAPI Session. I tested it in
> reverse, 7x did not hang on to the MAPI Session. I'm going
> to add to my 7x jobs the stop and start commands as a work-
> around. This Issue looks like a bug that should be
> reported.
> >-----Original Message-----
> >Hi All,
> >I am running 2 instances of SQL on one win2k server. The
> >default instance is version 7.00.961, sp3 has been
> >applied.
> >The second instance is version 8.00.384 sp1 has been
> >applied.
> >The reason for 2 instances is that I had 3 databases that
> >are used by 3rd party apps and could not go up to 8.00.
> >On the 7.x instance I have scheduled jobs for maintenance
> >plans and one scheduled job that queries a database for
> >overdue work orders and emails the reports as an
> >attachment to group of supervisors. Its supposed to run
> at
> >6 am every morning. The job has failed to run 3 times
> >since the move and upgrade. The error logs indicate a
> mapi
> >login error.
> >The 8x instance also has scheduled jobs, that reports to
> >me for failed maintenance plans. I have not had any SQL
> >mail problems with it yet.
> >Digging into the problem I checked the profile settings
> >SQL Agent settings, and test SQL Mail. Doing all that and
> >not having any errors. I try starting the job it still
> >fails. I try the script in Query Analyzer it also fails
> >with a mapi login failure.
> >Then I try stopping and restarting SQL Mail and run the
> >script. Amazingly it works this time! I rerun the job and
> >it works!
> >I’m wondering if the dual instances of services are
> >confusing mapi services? Has anyone else encountered this
> >behavior?
> >.
|
| Tue, 25 May 2004 00:30:33 GMT |
|
|
|
Shawn Broc
#9 / 12
|
SQL Mail behavior problems. For what it is worth, our SQL Mail became less reliable with SP2. I cannot prove it was SP2 that did it, but that was the only variable that comes to mind.
Im wondering if Im getting a variation of the bugs found
with SQL Mail as listed in Q300414 that is suposed to be
fixed by applying SP2 for SQL2K
Quote: >-----Original Message----- >The following article may also be helpful to you: >INF: How to Configure SQL
Mail [sqlserver] Quote: >http://support.microsoft.com/support/kb/articles/q263/5/56 .asp >--------------------- >This posting is provided ?AS IS? with no warranties, and confers no >rights. >.
|
| Wed, 28 Jul 2004 05:11:46 GMT |
|
|
|
Reinaldo Kibel (
#10 / 12
|
SQL Mail behavior problems. I want to reinforce the need to check ALL the settings according to article
Q263556. Additionally, please check what versions of DLLs (the ones listed
on the same article) is on the system.
Reinaldo Kibel
Microsoft? Corp. - SQL Server Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. ? 2002 Microsoft Corporation. All rights
reserved.
Additional support can be obtained at http://support.microsoft.com
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--------------------
| Subject: Re: SQL Mail behavior problems.
| Date: Fri, 8 Feb 2002 16:11:46 -0500
| Lines: 27
| Organization: Data Benchmark LLC
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 66.73.31.86
| Path: cpmsftngxa07!tkmsftngp01!tkmsftngp07
| Xref: cpmsftngxa07 microsoft.public.sqlserver.server:195497
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| For what it is worth, our SQL Mail became less reliable with SP2.
| I cannot prove it was SP2 that did it, but that was the only variable that
| comes to mind.
|
|
|
| Im wondering if Im getting a variation of the bugs found
| with SQL Mail as listed in Q300414 that is suposed to be
| fixed by applying SP2 for SQL2K
Quote: | >-----Original Message-----
| >The following article may also be helpful to you:
| >
| >INF: How to Configure SQL
| Mail [sqlserver]
| >http://support.microsoft.com/support/kb/articles/q263/5/56
| .asp
| >---------------------
| >This posting is provided ?AS IS? with no warranties,
| and confers no
| >rights.
| >
| >.
| >
|
|
|
|
| Wed, 25 Aug 2004 02:18:38 GMT |
|
|
|
Bill Clar
#11 / 12
|
SQL Mail behavior problems. Reinaldo, Talk to Dwayne Lanclos. I have provided Docs to him to consistently
duplicate the bug with sqlmap70.dll from SP2 using a POP/SMTP client.
Bill Clark
Quote: > I want to reinforce the need to check ALL the settings according to
article
> Q263556. Additionally, please check what versions of DLLs (the ones listed
> on the same article) is on the system.
> Reinaldo Kibel
> Microsoft? Corp. - SQL Server Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> You assume all risk for your use. ? 2002 Microsoft Corporation. All rights
> reserved.
> Additional support can be obtained at http://support.microsoft.com
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
> --------------------
> | Subject: Re: SQL Mail behavior problems.
> | Date: Fri, 8 Feb 2002 16:11:46 -0500
> | Lines: 27
> | Organization: Data Benchmark LLC
> | X-Priority: 3
> | X-MSMail-Priority: Normal
> | X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
> | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: 66.73.31.86
> | Path: cpmsftngxa07!tkmsftngp01!tkmsftngp07
> | Xref: cpmsftngxa07 microsoft.public.sqlserver.server:195497
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | For what it is worth, our SQL Mail became less reliable with SP2.
> | I cannot prove it was SP2 that did it, but that was the only variable
that
> | comes to mind.
> |
> |
> |
> | Im wondering if Im getting a variation of the bugs found
> | with SQL Mail as listed in Q300414 that is suposed to be
> | fixed by applying SP2 for SQL2K
> | >-----Original Message-----
> | >The following article may also be helpful to you:
> | >
> | >INF: How to Configure SQL
> | Mail [sqlserver]
> | >http://support.microsoft.com/support/kb/articles/q263/5/56
> | .asp
> | >---------------------
> | >This posting is provided ?AS IS? with no warranties,
> | and confers no
> | >rights.
> | >
> | >.
> | >
> |
> |
> |
|
| Wed, 25 Aug 2004 05:37:45 GMT |
|
|
|
Reinaldo Kibel (
#12 / 12
|
SQL Mail behavior problems. Thanks Bill. I'm happy this issue is being taken care. Reinaldo Kibel
Microsoft? Corp. - SQL Server Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. ? 2002 Microsoft Corporation. All rights
reserved.
Additional support can be obtained at http://support.microsoft.com
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--------------------
| Subject: Re: SQL Mail behavior problems.
| Date: Fri, 8 Mar 2002 13:37:45 -0800
| Lines: 81
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: 66.35.215.170
| Path: cpmsftngxa07!tkmsftngxs01!tkmsftngp01!tkmsftngp02
| Xref: cpmsftngxa07 microsoft.public.sqlserver.server:200678
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Reinaldo,
|
| Talk to Dwayne Lanclos. I have provided Docs to him to consistently
| duplicate the bug with sqlmap70.dll from SP2 using a POP/SMTP client.
|
| Bill Clark
|
| >
| > I want to reinforce the need to check ALL the settings according to
| article
| > Q263556. Additionally, please check what versions of DLLs (the ones
listed
| > on the same article) is on the system.
| >
| > Reinaldo Kibel
| > Microsoft? Corp. - SQL Server Support Engineer
| >
| > This posting is provided "AS IS" with no warranties, and confers no
| rights.
| > You assume all risk for your use. ? 2002 Microsoft Corporation. All
rights
| > reserved.
| >
| > Additional support can be obtained at http://support.microsoft.com
| >
| > Are you secure? For information about the Strategic Technology
Protection
| > Program and to order your FREE Security Tool Kit, please visit
| > http://www.microsoft.com/security.
| > --------------------
| > | Subject: Re: SQL Mail behavior problems.
| > | Date: Fri, 8 Feb 2002 16:11:46 -0500
| > | Lines: 27
| > | Organization: Data Benchmark LLC
| > | X-Priority: 3
| > | X-MSMail-Priority: Normal
| > | X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
| > | X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
| > | Newsgroups: microsoft.public.sqlserver.server
| > | NNTP-Posting-Host: 66.73.31.86
| > | Path: cpmsftngxa07!tkmsftngp01!tkmsftngp07
| > | Xref: cpmsftngxa07 microsoft.public.sqlserver.server:195497
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | For what it is worth, our SQL Mail became less reliable with SP2.
| > | I cannot prove it was SP2 that did it, but that was the only variable
| that
| > | comes to mind.
| > |
| > |
| > |
| > | Im wondering if Im getting a variation of the bugs found
| > | with SQL Mail as listed in Q300414 that is suposed to be
| > | fixed by applying SP2 for SQL2K
Quote: | > | >-----Original Message-----
| > | >The following article may also be helpful to you:
| > | >
| > | >INF: How to Configure SQL
| > | Mail [sqlserver]
| > | >http://support.microsoft.com/support/kb/articles/q263/5/56
| > | .asp
| > | >---------------------
| > | >This posting is provided ?AS IS? with no warranties,
| > | and confers no
| > | >rights.
| > | >
| > | >.
| > | >
| > |
| > |
| > |
| >
|
|
|
|
| Sat, 28 Aug 2004 01:48:29 GMT |
|
| |
