I created a new MAPI profile on the server, and it seems to work fine with Outlook. I also dropped the previous default MAPI profile.
Now, when I go to the EM SQLAgent Properties, the only MAP profile offered in the SQLMail drop-down is the old, deleted profile. Also, only the old profile comes up with xp_get_MAPI_profiles.
How can I get SQLAgent to recognize that I've set up a new mail profile?
hi, I have settup up sql mail and did the following:
1. created an E-mail account and configured Out look by creating a pop3 mail profile. tested it by sending and receiving mail, that is ook
2. I Created one domain account for MSsqlserver and Sql Agent service. both services use same account and start automatically in the control panel-services
3. I used the profile that I created in outlook to test the sql mail but got an error:
Error 22030 : A MAPI error ( error number:273) occurred: MapiLogon Ex Failed due to MAPI
Error 273: MAPI Logon Failed
I really do not know what went wrong. I followed the steps from bol and still having a problem. Am I missing something.
I do have a valid email account
I do have a valid domain account
I tested outlook using the email account and it worked. so why sql server does not recognise MAPI.
My next question, How to configure MAPI in Sql server if what I did was wrong.
We have a previous SQL 2012 cluster that emails us when a new database is added. I am unable to figure out why we get this error any time we add a new database to it, and also it prevents us from adding a new availability group to this cluster because of this error.
I also am unable to figure out what profile it is talking about as this was setup before me and I am not a DBA.
I am trying to install SQL Mail to send automatic system messages. The SQL Mail service starts but when I try to test it I get the following error. Does any one have any solution to this problem?
Error: A Mapi error ( error number 273) occured. Unable to get the default MAPI message Store due to MAPI error 273. The information store could not be opened.
I am trying to install SQL Mail to send automatic system messages. The SQL Mail service starts but when I try to test it I get the following error. Does any one have any solution to this problem?
Error: A Mapi error ( error number 273) occured. Unable to get the default MAPI message Store due to MAPI error 273. The information store could not be opened.
Hello,
I would like to send e-mails from MS SQL Server 7. Does Linux accept MAPI client e-mails and deliver them? And if so, how does one set it up?
Thanks,
Denise
Hi,
I recently installed MS SQL server version 7.00.623 on a Win2k server. I installed Outlook 2000 and had the Exchange Administrator create a mailbox in order to use SQL Mail and SQL Server Agent alerts when jobs fail. The Outlook mailbox was set up with a different name then the SQL Server Agent so I created a new account for the SQL Server Agent to match the name of the mailbox. I can send and receive mail from Outlook when logged into the server but I receive the following error when testing the profile in SQL Mail and SQL Server Agent properties:
"[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)"
The SQL Server Agent account is a NT User type, uses NT Authentication and has sysadmin server privledges and I am attempting to configure the mail while logging in to the server via Terminal Services Client using this account. I have tried to stop and restart the SQL Server Agent services but still receive the same error. When I log into Outlook, I receive a dialog box titled "Enter Password" that asks for a user name, domain name and password. The Exchange Admin. set this up so I have to use my user name, domain and password.
Do I need to install a service pack for SQL Server?
Did changing the SQL Server Agent account cause this to fail?
Does anyone have any insight on why I cannot get SQL Mail configured?
Thank You So Much
I have several dts packages that run just fine through a third party scheduler. I then put a mail task on them to tell me if the package succeeded or failed. Every time the scheduler gets to the mail task it fails and logs a mapi login failure error. When I execute the dts package on my local box it sends the email with no problems. is it a problem with the robot login or is it associated to the profile? any help would be greatly appreciated.
Elizabeth
My IT manager doesn't like the idea that a production process written in DTS needs Outlook 2000 running for DTS Email. I tend to agree that having an app like Outlook 2000 running in the production machine is kind of tacky. Am I missing something here? Why would MS suggest such a solution? Is there a way to configure DTS and Outlook so Outlook doesnt have to be running as an app?
Chiefley
I have a situation where a SQL Maintenance Task is running, and suppose to email a report to the sys admin. Currently I am getting a Microsoft SQL-DMO Error 17903, Mapi Login Failure.
I have tested the Outlook 98 application and the profile is set correctly. I have tried to send an email within SQL and I receive the error above. I have carried all activities suggested by Microsofts Online Books. Can anyone suggest where to go from here. All Service Packs have been applied.
Thanks
Chris Le ROY
Error message "Unable to get MAPI profiles" in send mail task(DTS).
View 4 Replies View RelatedI set up e-mail on my SQL server (7.0) via SMTP.
I installed Outlook '97. Typical Installation.
Everything was working fine, for couple of days,
then I got Dr. Watson messages, about MAPI.
Dr.Watson
The application, exemapisp32.dbg, generated an application error The error occurred on 11/ 7/2000 @ 11:35:48.437 The exception generated was c0000005 at address 6e4f2630 (<nosymbols>)
Then SQL will give me this message:
Unable to read local eventlog (reason: The data area passed to a system call is too small).
Anyway, try to reinstall Outlook '97, but the problem continues.
Any help, will be greatly appreciated.
Hi friends,
I have Exchange & sql 7.0 on the same box. I have configured sqlserver
and sqlserveragent for the same nt login. Also a Mail profile is created and assigned to SQL-MAIL & SQL-AGENT.
I have a back-up job in SQLSERVER and the notification is set to exchange mail box. For the first time after restarting the exchange services, the notification works fine. But for the subsequent job executions, the notification failed and the message is "MAPI LOGIN FAILED".
Can any one help me..
Thanx in advance.
regards
MANI
(Isn't this fun? Type MAPI and SQL into Google and it almost tilts!)
Here is the situation:
1- When SQL Agent starts, it establishes a MAPI session. For some bizarre design reason, it keeps that session open as long as it is running, rather than re-opening the session when it has mail to send. (this can be days, weeks, or months)
2- Frequently, Exchange servers are clustered. When the virtual server moves to a different physical server in the cluster, - or the Exchange server is restarted for whatever reason - the (above) MAPI session of the SQL Agent gets jammed.
3- SQL Agent tries, and fails to send an E-mail saying (for instance) that a database dump has completed (etc.)
4- User posts a question to some forum, asking for help again.
My solution: I created a job to run on a daily basis to restart the SQL Agent, and re-establish the MAPI session. Voila!
The problem: Now we (sometimes) get the message:
[241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started)
This is incorrect - the service was never stopped!
*sigh* No hits in Microsoft or Google - Back to the drawing board.
SO: Can anyone think of a way to *test* the MAPI connection in a job step (without actually sending a message), so that the agent restart job is only executed if the MAPI connection is failing?
I have not yet set up SQL2K mail -> Notes, but I see in Q263556 a warning regarding extended MAPI and non-Exchange servers.
Just wondering if anyone is using a SQL2K - Notes MAPI profile -- and if any reliability issues have come up?
Thanks in advance
Scenario:DBMS: SQL Server 2000OS: Windows Server 2003Goal:Enable SQLMAIL via Internet MailProblem:How do I set up the MAPI profile for the SQL Server service account?On Windows 2000 Server, I can use "Control Panel"/"Mail" tocreate a MAPI profile for the SQL Server service account, and thenreference that profile for SQLMAIL in SQL Server and SQL Server Agent.But on Windows Server 2003, there is no "Mail" applet in "Control Panel".How do I create a MAPI profile, for the SQL Server service account,on Windows Server 2003?
View 5 Replies View RelatedIs there a way to change the FROM in sqlmail (recipient) from the mailbox account to read a user-defined from. Currently our FROM has the SQL mail account name that was created during the sqlmail setup and we would like to put a user defined name in this variable.
View 1 Replies View RelatedFor the life of me, I cannot get SQL Mail Support Services started on one of my SQL Server 7.0 SP3 boxes. It works fine on other machines of mine. I have a mail profile created using proper accounts who have access to email box. I have configured SQL Server to use that mail profile.
ERRORLOG shows the following each time I try and start the SQL Mail Support Services:
2001-03-05 10:23:48.98 ods Starting SQL Mail session...
2001-03-05 10:23:50.20 ods Error: 17903, Severity: 18, State: 1
2001-03-05 10:23:50.20 ods MAPI login failure..
2001-03-05 10:23:50.20 ods Error: 17951, Severity: 18, State: 1
2001-03-05 10:23:50.20 ods Failed to start SQL Mail session..
Do you have any thoughts or where I may turn for support, other that Microsoft's pay-per issue support?
Thank you,
Brian Kilby
Hello sir,
I want to configure SQLMail; I use Eudora.
how can-I do that?
Please advice me..
Dear people,
We have tried to get sqlmail (SQL SERVER 6.5) working on windows NT 4.0. However when we start sqlmail through the enterprise manager we get an error:
"error 17952 sqlserver failed to start sql mail session". MSmail client works ok on the NT machine. The profile in nt mail is the same as the profile name in de configuration of sqlmail. What could be wrong?
Thanks for reading
Michel Landman
I have installed MS exchange client on my NT 4.0 server.
and installed SQL server 6.5 on same.I have marked MSSQL server service as log on as service and also map correct profile in exchange.I am able to start
sql mail service but when i am trying to send a mail by xp_sendmail i am getting error:
Msg 17914,level 18,state 1
Unknown recipient: Parameter `@recipients`,recipient `devendrar`.
where `devendrar` is profile name
and what i am trying to do is :
xp_sendmail `devendrar`,`msg to send`
can u pls help me to solve this problem.
Devendra Rane.
Is there any other way to send emails without using SQLMail or xp_sendmail?
without a mail client ?
I have the following error when trying to test EMail from SQL.
I have logged onto the server and sent EMail using the SQLServer Service Account and the Profile is correct. This tells me that Outlook is working OK and the Exchange Server is sending OK. However, lookin on TechNet Q274330
mentions the error number but it's description is about Emailing an open file. I am not Emailing an open file.
Here's the error message.
xp_startmail 'eweb02mail'
Server: Msg 18025, Level 16, State 1, Line 0
xp_startmail: failed with mail error 0x80040106
Or right clicking on SQLMail and click on Test
xp_test_mapi_mail 0x80040106
Hi all.
I'm having problems with sqlmail. SOMETIME when I try to send a message the server replies "Could not find the function xp_sendMail in sqlmap60.dll". or ISQW don't finish the query never.
Sqlmail is running. I'm using Outlook express as a simple mapi client.
Sorry my english.
Any help will be appreciate a lot.
Thanks in advance.
Armando Marrero
Armando@Novell2.get.cma.net
Does anyone know how set up SQLMail and SQLAgentMail (SQL 7/2000) to send email to Groupwise 5.5? Or is it possible at all? Any feedback will be very much appreciated.
View 1 Replies View RelatedThe start / stop options on the SQL Mail support service are not there.
I'm running with SQL 2000 on Server 2000, with MS Outlook 2000 as the MAPI Client. The client is configured and sending just fine. The SQL Mail properties Test button was able start/stop a mapi session. The profile name on the general tab is "Microsoft Outlook Internet Settings".
Suggestions appreciated.
Has anyone successfully integrated Groupwise 5.5 with SQLServer 2000? Any suggestions would be appreciated.
Thank you.
I am using SQLServer2000 with sp3.The SQLServer logs on as user Test on the local computer. I am loggedon as user Test on the local computer.I have created a Exchange Profile and tested that it can send andreceive mail.When I go to Enterprise Manager to set-up this profile for SQL Mail.There is nothing in the drop-down list box.Any ideas?ThanksM
View 1 Replies View RelatedTrying to get my jobs to send mail when job fails. Should be easy butit's giving me headacheHad a whole slew of issues. Outlook is installed with a n outlookmail profile set up that can send mail in outlook. I can create aSendMail DTS and execute it to send mailEmail works in these scenarios1. I create a DTS package in SQL Server with just SendMail with thesame Profile "ABC" and click Execute and it sends2. I can send using Outlook with the same profile "ABC"3. I can run DTSRun with command prompt calliing the DTS package andit sends fineHowever it wont send in these 3 scenarios (where I need it!):1. I go to Operator, and put my Profile "ABC" in the Email Name,click Test and I get this error "Error 22022: SQLServerAgent Error:The SQLSErverAgent mails ession is not running; check the mail profileand/or the SQLServerAgent service startup account in theSQLSErverAGent PropertiessQLServer Agent is running2. If I add the DTS Package "EmailTest" to one of my jobs as a stepto go to if the 1st step fails, nothing gets sent3. In JObs -- Notificatioin, If I set the E-maill operator to myoperator, nothing gets sentI set the Mail Profile to the Mail Profile (in SQL Server AGent'properties)However when I click Test, I get this error:Error 0: Cannot load the DLL sqlmap70.dll, or one of the DLLs itreferencesI am usingSQLServer Version 8.00.194,OS Windows 2003Help!
View 3 Replies View RelatedI recently set up a SQL 7.0 cluster (active/passive) on a pair of Win2K boxes. I noticed that the SQLServerAgent would refuse to send system alerts to my e-mail account, yet net sent messages worked fine. I know I've set everything up properly, so I paid the $245 to speak with Microsoft.
The answer was found; their response follows:
{redacted}
CAUSE:
============
On a cluster an undocumented stored procedure is called by the Operator to send email and this causes it to fail. SQL Mail is not supported on SQL 7.0 clusters and any features depending on it will also fail.
RESOLUTION:
============
SQL 2000 does support SQL Mail on clusters with MS Office 2000 and up.
In SQL 2000 Books Online do a search for the following topics and include the quotes:
“Using SQL Server Tools with Failover Clustering”
Also you can workaround the problem by using a job that uses xp_sendmail to send the alert instead.
{END}
Now is that lame or what? Of all the functions you would expect to work in a failover cluster, you would think that e-mailing the operator in the event of a failure would be high on the list. Apparently, not so. Their official answer was to upgrade to SQL2000. Anybody care to guess the price on doing a dual CPU dual box cluster upgrade?
Now my question is this: The tech person was right, xp_sendmail does work fine. What I have wanting to do, and have been unable to do, is to write a TRIGGER that would fire whenever an error is logged by the SQL server. I have looked around, but could find no documentation on what table it is that receives error logs.
Does anybody know which table receives error messages? I'm wanting to write a trigger that exec's xp_sendmail so I get error alerts.
Does anyone know the 'trick' in getting sqlmail (sqlserver 7.0) to work with Outlook 2000 on a windows 2000 server machine. I've setup a mail profile on Outlook, but it is not listed in the dropdown menu in the sqlmail properties.
Outlook communicates with my smtp/pop3 mail server - no problem. I can't get sqlmail to interface with outlook. Basically it is telling me that it cannot find ANY profiles on the server.
I need to set up SQLMail togheter with Notes, We have SMTP server and profiles but I can´t get it to work. SQL sends the mail but it disappears into the cyberspace.. Someone help me pls...
View 1 Replies View RelatedHas anyone created a stored procedure that notifies a customer that their order_status has been changed from 'submitted' to 'backordered' or from 'backordered' to 'shipped'? Once written, how does the sp get automatically executed? Does anyone have an example or a book/site with an example?
--Thanks in advance.