Outlook Configured BEFORE SQL Installed - OK? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Outlook Configured BEFORE SQL Installed - OK?

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-05 : 00:07:07

Michelle writes "We have new hardware that we recently configured in order to replace an existing server. Since we are using SQL 7 for these databases, we waited until off-peak hours to install SQL so that we could install it using the production host name. One of the things that we did do ahead of time was to install Outlook 2000 and configure it with the profile/mailbox for SQL Mail.

The server has service pack 3 for SQL 7 and we used
windows update on 10/26 to apply service packs/security patches to Windows 2000 server.

I don't think that we have a problem or error with the mailbox or profile as I've configured Outlook 2000 on several sql servers recently and they work just fine. Plus, I've read and re-read many KB artilces on this subject, just to make sure that I didn't miss anything.

The server is running W2K server. I uninstalled Outlook (didn't reboot - wasn't prompted to do so) and reinstalled it. I used RegClean in between. However, the new install already had the profile for SQL when I first launched it from the account used to run sql.

So, I uninstalled and reinstalled again. This time, I deleted the profile from Outlook before uninstalling. Still used REGClean in between and did not reboot.

Same errors.

My next attempt to fix this will be to uninstall outlook, reboot, and then reinstall outlook. But, before scheduling this reboot - I thought I'd make one last effort to either confirm that Outlook should be installed AFTER Sql or that these error messages mean anything to anyone else.

When trying to start SQL Mail from Enterprise Manager:
Error 17952: Failed to start SQL Mail session. Check the errorlog file in
the SQL Server directory for details.

Checking the errorlog file in the SQL Server directory for details:
2001-10-29 15:44:32.54 ods Starting SQL Mail session...
2001-10-29 15:44:32.60 ods Error: 17903, Severity: 18, State: 1
2001-10-29 15:44:32.60 ods MAPI login failure..
2001-10-29 15:44:32.60 ods Error: 17951, Severity: 18, State: 1
2001-10-29 15:44:32.60 ods Failed to start SQL Mail session..

Testing the MAPI profile name using Enterprise Manager:
Error 22030: A MAPI error (error number: 16389) occurred.: MapiLogonEx
Failed due to MAPI error 16389: The MAPI Call failed.

Message from SQL Query Analyzer when running xp_startmail:
Server: Msg 17952, Level 18, State 1, Line 0
Failed to start SQL Mail session. Check the errorlog file in the SQL Server
directory for details.

Application Event Log:

Event Type: Error
Event Source: MSSQLServer
Event Category: ODS
Event ID: 17052
Date: 10/29/2001
Time: 3:50:29 PM
User: N/A
Computer: AFNBLDSQL2
Description:
Error: 17903, Severity: 18, State: 1
2001-10-29 15:50:29.44 ods MAPI login failure..

Data:
0000: ef 45 00 00 12 00 00 00 ïE......
0008: 0b 00 00 00 41 00 46 00 ....A.F.
0010: 4e 00 42 00 4c 00 44 00 N.B.L.D.
0018: 53 00 51 00 4c 00 32 00 S.Q.L.2.
0020: 00 00 00 00 00 00 ......

Event Type: Error
Event Source: MSSQLServer
Event Category: ODS
Event ID: 17052
Date: 10/29/2001
Time: 3:50:29 PM
User: N/A
Computer: AFNBLDSQL2
Description:
Error: 17951, Severity: 18, State: 1
2001-10-29 15:50:29.44 ods Failed to start SQL Mail session..

Data:
0000: 1f 46 00 00 12 00 00 00 .F......
0008: 0b 00 00 00 41 00 46 00 ....A.F.
0010: 4e 00 42 00 4c 00 44 00 N.B.L.D.
0018: 53 00 51 00 4c 00 32 00 S.Q.L.2.
0020: 00 00 00 00 00 00 ......

I did get some other error message at some point indicating that the file:
EMSMDB.DLL could not be found. I do have EMSMDB32.DLL.

The SQL Server Services account can send/receive mail with this profile using Outlook. This same SQL Server Services account works just fine on all of our other 20 + servers.

Michelle

chadmat
The Chadinator

1974 Posts

Posted - 2002-01-09 : 18:33:00

Search your system for mapi32.dll

This file should be 128K for Outlook 2000. If there is a version (Particularly in winnt\system32) that is different, you have the wrong DLL, and should rename it, and replace it witht he one that is 128K in size.

HTH

-Chad

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources