Unanswered: Second instance of SQL Server can't configure the SQL Mail profile.
We installed a 2nd instance of SQL Server 2000. The first instance had a profile on Outlook and was sending mail from the SQL Agent just fine. When trying to set up the 2nd instance's profile on Outlook and setting up SQL Mail to connect to it, big problem!
Has anyone had experience with 2 instances, using 2 different profiles (2 different accounts) on a server using Outlook 2000 Microsoft Exchange Server? We can't get them to work.