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 |
|
ddamico
Yak Posting Veteran
76 Posts |
 Posted - 2009-07-21 : 15:09:35
|
| Good afternoon. I have been working on configuration of Database mail. The scenario. I have a 64-bit OS Windows 2003 R2.1 Instance of SQL 64-bit SP21 Instance of SQL 32-bit SP2Both instance are configured to use our remote SMTP server.It was necessary to install the 32-bit version in order to run odbc drivers for Progress is the long and short of why 32-bit was added. Anyhow, upon configuration of the 32-bit database mail the mail is unsent but there are not error messages anywhere. Upon configuring the 64-bit instance for SQL Mail the test email sends and is received without issue.Both instance are named instance on the machine. The only explanation I could come up with is that it has something to do with being a 32-bit version running on 64-bit OS. I haven't been able to find anything online and thought someone may have had the same issue and knows how to resolve it. Thanks in advance for any help. |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-07-24 : 06:40:24
|
quote:
Originally posted by ddamico
Good afternoon. I have been working on configuration of Database mail. The scenario. I have a 64-bit OS Windows 2003 R2.1 Instance of SQL 64-bit SP21 Instance of SQL 32-bit SP2Both instance are configured to use our remote SMTP server.It was necessary to install the 32-bit version in order to run odbc drivers for Progress is the long and short of why 32-bit was added. Anyhow, upon configuration of the 32-bit database mail the mail is unsent but there are not error messages anywhere. Upon configuring the 64-bit instance for SQL Mail the test email sends and is received without issue.Both instance are named instance on the machine. The only explanation I could come up with is that it has something to do with being a 32-bit version running on 64-bit OS. I haven't been able to find anything online and thought someone may have had the same issue and knows how to resolve it. Thanks in advance for any help.
did u chk mailroot folders-- badmail; might be the mail is in the badmail folder.. |
 |
|
|
|
|
|
Database Mail Help