PRob. SQL MAIL en SQL7.0

Alberto
favor revisar lo siguiente:

SQLMail Error 17952 SQL server failed to starts
*** Problem Description ***
SQL mail fails to start due to MAPI failure

Both SQL server and the Email profile need to be installed \ created by a
member of the domain Admin group.

SQL server and SQL mail need to be configured to use the same account as the
Email profile is using.
<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><>
<>

*** Resolution *** 04/17/1998 02:11:22 PM dmcvie
SQL server was installed by someone other than a member of the admin\domain
admins groups.

This was fixed by running setup /t RegistryRebuild = On



The SQL server was not using the same NT domain account as the email
profile.
Change it to use the same account



The email profile "Webmaster" was created by someone other than a member of
the
admin\domain admins groups.

This was fixed by logging on as a domain adim, deleting the profile and
re-creating it.


Thanks,

Edirceu De Brito,
Microsoft Support Professional

This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure!. For more info visit http://www.microsoft.com/protect

Please reply to newsgroups only.





"Alberto ullate" wrote in message
news:298401c4a475$5e16d4e0$
Mostrar la cita

Saludos

Windows NT 4.0 SP4 SQL 7.0
Al iniciar desde el administrador corporativo de SQL el
servicio SQL MAil me da un error 17952

Es un problema de autenticacion y del profile de mail.
Verifca:
1) Ver con que cuenta esta esta ejecutandose el servicio del Agent
2) Logoneate con ese usuario en el servidor
3) Verifica que exista un profile de Outllok o Cliente de Exchange para ese
usuario
4) Verifica que puedas leer y recibir mails desde Outlook/Cliente Exchange
con ese profile
5) Si hasta aqui todo anduvo entonces, desde el Query Analizer fijate de
ejecutar el siguiente script
xp_sendmail '<direccion de correo email de la cuenta utilizada para iniciar
el servicio de SQLServer>', 'Prueba'
6) Si esto falla, puedes ejecutar este script para determinar la causa de la
falla:
set nocount on

print 'Starting SQL Mail test'
print ''
declare @suser varchar(256)
set @suser = SYSTEM_USER
print 'Logged into server as ' + @suser

Declare @regMapikey nvarchar(256)
Declare @DefMapiClient nvarchar(256)
set @regMapikey = N'SOFTWARE\Clients\Mail'

exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE', @regMapikey,
N'',
@DefMapiClient OUTPUT,
N'no_output'

print 'Default mail client is ' + @DefMapiClient

go


drop table #sqlmailtest

create table #sqlmailtest
(
[Profile Name] nvarchar(128) not null,
[Is default profile] int not null default -1
)

declare @p1 nvarchar(128)
declare @p2 nvarchar(128)
declare @profile varchar(128)
declare @regkey varchar(256)
declare @accnt varchar(128)

/*
exec @rc = master.dbo.xp_MSLocalSystem @p1, @p2
if (@rc = 0)
begin
raiserror('SQL Mail not supported running SQL Server under
LocalSystem', 19, 1) with log, nowait
print ''
print 'SQL Server is running under the LocalSystem account'
print 'SQL Mail is not able to be used under this account'
print 'please change to a domain or machine account with a'
print 'MAPI profile attached.'
return
end
*/
select @regkey = N'SYSTEM\CurrentControlSet\Services\MSSQLServer'
else
select @regkey = N'SYSTEM\CurrentControlSet\Services\MSSQL$' + @p2

exec master.dbo.xp_regread N'HKEY_LOCAL_MACHINE',
@regkey,
N'ObjectName',
@accnt OUTPUT,
N'no_output'

print 'SQL Server is running under account ' + @accnt


if (@rc <> 0)
print 'Warning: No default MAPI profile present (test 1)'
truncate table #sqlmailtest

if (@rc <> 0)
print 'Error: enumerating MAPI profiles'

begin
raiserror('Error: No MAPI profile(s) present', 19, 1) with log, nowait
return
end

select @defprof = count(*) from #sqlmailtest where [Is default profile] = 1
if (@defprof = 0)
print 'Warning: No default MAPI profile present (test 2)'


declare mapicursor cursor read_only for select [Profile Name] as profile
from #sqlmailtest
open mapicursor

fetch next from mapicursor into @profile
while (@@fetch_status <> -1)
begin
if (@@fetch_status <> -2)
begin
print ''
print 'Testing MAPI profile : ' + @profile
print ''

exec @rc = master.dbo.xp_test_mapi_profile @profile
if @rc = 0
print ' Testing MAPI profile : ' + @profile + ' succeeded'
else
print '*** Testing MAPI profile : ' + @profile + ' failed ***'

exec @rc = master.dbo.xp_startmail @profile

if @rc = 0
print ' Start mail using MAPI profile : ' + @profile + '
succeeded'
else
print '*** Start mail using MAPI profile : ' + @profile + '
failed ***'

exec @rc = master.dbo.xp_stopmail
if @rc = 0
print ' Stop mail using MAPI profile : ' + @profile + '
succeeded'
else
print '*** Stop mail using MAPI profile : ' + @profile + '
failed ***'

end
fetch next from mapicursor into @profile
end

close mapicursor
deallocate mapicursor

if exists (select * from tempdb.dbo.sysobjects where id object_id(N'tempdb..#sqlmailtest'))
drop table #sqlmailtest

print ''
print 'Finished SQL Mail test'

Este script fue posteado por Charles Allard de Microsoft SQL Support

Para mas informacion:
Q153159 INF: Troubleshooting SQLMail with Microsoft Exchange Server
http://support.microsoft.com/defaul...US;Q153159

Q263556 INF: How to Configure SQL Mail
http://support.microsoft.com/defaul...US;Q263556


Saludos
Adrian D. Garcia
MCSD
NDSoft Consultoria y Desarrollo

"Alberto ullate" wrote in message
news:298401c4a475$5e16d4e0$
Mostrar la cita

Saludos

Windows NT 4.0 SP4 SQL 7.0
Al iniciar desde el administrador corporativo de SQL el
servicio SQL MAil me da un error 17952

Asegurate que los servicios MSSQLServer y SQLServerAgent
usen la misma cuenta de dominio y que dicha cuenta
pertenezca al grupo Administrators.

Chequea este link:
http://support.microsoft.com/defaul...cid=kb;EN-
US;263556

Reinicia para que los cambios se hagan efectivos.

Logeate con el usuario que configuraste el SQL Mail.

Completa el Outlook profile por cada usuario.

EXITOS

Mostrar la cita

Saludos

Windows NT 4.0 SP4 SQL 7.0
Al iniciar desde el administrador corporativo de SQL el
servicio SQL MAil me da un error 17952
.