How find the SMTP server to which my Database Mial is configured..

  • Hi,

    I know in my SQL server we have configured the Database Mail..But I am unable to find which SMTP server it is configured to ..I tried to check out in properties but in vain..

    Any help?

  • Through SSMS:

    1. Right click the database mail icon and choose configure Database mail.

    2. Choose Manage Databse Mail accounts and profiles and click next.

    3. Choose View, change, or delete and existing account, then choose next.

    4. The server name listed will be your SMTP server.

    Through a query:

    EXECUTE msdb.dbo.sysmail_help_account_sp;

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply