May 15, 2003 at 10:42 am
Do you have to have Outlook to get mail sent from SQL.
I want to set it up so that when the transaction log rises above a certain level I am notified. I suppose that I need to add a user. I entered my email address but don't have Outlook. thanks.
May 15, 2003 at 11:00 am
You must have a mail client that can be outlook. But is must configured in sql. It is not just adding your email adress.
You can also be notified by net send notifications, wich is much easier. You must just add the net send adress in an operator.
May 15, 2003 at 11:07 am
You must have a mail client that can be outlook. But is must configured in sql. how do you configure it? and how do you configure net send address in an operator?
May 15, 2003 at 11:17 am
To configure the email you must use a domain user to start both sql services (mssqlserver and sqlserveragent). Then you must log in to your server with that user, and create a mail profile with outlook with a valid email adress of that user. Then with EM, you select that email profile on SQL Server Agent\properties\mail session and the same in Support Services\SQL Mail.
To use netsend or email you must configure an operator from SQL Server Agent\Operators\right click \nwe operator.
there you put the name and specify the net send adress or the email adress.
Check that you can test both notification types.
May 15, 2003 at 11:48 am
Error 2002: SQLServer/Agent Error The sqlagen mail seesion is not running check the mail profile & or SQLserver/Agent Service startup account in the SQL/Agent Properties Dialog.
thats the error i get, you mean you can send mail when you signed in as SA ?
May 15, 2003 at 12:19 pm
You must login to your windows server, not SQL with the domain account you use to start the services. Then create a mail profile and configure SQL. Always in the windows sessions of that user.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply