Eudora and Sql mail

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Eric:

How do i configure Sql mail to use Eudora as mail client. seems like Sql server is not recognizing Eudora at all, whereas I can successfully configure Windows messaging as mail client.

Thanks for your help.

Jay

-- Anonymous, April 20, 2001

Answers

Jay,

I don't find information on using Eudora as the mail client, but I did find this info in Neil Pike's FAQ.

Hope this helps,

Eric

Q. How can e-mail with SQL Server without using an MS-Mail or Exchange server? I'd like to use my standard SMTP/POP3 services.

A. A variety of methods :-

1. Use xp_cmdshell to run an SMTP sendmail program.

2. Use an XP with built-in SMTP functionality - http://www.spudsoft.demon.co.uk/code/index.html

3. Configure SQL Mail to use your normal SMTP/POP3 server:

For SQL Server and SQL Executive/SQL Server Agent to interact with SQL Mail, the SQL Server Service (MSSQLServer) and the SQL Executive (SQLExecutive) or SQL Server Agent (SQLServerAgent) service must be running under the same NT Domain account.

This account must be a member of the local Administrators group and have the "Log on as a service" right. Verify this in User Manager, and that the services are running under this domain account. For more details on this refer to Books Online: SQL 6.5 - "Assigning a Service Account to SQL Server or SQL Executive" SQL 7.0 - "Creating SQL Server Services User Accounts"

You will require a messaging client such as Windows NT Messaging or Microsoft Outlook to be installed on the SQL Server as well.

To create and configure the mail profile you will need to log on interactively as your "service" account user.

Open the Mail applet in Control Panel and follow the steps below to create your profile:

1. Click on the "Add" button to begin creating a Windows Messaging Profile

2. Uncheck the box next to "Microsoft Mail" (Unless there is an Exchange Server Available)

3. Ensure "Internet Mail" is checked.

4. Click on the "Next" button.

5. You will be asked for the method to connect to the mail server, check the radio button next to "Network".

6. Click on the "Next" button.

7. You will be asked to specify the Mail server name or IP address, enter either one here.

8. Click on the "Next" button.

9. You will be asked to choose the mode for transferring messages. Check the radio button next to "Automatic".

10. Click on the "Next" button.

11. You will be asked for the email address, enter it in the Email Address field.

12. Enter a suitably descriptive name in the Full Name field.

13. Click on the "Next" button.

14. You will be asked for the mailbox name. Enter a mailbox name in the mailbox name field, e.g. userid. (This is the mail server login name ).

15. Enter the password for the mailbox name in the password field. (This is the mail server login name's password ).

16. Click on the "Next" button.

17. You will be asked for a location for your personal address book. Use the default or move it as appropriate.

18. Click on the "Next" button.

19. You will be asked for a location for your personal folder file. Use the default or move it as appropriate.

20. Click on the "Next" button.

21. You should receive the message that setup is "Done!"

22. Click on the "Finish" button.

You will now need to configure SQL Mail to use your new profile. For SQL 6.5 you will need to run SQL Setup as described in the "Setting Up a SQLMail Client" topic of Books Online (See section "To set up SQLMail"). For SQL 7.0/2000 this can be done from Enterprise Manager, via the properties sheet of the SQL Mail node. For both methods, ensure you select the profile created above, and I recommend you set the SQL Mail to auto-start.

Start SQL Enterprise Manager, and ensure SQL Mail is running. You can then test it from Query Analyzer (ISQL/W):-

EXEC master.dbo.xp_sendmail 'myname@myaddress.com',@message='This is a test message.'

You should receive a Mail Sent message in the results pane upon execution.

===

v1.02 2000.06.05 Applies to SQL Server versions : All FAQ Categories : Server Administration and Tools Related FAQ articles : sqlmail, sqlmailstuckinoutbox Related Microsoft Kb articles : n/a Other related information : http://www.microsoft.com/technet/SQL/Tips/70mail.asp Authors : Neil Pike



-- Anonymous, April 21, 2001


Moderation questions? read the FAQ