Friday, 28 June 2013

SQL Server 2000 SQL Mail


How to Configure Sql Mail
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 an Exchange server is used as the mail server. It can be a local or domain NT account if POP3/SMTP mail server is used as the mail server.
The basic procedure is to log on to your Windows NT server using the account you used to start SQL Server, create mail profile and then provide this mail profile to SQL Mail.
Pre-requisites:
1. On the Microsoft Exchange server, a mailbox should be created for the user
account that is to be used by the MSSQLServer service. This account must be a domain account.
2. An Exchange client(Example:Outlook) must be installed on the SQL Server
computer.
Steps to Setup SQL Mail
1) On the SQL Server computer, log on to Windows Server by using the same user account that is to be used by the MSSQLServer service.
2) Next we need to configure a Mail profile. We can do this by going to Control Panel, clicking the Mail icon. The below screen will appear.

3) Key in the profile name & click OK.
4. You will find an Email Accounts Wizard, Click on the option Add a New Email
Account & click on NEXT

5. Choose Microsoft Exchange Server & click on Next.

7) Go to Enterprise Manager, Support Services, then to SQL Mail and right-click properties and choose the newly created profile name. Then click the test button.
6. Key in Microsoft Exchange server Name & User Name. Click on the Check
Name box to ensure that user is registered properly and then click on finish button.


Popular Posts