setting up SQL Mail not on domain: I read the faqs and searched forums

[Alcar]

hello

this should usually be pretty basic stuff but for the last year I ahve been dealing with a problem (more of a thorn in my side) that doesn't seem to have a solution.

I have read this faq faq962-4452 and read this post

http://www.tek-tips.com/viewthread.cfm?qid=831991

about it but I still can't get it to work. Here is my scenario:

win2k sp4 on network but not part of domain
sql2k sp3 services started with local account and admin permissions
outlook2k configured with MAPI to log on to exchange2003(part of the domain)
SQL Agent logs on to SQL Server via sa


results:
outlook succesfully sends and receives emails to/from domain accounts
SQL Server and SQL Agent start with no errors and jobs are completed.
SQL Mail finds MAPI session
Send Test Mail fails saying it could not connect with exchange server.

Our exchange server is set up that everytime you start outlook (or a MAPI session) it will ask user input for username, password and domain.

rebooted endless times, not sure of the BIOS upgrade but I am sure the network team would have applied a new bios if one came out in this past year... will ask them for details.

any more ideas?

Thanks in advance =)



Daren J. Lahey
Programmer Analyst
FAQ183-874 contains Suggestions for Getting Quick and Appropriate Answers to your questions.

 

[Catadmin]

SQL Services needs a domain account. You're probably going to have to stick your server into the domain to get any of this to work.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

Agreed.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com