Post reply

Investigate mail service notifications on DB server

  • September 9, 2013 at 7:27 am

    #297573

    Hi Fnds,

    i am looking to find kind of investigation notifications from sqlservers. so i want to identify those servies which server is using mail services. also want migrate one environment to another environment.

    Can anyone have idea?#

    Replays are welcome.

    cheers,

    AtTitUdE BuIlDs ThE TrUst........!

  • September 10, 2013 at 12:17 pm

    #1648996

    Hi,

    That may be a security breach unless you are a domain administrator.

    First, by mail services, do you mean, "Database Mail"

    If you do, what do you want to do: find out if it is configured or if it is used in case it is configured?

    Second, do you know your domain servers that run SQL Server and their instances?

    Do you have access to the servers? Do you have access to SQL Servers? If you do, say, you are a domain SQL admin with a powerful login and have a list of all SQL instances, you can run sp_configure with Show Advanced Options to get the settings for Database Mail XPs and get the value.

    If you are not an admin of any kind, but have access to SMTP relay administrator you can ask him to look for the records on SMTP relay coming from certain servers where you know SQL Server is installed. Not garanteed - because there could be other code on the servers that sends SMTP mail.

    Yelena

    Regards,Yelena Varsha

  • September 11, 2013 at 6:48 am

    #1649261

    Thanks Yelena

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

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