by I'm using SQL Server 7.0 sp1, Outlook 2000 mapi dlls, and Lotus Notes r5
client. I simply copied the mapi dlls (mapi.dll, mapi32.dll) from another
machine that had Outlook 2000 installed.
I've set everything up so that i log in to the machine with login NTLogin,
SQL Server starts up with login SQLServerAdmin, and SQL Mail and SQL Agent
Mail both start up with a mail profile created under the login
SQLServerAdmin.
I've configured everything apparently correctly following the guidelines set
out by other posts in this newgroup (clips of these posts are below).
When i first boot up the machine everything works fine. I can log in under
any account (even new ones). Both SQL Agent Mail and SQL Mail start up no
problem and i can send mail from both of them. I never open any other
applications (including the notes client). However, if i ever log off the
machine and log back in (which account I log in with doesn't matter - even
if i log back in with the same account i just logged out as) both SQL Agent
Mail and SQL Mail stop working. If i push the test button in the properties
of SQL Mail after logging back in i get the following error:
Error 22030: A MAPI error (error number: 87) occurred.: MapiLogonEx Failed
due to MAPI error 87: Invalid parameter. SqlDumpExceptionHandler: Process 7
generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is
terminating this process
I tried logging out and back in as SQLServerAdmin, creating a new mail
profile and setting SQL Mail and SQL Agent Mail to it. However, I get the
same error as listed above. If I restart SQL Server (no machine reboot
necessary) everything works fine again.
As this machine needs to be up 24x7 restarting SQL Server is not an option.
I would also prefer to have the login used to log in to the machine have no
access rights so anyone (our devs) can start up the machine and access
certain files but do not have Administrative rights over SQL Server or the
machine. If i then need to do something that requires admin rights i would
simply log off and back in. However, this would cause SQL Mail to stop
working.
Any insight or suggestions would be appreciated.
Thanks in advance,
Bob
From Mary Bray
This is certainly possible, and I think you just need to get the steps in
the right order. Try this:
1. Stop SQL Mail and clear the mail profile.
2. Clear the mail profile in SQl Server Agent and stop the service.
3. Set both Server and Agent services to start with the new SQLServerAdmin
login.
4. Stop and start both.
5. Log off, then log on as the SQLServerAdmin.
6. Create your mail profile and set it in SQL Mail and for SQL Server Agent
Mail.
7. Start SQL Mail and test both.
8. Log off and back on as someone else - it should all be working.
From Tibor Karaszi
I guess that your problems comes from the fact that when you login
interactively as some other NT account then the MSSQLServer service is
using, you then start another (interactive) mail session.
You now have two different mail users on the machine (where one is the NT
account which SQL Server is using and the other is the one the you are using
interactively). As I understand it, the "MAPI spooler" is a single user
application (at the machine level), and it will be confused by having two
simultaneous users.
This might have been fixed in later releases of the mail support (mapi
dll?).
You could also tell everyone to "not check your email on the sql server
machine".
--
Tibor Karaszi
MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please reply to the newsgroup only, not by email.