How to Configure Database Mail in SQL Server 2.R2 In this article we will talk about configuration of Database mail feature in SQL Server 2.R2. This feature was first introduced in SQL Server 2.So, same steps will work for SQL Server 2.Before we start the configuration make sure we have SMTP server details, which we can use to send emails form SQL Server.Also, we have enabled the database mail feature.In order to do that either we can run the below script spconfigure show advanced options, 1 GORECONFIGURE GOspconfigure Database Mail XPs, 1 GORECONFIGUREGOspconfigure show advanced options, 0 GORECONFIGURE GOOr, just start the configuration steps below and at the very first point, configuration wizard will show a window stating Database mail feature is not enabled, click yes to enable the feature.NOTE We have already enabled the database mail feature before we started the below configuration.So, we didnt get the window stating Database mail feature is not enabled. How To Install Brake Switch On Old Car . STEPS1 Connect to SQL Server instance from SSMS and navigate to Management a Database Mail.Right click on Database Mail and click on Configure Database Mail option.Y9Ky.jpg' alt='How Do I Uninstall A Sql Instance Database' title='How Do I Uninstall A Sql Instance Database' />Here select the first option Setup database mail.Type the desired profile name and profile description.Then click on Add button to add the SMTP accounts to this profile.Since this is the first profile we are creating, there will not be any Account name available.Here click on New Account to create a new account.Provide the below details Account Name Desires account name for this SMTP account.Description Description of the account.E mail address Email account from which emails will be sent.When recipient receives email, the sender email is shown as this address.Display Name Name associated with the email address.Reply e mail where reply to the emails will be forwarded.Server name Provide the SMTP, which is to be used to send emails from SQL Server.Port Number Port number to be used by this account.Default is 2. 5. SMTP Authentication Select the desired authentication to be used and then click OK.Then click Next on new window.This screen will show the public profiles available.We can see Test profile which we created above.This screen will show the private profiles available.Sample Syntax To install a new, standalone instance with the SQL Server Database Engine, Replication, and FullText Search components and enable instant file.How Do I Uninstall A Sql Instance Database' title='How Do I Uninstall A Sql Instance Database' />We can see Test profile which we created above.You can select the account that you want to associate to private profile.Make necessary changes to the Database mail system parameters and move to next step.Database Mail Configuration Wizard will show the summary of the actions to be performed.Click finish and database mail is configured.You can test the newly configured database mail feature by right clicking on Database Mail and click on Test email.Then select the recipient email and send the test email.No related posts.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |