sql mail questions

[jacob94]

I am running SQL server 2000 and have sqlmail configured to my outlook 2002 MAPI profile.

I am able to use xpsendmail fine; however, I always need to have my mail client open or it will not send the email until I open it. Is this how sql mail works or is their a way to make it send mail when the outlook client is closed...

My mail sever is remote, not on the server where I am running SQL mail.

Any help or explaination would be greatly appreciated!

 

[mrdenny]

Are you using POP3 or IMAP (Exchange)?

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

 

[jacob94]

POP3

 

[mrdenny]

Your are going to have this problem then. In order for outlook to be able to do the send and receive it has to be open as with POP3 there is no persistant connection to the mail server.

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

 

[mrdenny]

Take a look at xp_smtp_sendmail. It uses SMTP to send without using Outlook. Google for it, it should be the first or second result.

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

 

[jacob94]

mrdenny,
Thanks for the response. I installed XP_SMTP_SENDMAIL but the port I am using is not 25. I did set it to the correct port but I could not get an email to fire...

Any ideas? I think my mail server requires secure login.

 

[mrdenny]

Currently xp_smtp_sendmail doesn't support authentication.

Can you ping the mail server using the @ping paramater?

What error message are you getting?

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

 

[jacob94]

I just get the number 1 returned to the results in query analyzer.

 

[mrdenny]

It appears that 1 means that you can't connect to the specified mail server. Are you listing the mail server and port number as paramaters?

If you are on the SQL Servers console can you telnet to the mail server?

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

 

[jacob94]

Yes on the mail sever and parameters...

I do not know how to telnet to the mail server from SQL Server console...