April 3, 2008 at 8:32 am
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?
April 3, 2008 at 12:22 pm
I didn't know that xp_smtp_sendmail was a thrid party add-on.
I've always used a fat outlook client.. oh well.. live and learn.
I had to copy a DLL and run a couple of commands to install XPSMTP for SQL Server
here's the link
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply