Re: SQL Mail

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Shahriar (HelloShahriar_at_hotmail.com)
Date: 01/20/05 

Date: Thu, 20 Jan 2005 06:47:57 GMT

R.D
Thanks for your quick response. The test fails under the enterprise manager
when entering the profile name.
If SQL mail only works under a domain name, then I guess this can not be
configured the way I am trying it. I have a standalone machine running XP
professional and am not connecting to any domains at all.

Thanks
Shahriar

"R.D" <RD@discussions.microsoft.com> wrote in message
news:5236E496-1CB7-4376-8594-5C2F2159F9E2@microsoft.com...
> Hi Shahriar
>
> Check this:
>
> Open enterprise manager and click rightclick on sqlmail and enter profile
> to
> test it.
> If It displays message saying that profile started, Then profile is
> created.
> Otherwise
> Problem could be:
>
> 1.sql server should be running under a domain name
> 2.you should log on using the same domain name while you are configuring
> sqlmail in Enterprise Manager
>
> For More information see Configuring SQLMail in ms site.
>
> R.D
>
>
>
>
> "Shahriar" wrote:
>
>> I am trying to get Sql mail to work.
>> Here is what I have and what I have done. I am using Sql 2000 and just
>> applied sp3a. Also use Outlook 2002 sp1. I am trying to use SQL mail;
>> however, I am not able to see my profile name created under SQL mail. I
>> am
>> able to send/receive emails from outlook. In my control panel, under
>> mail I
>> do see 2 profiles that I have created. All the reading I have done
>> points
>> me to Extended MAPI. I do see mapi32.dll in my windows/system32
>> directory.
>> In my query analyzer, the execution of the following statement exec
>> xp_get_mapi_default_profile produces this result "Could not find a
>> default
>> MAPI profile"
>> What am i missing?
>>
>> Many thanks
>> Shahriar
>>
>>
>>

Relevant Pages

  • SQL Mail
    ... This Windows NT account needs to ... "Troubleshooting SQL Mail with Exchange Server" ... Confirm that the Exchange Server profile used does not ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Mail
    ... after doing that connect with SQL Server Enterprise Manage or Query Analyser ... I've also went to SQL mail and set up a mail profile. ... >> mailbox, a mail profile, and the Windows NT account you ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Mail
    ... Login was AD account, service was local account. ... Gary Angus ... profile. ... An alternative to SQL Mail is sp_smtp_sendmail. ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL server agent error 22022
    ... Agent is setup from the properties of SQL Server Agent ... SQL Mail is set up from Support ... I am able to set the mail profile and it tests sucessfully. ... "error 22022: sqlserveragent error: the sqlserveragent mail session is not ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Mail
    ... Gary Angus ... profile. ... An alternative to SQL Mail is sp_smtp_sendmail. ... Installed Outlook 2000 and setup my profiles as Internet POP3. ...
    (microsoft.public.sqlserver.tools)