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.
No comments:
Post a Comment