July 19, 2002 at 1:12 am
I everybody,
I use SQL server 2000 SP2 under W2K Adv SP2 clustered between two compaq DL360 and compaq bay.
I already installed MAPI client (outlook) on both nodes and SQLMAIL Test return :
"succefully started(and stopped) a mappi session with this profile".
The problem is mail doesn't be sent because SQL return this message :
Microsoft sql-dmo(odbc sqltate: 42000)
error 22022:sqlserveragent error: unable to resolve email recipient. reason one or more of the recipients was not found int the adress book
nevertheless I created same user mail account
on both nodes with same system user.
did I mess anything ?
Anybody have a idea ?
July 19, 2002 at 9:34 am
I am not sure specifically about your issue, but I have a way that makes all the mail work regardless. We use it within our cluster.
We only have SQLMail installed on one server. All of the other SQL Servers do Event Forwarding (advanced tab of SQL Server agent properties) to that specific SQLMail configured SQL Server.
The advantage of this is that you only need to configure all of your Operators and Alerts in one location, on the SQLMail server.
You write all of your Raiserror statement to do it WITH LOG so that everything will be event forwarded to the SQLMail server.
I have found this method to be super easy to manage all of my operators and alerts and I only have to monitor SQLMail on one server.
July 22, 2002 at 2:51 am
thank you.
you resolved my problem.
Often the easiest way is the best 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply