Showing posts with label professional. Show all posts
Showing posts with label professional. Show all posts

Thursday, March 22, 2012

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.comGo 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|||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|||

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

|||

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

Thanks again.

Amir

|||

Dan,

which on of the downloads has the MAPI DLL needed?

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

Reinaldo

|||

The one you want is labeled backwards compatibility.

|||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.|||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.|||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

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.comGo 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|||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|||

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

|||

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

Thanks again.

Amir

|||

Dan,

which on of the downloads has the MAPI DLL needed?

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

Reinaldo

|||

The one you want is labeled backwards compatibility.

|||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.|||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.|||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 mesql

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.comGo 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|||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|||

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

|||

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

Thanks again.

Amir

|||

Dan,

which on of the downloads has the MAPI DLL needed?

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

Reinaldo

|||

The one you want is labeled backwards compatibility.

|||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.|||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.
|||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

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.comGo 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|||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|||

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

|||

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

Thanks again.

Amir

|||

Dan,

which on of the downloads has the MAPI DLL needed?

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

Reinaldo

|||

The one you want is labeled backwards compatibility.

|||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.|||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.
|||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

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.comGo 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|||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|||

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

|||

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

Thanks again.

Amir

|||

Dan,

which on of the downloads has the MAPI DLL needed?

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

Reinaldo

|||

The one you want is labeled backwards compatibility.

|||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.|||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.
|||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

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.comGo 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|||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|||

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

|||

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

Thanks again.

Amir

|||

Dan,

which on of the downloads has the MAPI DLL needed?

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

Reinaldo

|||

The one you want is labeled backwards compatibility.

|||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.|||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.
|||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

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.comGo 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|||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|||

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

|||

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

Thanks again.

Amir

|||

Dan,

which on of the downloads has the MAPI DLL needed?

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

Reinaldo

|||

The one you want is labeled backwards compatibility.

|||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.|||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.|||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 mesql

Wednesday, March 7, 2012

EM registration info not sticking

My Window XP professional PC has SQL 2000 Client tools
installed.
SQL Client tools : SQL 2000 SP3
SQL Servers : SQL 2000 SP3
I also registered a few SQL servers in the Enterprise
Manager. Whenever I logged off and logged back on again,
I lost all the servers registration.
I noticed that when I exited Enterprise Manager, it
modified the file "C:\Program Files\Microsoft SQL Server\80
\Tools\BINN\SQL Server Enterprise Manager.MSC"
Is there any other files to be modified to keep the
registered settings e.g registry etc ?
Any ideas to save the settings when I log back on again ?
Thanks.I don't think I am the administrator of my machine. All
the machines here have to be applied "Local security
policy".
And I needed to know what registry settings and files
needed to keep the SQL server registration settings of
Enterprise Manager. Thus I can tell the network
administrator of what kind of permissions I needed.