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-Startup Account Problem

Author  Topic 

Jim77
Constraint Violating Yak Guru

440 Posts

Posted - 2006-03-27 : 04:34:17
Hello Everyone.
I have searched this forum far and wide and can't find a resolution to a wee problem I am having, and as always I would like to pose this problem to the board please.

I am running three servers remotley in enterprise manager, one I have set up succesfully with sql mail and have scheduled successful email notifications and resultset emails using xp_sendmail.

Now I need to set-up the second server exactley like the first one so I can send the same notifications and emails etc..etc...

So I changed the properties of sqlserver service and sql agent service to use the same startup accounts and mail profile as the first server but when I test the mail profile in either service I get the following message :

ERROR 18025:xp_test_mapi_profile: failed with mail eror 0x80004005

Any iseas why this is happening please guys ?

Jim77
Constraint Violating Yak Guru

440 Posts

Posted - 2006-03-27 : 07:53:35
Perhaps you should install outlook on the mail client server...Dummy!
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-03-28 : 07:34:23
ha ha ha...

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -