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 |
|
thomadma
Starting Member
8 Posts |
 Posted - 2003-08-27 : 10:08:08
|
| Hi,Our environment contains clustered server - A/A for both production and development. A few months ago we began our server migration to win2k and sql server followed. When we migrated to exchange 2000, our sql mail no longer worked. We could not determine what had gone wrong - whether it was a domain related issue, clustering and sql mail which indicates an issue, or something else. Because we don't have a large sql server environment to monitor (10 servers), we decided we would simply monitor manually and check to see that jobs are running that way. Problem is, sometimes, enterprise manager is not the most dependable tool to use for visual verification - jobs are misreported and the icons are blue when in fact, they are still running or have failed. Do you know of any situations similar to ours and what did they do to resolve this? Are there any other clients, smtp for example that we can use that would do the job also? Or has microsoft fixed the problem with sql mail and clustered servers? Any help would be greatly appreciated.Maria |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-27 : 12:34:28
|
| SQL Mail is not fully supported by MS in a clustered environment:[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;298723[/url]We got it to work on all of our instances, but it doesn't always work. We have resorted to using SQL Mail from a server that is not part of the clustered environment. We are not using an Exchange server in the clustered environment though, and MS says that this will solve our problems, so maybe you will have success if you follow the information in the article and use an Exchange server. We are just waiting til ours arrives. The key part is that the profile for the account that SQL Mail is going to use has to be setup on each of the nodes IDENTICALLY.Tara |
 |
|
|
thomadma
Starting Member
8 Posts |
Posted - 2003-08-27 : 13:15:09
|
| Thanks for the reply Tara. I am looking for a solution that works all of the time - we can't have it be intermittent. We're looking at smtp as a viable solution. Maria |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-27 : 13:18:18
|
| Well, that's the point though. Our solution doesn't work all of the time because we aren't using Exchange. MS says Exchange would solve our intermittent problems. The only thing that needs to be done carefully is the identical profiles on each of the nodes.Tara |
|
|
|
|
|
|
|
|
SQL Mail