Email tasks fail after an unsuccessful SQL 2005 installation

I tried installing SQL 2005 Dev Edition on my Win 2000 Professional machine. That failed. But now I cannot send out emails or even open a simple Email task from DTS. This is something that worked perfectly fine before I attempted the SQL 2005 installation. It seems that the SQL 2005 installation somehow messed up the the MAPI profile. The exact error message that I get when trying to execute or open a Email task in DTS is: CAnnot load MAPI Interface layer for DTS. Please make sure that semmap90.dll is installed.

Can someone tell me how to fix this issue.
Thanks,
Amir
acharania@trimontrea.com

Answer this question

Email tasks fail after an unsuccessful SQL 2005 installation

Gerald.Wright
Go to the 2000 install of SQL Server (Microsoft SQL Server\80\Tools\Binn) make a copy semmap.dll and name it semmap90.dll, then go to Binn\resources\1033 and make a copy of semmap.rll and name that copy semmap90.rll
scotland
After renaming of the file semmap.rll to semmap90.rll on

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033

and semmap.dll to semmap90.dll

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\

it worked fine for me
tommy khan
Thanks so much, Dan. That is the method that worked for me. When I tried just renaming the files, I couldn't even open Enterprise Manager without multiple error messages. I even had to kill the process.

If someone else has this problem, I would recommend running the script first. Then if that doesn't work, try fooling around with the file names -- not the other way around.
Alexan
Thank you for this information, I renamed semmap.dll to semmap90.dll ("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\")and also the semmap.rll to semmap90.rll ("C:\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033\") worked like a charm.
Dinesh Bhat
Go to the 80 directory that's installed with SQL Server 2000 -
(\Microsoft SQL Server\80\Tools\Binn)

Rename the semmap.dll file to semmap90.dll
fantacmet

The other option is to download and install the "Microsoft SQL Server 2005 Backward Compatibility Components" from http://www.microsoft.com/downloads/details.aspx FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en. This will install the latest version of the overlapping DLLs.

Cheers,
Dan
Kgomong
Dan,

which on of the downloads has the MAPI DLL needed

I applied the DTS download and that did not resolve the issue.

Reinaldo
John Schleicher

The one you want is labeled backwards compatibility.
Chrislm

Thanks a lot. I renamed semmap.dll to semmap90.dll and that solved the issue.

Thanks again.

Amir
Email tasks fail after an unsuccessful SQL 2005 installation

Answer this question