SQL Agent mail setup - option greyed out

From: Kristian Aasbjerg (KristianAasbjerg_at_discussions.microsoft.com)
Date: 10/07/04


Date: Thu, 7 Oct 2004 15:29:05 -0700

This issue was also posted by Brian Taylor - Since no solution has been found
(as far as I can see), I hereby post the issue again...

I have read (a lot!) of info on how to configure/troubleshoot SQL Mail
setup. I have come so far, that I am able to send mail via SQL Server
(xp_sendmail), but even though i am using an identical configuration for SQL
Server Agent, it is not possible to select an email profile in the "SQL
Server Agent" - "Properties" - "Mail Profile" dialog box... The option is
simply greyed out!

Quite depressing... :o/

After a lot of reading, I've come to the conclusion, that this probably has
something to do with my "mapi32.dll" version. To avoid questions regarding
this, my config is as follows:

OS: Windows 2000 Server SP4
Exchange: 2003 SP1
Outlook: 2000
SQL Server: 2000 SP3a
Mapi32.dll: 6.5.7226.0

NOTE! I am running SQL Server, ISA Server and Exchange Server on the same
computer! (SBS configuration)

Any help is most appreciated...

Thank you in advance,

K.

-- 
Kristian Aasbjerg Andersen, MCSD
Denmark


Relevant Pages

  • RE: WSS install locked into MSDE DB - Can not install for SQL Serv
    ... For the MASTER database ... Althought we change the Configuration Application pool several times ... interface BUT they appear to be MSDE databases and not SQL Server databases. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)