Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2004-10-14 : 06:35:03
|
| Hi ,I am actually new to setup and configure SQLMAIL but managed to setup somehow by following MS documents on setting up SQL mail on one of our dev. SQL 2000 server . But I got stuck when I followed the same steps to configure it on Production SQL 2000 server .During the setup I get error message sometimes as Microsoft Exchange server might not be available while sometimes it does resolve the names of the mailbox. When it resolves , and when I open my outlook I just see the Outlook License information. I am just wondering if firewall could be an issue in this case as the exchange server and the SQL box are two different segments separated by a FW . But again I compared ny dev SQL server which also separated by FW where I have no issues . I am confused as what could be the probable cause of this issue . Does SQLMAIL communicate on any specific TCP/IP port that needs to be opened on the FW . I read couple of MS articles that says that it just uses Windows messaging service to send and receive mails . Both my dev and prod. SQL servers are SQL 2000 Enterprise Edition SP3a. Any assistance on this would be of great help .Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-14 : 06:55:50
|
| Grrrrr ... as I am known for having in other threads: I **HATE** the fact that Outlook is a required component to get enough MAPI so that SQLMail is then a runner.I'm afraid I don't know the answer, but FWIW we don't put SQLMail on our Production servers because Outlook seems to be a pre-requisite - which is a pity 'coz I'd like to be able to tick the "Email me on failure" box when setting up Scheduled Tasks etc.Kristen |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-10-14 : 17:48:31
|
| Check out this post: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=36293It wount let you click the "Email me on failure" but it works just the same, just add another jobstep that runs only on failure instead...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-15 : 01:22:34
|
| Ah hah, a job step on failure, what a cool idea. I can even create a web page at that point ...Kristen |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-10-15 : 04:18:00
|
Um...was that ironic...or not?  Did I miss something here?--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-16 : 03:16:04
|
| No, not intended to be irony, sorry if I caused any offence.I had just never thought to have a job-step on failure to provide an alternative to "email me". And actually I would prefer a web page that shows the status ...Kristen |
|
|
|
|
|
|
SQL MAIL problem.