Re: SQL Mail
From: Steen Persson (SPE_at_REMOVEdatea.dk)
Date: 07/02/04
- Next message: Wayne Snyder: "Re: Database Maintenace Plan"
- Previous message: Wayne Snyder: "Re: Access Boolean to SqlServer???"
- In reply to: Steen Persson: "Re: SQL Mail"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 2 Jul 2004 14:14:35 +0200
...I've got my problem solved....I'd just missed to go to SQL server agent
properties and set the mail session profile in there.
Regards
Steen
"Steen Persson" <SPE@REMOVEdatea.dk> skrev i en meddelelse
news:%23kM7KT3XEHA.2812@TK2MSFTNGP11.phx.gbl...
> Hi
>
> I'm having the same problem with sending mails from SQL.
> I've installed Outlook 2003, I'm logged on as the user for which the
mailbox
> has been setup (sqladmin), both the SQLserver and SQLServerAgent services
> runs under this account, I can open Outlook and send "manual" mails
without
> any problems, but when I under Operators create the operator and click
> "Test" I get the error 22022 - The SQL ServerAgent Mail session is not
> running..etc.. I have no problems in clicking in the ".." box to get it to
> look up my name in the Global Address list so in some way it's able to
open
> Outlook. I've also went to SQL mail and set up a mail profile.
>
> If I'm trying to send a mail using the xp_sendmail it works fine.
>
> I can't think of any other things to check to get it working so I hope
that
> some of you have some ideas.
>
> Regards
> Steen
>
> "BMF1" <anonymous@discussions.microsoft.com> skrev i en meddelelse
> news:218d901c45aea$eed6d400$a101280a@phx.gbl...
> Joe,
> From the documentation I've read workgroups are not
> referenced. However, KB Article 263556 has a
> statement "SQL Mail requires a mail connection, a
> mailbox, a mail profile, and the Windows NT account you
> used to start SQL Server. This Windows NT account needs to
> be a domain account if you are using an Exchange server as
> your mail server. It can be a local or domain NT account
> if you are using POP3/SMTP mail server."
>
> The following is extracted from BOL:
> "Troubleshooting SQL Mail with Exchange Server"
> Typically, errors that occur when starting a SQL Mail
> session or sending mail from SQL Mail with Microsoft®
> Exchange Server fall into these categories: permissions
> problems and Exchange client setup problems. For more
> information, see SQL Mail.
>
> To troubleshoot problems with SQL Mail, complete these
> steps:
>
> Log on to Microsoft Windows NT® 4.0 or Windows® 2000 with
> the user account that will be used for the MSSQLServer
> service. This user account must be an administrator of the
> local computer and a domain account.
>
>
> Confirm that the Exchange Server client, Exchnge32.exe, or
> the Microsoft OutlookT client, Outlook.exe, can connect to
> Exchange Server and that e-mail can be sent. If using
> Outlook, ensure that Outlook has been installed with the
> Corporate or Workgroup option.
>
>
> Confirm that the Exchange Server profile used does not
> have a Personal Message Store (.pst). The Exchange Server
> profile name should not be longer than 32 characters.
>
>
> On the Services tab, confirm that the only services
> available are Microsoft Exchange Server and Personal
> Address Book, and then click the Delivery tab. Confirm
> that the selection in the Deliver To box is the mailbox on
> Exchange Server, which should have a name similar
> to "Mailbox - <Friendly User Name>" (where <Friendly User
> Name> is the name of the user who logged on to Windows NT
> 4.0 or Windows 2000in Step 1).
>
>
> To run SQL Mail with Exchange Server, the MSSQLServer
> service must be run under the same user account that
> logged on in Step 1. In Control Panel, double-click
> Services, select MSSQLServer service, and then click
> Startup.
>
>
> Confirm that the SQL Mail profile is correct. In SQL
> Server Enterprise Manager, expand the server, expand the
> Support Services folder, select SQL Mail, and then right-
> click. Click Properties, and then on the General tab,
> ensure that the profile name specified in the Profile name
> box is correct. (The profile name must match the profile
> name used in Step 3.) Click Test to verify that the
> profile was set up correctly.
>
>
> If SQL Mail fails to start (for example, gives you an
> error indicating that the profile was incorrect), check to
> make sure that Outlook Express is not set as the default e-
> mail client. In Control Panel, double-click Internet
> Options. On the Programs tab, verify that Outlook Express
> is not in the e-mail combo box. If you have to change the
> default e-mail client to a client other than Outlook
> Express, you may need to stop and restart the MSSQLServer
> service before verifying that SQL Mail can start with the
> mail profile.
> In some cases, a mail profile may get corrupted and SQL
> Mail will not be able to use it. To correct the problem,
> copy the profile to a different name, or re-create the
> profile.
>
> If the account used to start Microsoft SQL ServerT does
> not have access to the Exchange server, you cannot use SQL
> Mail. Test SQL Server access permissions to Exchange
> Server by executing xp_cmdshell, which executes with the
> same permissions as SQL Mail. Use the following command to
> test connectivity to the server, assuming Exchange Server
> is located on a computer named "MyServer".
>
> xp_cmdshell "NET USE \\MyServer\IPC$"
>
> If this command fails, Step 3 was not completed correctly.
>
> BMF1
> >-----Original Message-----
> >Thanks for the response.
> >
> >Yes the services are logging on as administrator.
> >
> >Do you know if there is an issue using WORKGROUP instead
> >of a domain?
> >
> >Thanks,
> >Joe
> >.
> >
>
>
- Next message: Wayne Snyder: "Re: Database Maintenace Plan"
- Previous message: Wayne Snyder: "Re: Access Boolean to SqlServer???"
- In reply to: Steen Persson: "Re: SQL Mail"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
