SQL Mail Server with outlook pop3,smtp

Question

SQL Mail Server with outlook pop3,smtp

hansandersenyu

Old Hand

Points: 319
More actions
December 21, 2010 at 5:45 pm

#242662

Good Day
I am new to a company and was given a pet project to set up the sql mail server to send email notifications when scheduled task fails to run.
I have been reading guides this past few days and i haven't seen any that has help resolve the issue that i have encountered.
First here are the details:
OS: Windows XP Service Pack 3
MS SQL: MS SQL Server 2000 Service Pack 4
Mail Client: Microsoft Outlook 2003
Mail Server: Pop3, SMTP
All our accounts use pop3 and smtp
The re occurring problem that i have been encountering with all the guides is that:
1) The SQL Mail Profile does not appear in the dropdown
2) Some guides suggest manually typing the profile name and encounters the testing "error 18025:xp_test_mapi_profile: failed with mail error 0x80040111"
Thanks

Viewing 10 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

Login with the same account that SQL uses to login. Create the mail profile. Restart SQL and agent. Then it will be in the list..

CEWII

hansandersenyu Old Hand Points: 319 More actions · Answer 2

@Elliott Whitlow

I am using the system account (admin account), if I'm correct the mail profile is made with this steps

Control Panel -> Mail -> Show Profiles -> Add

if so, yes i have already have created a mail profile as instructed with the guides that i have read.

Thanks

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

If you are using something like localsystem, network service, or something like that you are already done. That is not a supported configuration. SQL MUST login as a user.

Sorry. The system does not have mail profiles, users do.

CEWII

hansandersenyu Old Hand Points: 319 More actions · Answer 4

Can you pls elaborate further?

I'm kinda new to this so I didn't understand much of what you posted earlier

Thanks

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 5

Ok, SQL Sever must be using an either local account (created on the machine) or a domain account to login. This account is what the services use. You can setup a mail profile by logging in on the machine as the same user and setting the profile up. But first you need to get SQL using a user account.

CEWII

Lowell SSC Guru Points: 323546 More actions · Answer 6

Elliott Whitlow (12/22/2010)
Ok, SQL Sever must be using an either local account (created on the machine) or a domain account to login. This account is what the services use. You can setup a mail profile by logging in on the machine as the same user and setting the profile up. But first you need to get SQL using a user account.
CEWII

visualizing what Elliot said...the account used has to login to the SQl desktop...so if you go to services you might see this:

That account has never logged into the SQl desktop, and thus can never have had Outlook set up.

so you either have to login as that account once, or change the acocunt that SQL is running under:

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 7

Elliott Whitlow

SSC Guru

Points: 102402

December 22, 2010 at 9:13 am

#1265573

Thanks Lowell.

CEWII

hansandersenyu Old Hand Points: 319 More actions · Answer 8

Thanks guys this really helped me out.

i know this might be an OT question but here i go

have any of you experienced having a lock on .pst between outlook 2003 and sql mail server?

I experienced this just this morning with the 3 servers that i was planning to configure auto notifications for failed jobs

TIA

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 9

This would only happen if you were using SQL Mail, which uses MAPI, I thin kwe might have missed that you were using SQL Mail.. I STRONGLY recommend against using SQL Mail, database mail is the way to go..

However, by default it isn't available, BUT if you follow these instructions it will be 🙂

http://weblogs.sqlteam.com/mladenp/archive/2007/07/01/60245.aspx

CEWII