Hi,
I have a windows 2003 server, which have those installed
applications : sql server 2000 SP4, backup exec 10, office 2003.

I have installed it from scratch 3 week ago. I got a problem, in a DTS,
when I drag'n drop the "send mail task" object, I got the following
error : "Cannot load MAPI interface layer for DTS. Please make sure
that semmap.dll is installed". I have tried to copy the file from SQL
SP4 and register it again, doesn't correct the problem. So I reinstall
SQL and it correct the problem.

After that, I got a problem with Backup Exec 10. I reinstall Backup
Exec 10, exactly the same problem "Cannot load MAPI interface layer for
DTS. Please make sure that semmap.dll is installed" came back.

Any idea?

Daniel:

Seems like we are in the same boat. We just had to rebuild our server and
it is a totally fresh install. Windows 2003 Server, SQL Server 2000 SP4 and
Backup Exec 9.1 all were installed and today I get an error on a job that
has been flawless for months. Shows that error in my package logs for both
my Send Mail tasks--which the Agent notified me correctly VIA EMAIL.
Opening up the package on the server and double clicking the tasks gives the
same error. They open fine with EM on my machine. SEMMAP.DLL does not have
a DLLRegisterServer entry point either. There are three of them on the box:

C:\Program Files\Microsoft SQL Server\MSSQL\Binn\semmap.dll version
2000.80.2039.0
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\semmap.dll version
2000.80.2039.0
C:\Program Files\Microsoft SQL Server\MSSQL$BKUPEXEC\Binn\semmap.dll version
version 2000.80.760.0

Maybe upgrading the Backup Exec DB will work......

Have you made any progress? Keep me posted and I'll keep you posted.
Thanks for the info about Backup Exec being the possible problem.

Scott

"Daniel Blais" <daniel (AT) danielblais (DOT) net> wrote

Just a quick question: In what order did you install the following:

1. SQL Server 2000
2. SQL Server 2000 SP4
3. Backup Exec

Reason I ask is that our previous server had both on it (SQL and Backup
Exec) and we never had this problem. Only difference was the install order.
The order was 1, 3, 2 not 1, 2, 3. More on the point it was 1, SP3a, 3, 2.
I'm thinking that Backup Exec's install is messing up SQL Server 2000
because of the MSDE it uses. Are you using the MSDE or letting Backup Exec
use your SQL Server 2000 instance?

Scott

"Daniel Blais" <daniel (AT) danielblais (DOT) net> wrote

Wm. Scott Miller wrote:
For the first install, I don't know, it was installed by another
technician. What I know, 2 sql server's task was not working. I
completely reinstall SQL, those 2 task was working. Another technician
remark backup exec was not workink correctly, he reinstall it. After
the reinstallation of backup exec, initial bug of SQL server 2000 came
back. If bug with backup exec came back, we will install it on another
server.

Sorry I don't have all information, we where 3 technician who work on
the reinstallation of this server.

Daniel

Daniel:

I have a solution to our problem. Create the following folder structure on
your server:

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

Yea, there is no "ls" in it. Now COPY (DO NOT MOVE!!!!) SEMMAP.DLL from
Tools\Binn to Too\Binn and copy SEMMAP.RLL from Tools\Binn\Resources\1033 to
Too\Binn\Resources\1033. Send Mail will begin working and you can now edit
it.

Unfortunately, I have not been able to isolate where it is getting the
"Too". I've searched my registry several times with no luck so far. If you
find it, let me know.

Scott

"Daniel Blais" <daniel (AT) danielblais (DOT) net> wrote

FOUND IT!

HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup
Key: SQLPath
Value: C:\Program Files\Microsoft SQL Server\80\Tools

Scott

"Wm. Scott Miller" <Scott.Miller (AT) spamkillerwvinsurance (DOT) gov> wrote