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 MAIL

Author  Topic 

debug
Starting Member

29 Posts

Posted - 2003-09-27 : 13:06:20
Hi Folks,

The problem is that our SQL mail has stopped functioning because the mail platform has changed from Exchange 5.5 to E2K and the domain of the E2K server is different and is not trusted by us and vice versa, moreover the user name of the our Id has also been changed in the new platform i.e. its not the same as we had configured for SQL mail.

Now, in this scenario the SQL agent service is not able to interact with the new Exchange 2000 server in with a different domain.

So, just wanted to know the alternative solution to this.

regards,

DU

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2003-09-27 : 14:02:48
Do you mean alternatives to using SQLMail (xp_sendmail)? We have a few good articles here on the site. Check out these search results especially Merkin's article on Building a Mail Queue System

------------------------------------------------------
The more you know, the more you know you don't know.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-09-28 : 00:10:07
I'm not sure that you can setup SQL Mail to use an account in a domain where the Exchange server doesn't exist, but even if you can, without the trust it isn't going to work. Why don't you work with the server admins to get a trust setup or to move the SQL Server into the same domain as the Exchange server?

Tara
Go to Top of Page
   

- Advertisement -