sql don't see the mail profile

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

sql don't see the mail profile

Author

Topic

bassem_farouk
Starting Member

18 Posts

Posted - 2010-10-14 : 02:25:15

Hi
this code suddenly stoppped working

exec master..xp_sendmail
@recipients = 'bassem_hamdi@toll.com.au',
@subject = 'test',
@message = 'test'

Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x8004060c

i am on Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

i logged on with the user that SQL serverice and AGENT is running under , when i double click on the mail icon , i can't see any profile, but on the Support servicer -> Sql Mail -> i can see a profile , which i can test successfully!! , i created a new profile , sql server can't see it in the Server Setting -> sql mail

1)do i need to restart sql to see the new profile?
2)where is the old profile gone?
3)how come the old profile is not visible , but sql server can test it successfully?
4) how to get sql mail working again?

Please help?

Thanks very much

Thanks

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-10-14 : 12:29:04

tried explicitly starting mail session (xp_startmail)? you're living in a dangerous world on SQL 2000 RTM...

EDIT: To clarify, you should apply Service Pack 4

http://www.microsoft.com/downloads/en/details.aspx?familyid=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&displaylang=en

bassem_farouk
Starting Member

18 Posts

Posted - 2010-10-14 : 18:53:08

Hi
both 2 commands are executing successfully but still the problem exist

exec master.dbo.xp_stopmail
exec master.dbo.xp_startmail

i will go to 2008 soon , but for now i need to fix this production problem

Thanks

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2010-10-15 : 04:17:39

You will need to reinstall the outlook client. This was an issue with SQL 2000 and I have seen it before. For some reason the outlook client gets its knickers in a twist and creating any mail profile doesn't seem to make any difference. A restart sometimes fixes it, but not always.

BTW, which version of Outlook are you using? If it is anything above 2002, you will have issues.

bassem_farouk
Starting Member

18 Posts

Posted - 2010-10-16 : 21:00:19

Thanks buddy
restart the machine did not fix it
i am using outlook 2003
will install 2002 and let you know
thanks

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources