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

[612 byte] By [Amir5656] at [2007-12-18]

«« Erro running FxCop 1.32
»» How to program a log in form?

# 1

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

DanaDBA at 2007-10-7 >

top of Msdn Tech,SQL Server,SQL Server Setup & Upgrade...

# 2

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

cesko45 at 2007-10-7 >

# 3

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

DanJonesMSFT at 2007-10-7 >

# 4

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

Thanks again.

Amir

Amir5656 at 2007-10-7 >

# 5

Dan,

which on of the downloads has the MAPI DLL needed?

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

Reinaldo

Rei at 2007-10-7 >

# 6

The one you want is labeled backwards compatibility.

MichelleAlexander-MS at 2007-10-7 >

# 7

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.

Kosmosniks at 2007-10-7 >

# 8

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 recommendrunning the script first. Then if that doesn't work, try fooling around with the file names -- not the other way around.

webbsk at 2007-10-7 >

# 9

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

SIVAPRASADS-SIVA at 2007-10-7 >

SQL Server

SQL Server Setup & Upgrade