microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Error 22022: SqlServerAgent Error: Unable to resolve email rec

Subject: Re: Error 22022: SqlServerAgent Error: Unable to resolve email rec
From: Tom
Date: Tue, 19 Jul 2005 11:47:08 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Saigman,
I just stopped and restarted the SQL Agent.   Test of the operators are now 
working for me.

"saigman" wrote:

> Hello, Tom:
> 
> No, I haven't been able to resolve this issue at all, nor have I seen any 
> real postings about it on the net.
> 
> The fact that you had the same problem on the same day is rather 
> disconcerting; hopefully, it is an unhappy coincidence.
> 
> If I find anything, I will post.
> 
> Thanks!
> 
> "Tom" wrote:
> 
> > Hi Saigman,
> > We started to have this problem as well; started on the same day that you 
> > wrote this.  Have you been able to resolve it?
> > 
> > Sending mail via xp_sendmail works fine, but using operators we are getting 
> > the 22022 error
> > "Error 22022: SQLServerAgent Error:  Unable to resolve email recipient name 
> > 'worldadmin' (reason: One or more of the recipients was not found in the 
> > address book."
> > 
> > "Joe Webb" wrote:
> > 
> > > Hi Saigman - 
> > > 
> > > You may want to login using the SQL Server login account and try
> > > sending email to that recepient. 
> > > 
> > > BTW - You'll have better luck by posting this question to another
> > > newsgroup such as microsoft.public.sqlserver.server 
> > > 
> > > This on is dedicated to the SQL Server Notification Services add-on.
> > > 
> > > HTH...
> > > 
> > > -- 
> > > Joe Webb
> > > SQL Server MVP
> > > 
> > > 
> > > ~~~
> > > Get up to speed quickly with SQLNS
> > > http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 
> > > 
> > > I support PASS, the Professional Association for SQL Server.
> > > (www.sqlpass.org)
> > > 
> > > 
> > > On Thu, 14 Jul 2005 07:52:01 -0700, "saigman"
> > > <[email protected]> wrote:
> > > 
> > > >Hello:
> > > >
> > > >I had SQL Notifications working fine.  Recently, though, the 
> > > >notifications 
> > > >are not being sent when a designated event occurs, and when I go to test 
> > > >the 
> > > >operator e-mail configuration, I receive the message listed in the 
> > > >subjest 
> > > >heading.
> > > >
> > > >The changes that I know of on the server since the notifications were 
> > > >first 
> > > >setup was that SMTP services were enabled, and the SQLMail profile 
> > > >points to 
> > > >the same profile Outlook uses for the contacts.
> > > >
> > > >I tried searching in the technet and knowledge base areas, but the 
> > > >search 
> > > >didn't provide any useful information.
> > > >
> > > >If anyone could point me in the direction of what may be wrong and how 
> > > >to 
> > > >correct, I would be appreciative.  Thanks!
> > > 
> > > 

<Prev in Thread] Current Thread [Next in Thread>