Re: I must login as SqlServerAdmin before agent emails can be sent.

#1

Check the KB article 281293 at
http://support.microsoft.com/default...b;EN-US;281293. If this
won't help, check the articles at
http://support.microsoft.com/default...b;en-us;263556 and
http://support.microsoft.com/default...b;en-us;153159.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Felix" <felix666007_no_solicitation (AT) yahoo (DOT) com> wrote

Quote:

NOTE: We have no windows domain set up.

SETUP:
========
I have set up SQL server agent mail. Sql server and Sql Server Agent
each logon with the same local account: SqlServerAdmin. The
SqlServerAdmin account has Administrative priveleges. I have set up a
mail profile for the SqlServerAdmin acct.

There is a corresponding SqlServerAdmin account on our Exchange
server.

PROBLEM:
=========
I must login as SqlServerAdmin before agent emails can be sent.

I login as, say, Administrator, find an operator in enterprise
manager, hit the Test Email button, but no email is sent until I then
login as SqlServerAdmin and load Outlook. (I do keep Outlook running
while logged in as Administrator).

QUESTIONS:
==========
How do I solve this?
Must I set up a domain? Our one man IT dept is terrified of windows
domains.

Thanks for any help!

Felix

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: I must login as SqlServerAdmin before agent emails can be sent.

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Re: I must login as SqlServerAdmin before agent emails can be sent. - 08-05-2003 , 01:46 AM