asked on

Help needed using SQLMail

I'm trying to configure SQLMail on SQLServer 7.0. When I try to test the mail service I get the error message :-

Error 22030. A MAPI error (error number 285) occurred. Unable to get the default MAPI message store due to MAPI error 285. You do not have permission to log on.

Can anyone help ?

xnmb

make sure the MAPI profile used by SQL Mail is configured for your MSSQLServer service log on account

gng

Thanks - I've checked this and it is but I still get the error.

xnmb

hehe...now check if the logon account YOU are using is THE SAME as the the logon account used by MSSQLServer service to start.

in other words, the logon account used by MSSQLServer service to start, the logon account you are using, and the domain account your MAPI profile is configured for MUST be ONE and THE SAME!

great, aint it?! good luck.

gng

Looks good ! So, to summarise am I right in saying :-

"the NT account that owns the Exchange mailbox must equal the NT account that runs the MSSQLServer service must equal the NT account that runs the MSSQLAgent service ?"

OR just

"the NT account that owns the Exchange mailbox must equal the NT account that runs the MSSQLAgent service ? (i.e. it doesn't matter which NT account runs the MSSQLServer service)"

xnmb

NT account that owns the Exchange mailbox,NT account that runs the MSSQLServer service,NT account that you use to logon to an SQL Server machine in an NT domain MUST BE ONE AND THE SAME.

had the same problem a couple of days back and that was what i figured out to run it successfully. weird, but worked for me!

ASKER CERTIFIED SOLUTION

jsaxon2

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial