If I took Basic authentication and gave gmail account as user name & Gmail account password in the password then it is working fine but if I use windows authentication it is not working. so that means the remaining two options doesn't work.
Instead of gmail account if you took yahoo account shall we use the same port number?
Thanks[/quotemail settings depend on your server.
for windows authentication the mail server would be inside your lan -an exchange server.forexample.
to allow anonymous authentication typically thenmail server adds your sql servers IP to its white list and passes any mailnat all coming from that macchine.
Most smtp servers (all?!) SUPPORT basic authentication so thats thenmost common.
Not sure on the mail settings for yahoo mail youd have to goofle it.
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!