SQL Server 2005 Database Mail

[seaport]

I have SQL server 20005 installed on a windows 2000 Pro PC. I was trying to setup the database mail function. I was asked to enter the SMTP server, which I do not know anything about.

I have IIS installed on the same computer. Is SMTP server part of IIS? If yes, is my PC (not a server) able to send out emails through SMTP?

Thanks in advance.

Seaport

 

[mrdenny]

Yes SMTP is part of IIS.

You may be able to send email out via your local SMTP server. That will all depend on if your network blocks port 25 or if your ISP blocks traffic on port 25. (Port 25 is the SMTP port.)

The SMTP server that you use should be the same one that you use for sending email via your mail program.

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

 

[Catadmin]

You might want to check with your Exchange people or, if you don't have a messenging team, the Server team to get the address/name of the SMTP server or to verify port issues.



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"