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 |
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
 Posted - 2008-04-03 : 10:51:06
|
| Yesterday we had a hardware failure (Disk Controller) on our SQL Server 2000 ENT edition (sp4) with replication. I was able to take a set of Full backups and script my publication beofre they took the server down. they rebuilt the Server on different hardware with the same IP address and Server name. I then reinstalled my Named Instance and recovered system databases, distribution database and then my user Database with replication. everything seemed fine. last night, a couple of jobs that use sp_smtp_sendmail failed with this error: DTSStep_DTSExecuteSQLTask_2, Error = -2147217900 (80040E14) Error string: Cannot load the DLL xpsmtp80.dll, or one of the DLLs i... Process Exit Code 2. The step failed.I googled it and I found that it may have something to do with DLLs not registered properly. Does anyone know how to fix this? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-03 : 11:10:46
|
| Does new server have SMTP installed? |
 |
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-04-03 : 12:40:37
|
| is that some kind of add-on that I should have checked off during install? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-03 : 13:00:29
|
| Check your hardware guys if they have installed SMTP or not? |
|
|
|
jpotucek
Constraint Violating Yak Guru
273 Posts |
Posted - 2008-04-03 : 14:20:08
|
| I had to install xpsmtp for SQL Server and copy a DLL http://www.sqldev.net/xp/xpsmtp.htmI don't think the Server guys could have helped me.. it's a sql server add-on.. thanks for your help,. |
|
|
|
|
|
|
sp_smtp_sendmail failing after recovery