Re: SQL 2005 Database Mail Setup
- From: "tcuscino" <tcuscino@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 13 Jun 2005 10:16:03 -0700
Thanks for the response, Steen. I think that was true in 2000 because of the
MAPI profile. Since Database mail (formerly SQLiMail) does not use the MAPI
profile, that is not necessary. The reason I can state that so certainly is
that I finally did get it working while running all services under the
localsystem account. There is definitely a problem with the interface, but
if one clicks the scripting icon now available almost everywhere, the actual
stored procs called by the interface are shown. I hacked the parameters
passed to the stored procs, and I also monkeyed in the registry which is
where those procs go to finally get it to work.
Bottom line -- SQL 2005 June CTP is still buggy (in my case in the SQLAgent
Alert system mail setup interface), but I guess that is to be expected at
this point in time because that is, in part, what the CTP process is all
about.
"Steen Persson" wrote:
> Hi
>
> You'll need to have at least SQLSErverAgent service running under the same
> domain acount as the one you're using for the Mail profile. At leasat it was
> so with SQL2000, but I'm not sure if it's different with SQL2005.
>
> Regards
> Steen
>
> tcuscino wrote:
> > I installed the June CTP for SQL 2005 Enterprise 32bit with no
> > problems. I set up a database mail profile and was able to use the
> > profile and execute an sp_send_dbmail with no issues. However, when
> > I try to set up SQLAgent database mail, it fails. When I check the
> > "Enable mail profile" box in SQLAgent|Alert System, the mail system
> > and mail profile dropdowns remain disabled. A hint is in the
> > SQLAgent log which on service startup logged the following 2 errors:
> >
> > Error 1
> >
> > Date 6/11/2005 3:37:39 PM
> > Log SQL Agent (Current - 6/11/2005 3:37:00 PM)
> >
> > Message
> > [260] Unable to start mail session (reason:
> > Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException:
> > Mail configuration information could not be read from the database.
> > ---> System.Data.SqlClient.SqlException: profile name is not valid
> > at System.Data.SqlClient.SqlConnection.OnError(SqlException
> > exception, Boolean breakConnection)
> > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> > exception, Boolean breakConnection)
> > at
> > System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> > stateObj)
> > a)
> >
> >
> > Error 2
> >
> > Date 6/11/2005 3:37:39 PM
> > Log SQL Agent (Current - 6/11/2005 3:37:00 PM)
> >
> > Message
> > [355] The mail system failed to initialize; check configuration
> > settings
> >
> >
> > We already know the profile is valid because I used it from the query
> > window to execute sp_send_dbmail, so the message "profile name is not
> > valid" seems to be faulty. The SQLAgent and SQLServer services are
> > running under LocalSystem.
> >
> > Any ideas?
> >
> > Thanks,
> >
> > Tom Cuscino
>
>
>
.
- References:
- SQL 2005 Database Mail Setup
- From: tcuscino
- Re: SQL 2005 Database Mail Setup
- From: Steen Persson
- SQL 2005 Database Mail Setup
- Prev by Date: Re: IA64 Enterprise Edition of SQL2005 available in the June CTP?
- Next by Date: SQL 2000 Install hangs
- Previous by thread: Re: SQL 2005 Database Mail Setup
- Next by thread: SQL optimal configuration
- Index(es):
Relevant Pages
|
