emailed subscription not including port number in servername URL link for report

I hope someone can help as I have searched for a solution but been unable to find one as yet.

My problem is that after installing SharePoint V3.0 and amending the Report Server to <ServerName>:8080, as I don't yet wish to use integrated mode, everything works fine except email delivered subscriptions. The URL in the email body referencing the report only puts in <ServerName> etc. omitting the port number :8080. I have tried to find where this URL link is built-up from but have had no luck in the report manager, report services configuration and the config files, does anyone know where I need to look and if possible what I need to amend to have the link include :8080 after the servername portion of the URL. I can copy the URL and manually insert the port address and it works but this defeats the object of automated subscriptions.

Sorry if this is a dumb question but it is giving me a headache at the moment.

All answers gratefully received,

Andy

You should update the URLRoot element in the rsreportserver.config file to include :8080 in it. This should get the URL to work.

-Lukasz

|||

Thanks Lukasz,

I thought I had looked at all the appropriate config files but obviously I missed this one. I found the entry and added the :8080 to the path and it all works fine now.

Much appreciated,

Andy

emailed subscription not including port number in servername URL link for report

I hope someone can help as I have searched for a solution but been unable to find one as yet.

My problem is that after installing SharePoint V3.0 and amending the Report Server to <ServerName>:8080, as I don't yet wish to use integrated mode, everything works fine except email delivered subscriptions. The URL in the email body referencing the report only puts in <ServerName> etc. omitting the port number :8080. I have tried to find where this URL link is built-up from but have had no luck in the report manager, report services configuration and the config files, does anyone know where I need to look and if possible what I need to amend to have the link include :8080 after the servername portion of the URL. I can copy the URL and manually insert the port address and it works but this defeats the object of automated subscriptions.

Sorry if this is a dumb question but it is giving me a headache at the moment.

All answers gratefully received,

Andy

You should update the URLRoot element in the rsreportserver.config file to include :8080 in it. This should get the URL to work.

-Lukasz

|||

Thanks Lukasz,

I thought I had looked at all the appropriate config files but obviously I missed this one. I found the entry and added the :8080 to the path and it all works fine now.

Much appreciated,

Andy

emailed subscription not including port number in servername URL link for report

I hope someone can help as I have searched for a solution but been unable to find one as yet.

My problem is that after installing SharePoint V3.0 and amending the Report Server to <ServerName>:8080, as I don't yet wish to use integrated mode, everything works fine except email delivered subscriptions. The URL in the email body referencing the report only puts in <ServerName> etc. omitting the port number :8080. I have tried to find where this URL link is built-up from but have had no luck in the report manager, report services configuration and the config files, does anyone know where I need to look and if possible what I need to amend to have the link include :8080 after the servername portion of the URL. I can copy the URL and manually insert the port address and it works but this defeats the object of automated subscriptions.

Sorry if this is a dumb question but it is giving me a headache at the moment.

All answers gratefully received,

Andy

You should update the URLRoot element in the rsreportserver.config file to include :8080 in it. This should get the URL to work.

-Lukasz

|||

Thanks Lukasz,

I thought I had looked at all the appropriate config files but obviously I missed this one. I found the entry and added the :8080 to the path and it all works fine now.

Much appreciated,

Andy

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

Editions

Can someone tell me what is the difference between
RS Developer Edition
RS Standard Edition
RS Enterprise Edition
What should I be installing on the reporting service server that I don't
intend to do report development on?http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_72jq.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Frank" <nospam@.nospam.org> wrote in message
news:%23ecRMB4mEHA.3900@.TK2MSFTNGP10.phx.gbl...
> Can someone tell me what is the difference between
> RS Developer Edition
> RS Standard Edition
> RS Enterprise Edition
> What should I be installing on the reporting service server that I don't
> intend to do report development on?
>|||thank you.
"Brian Hartman [MSFT]" <brianhartman@.hotmail.com> wrote in message
news:%23624VK5mEHA.3756@.TK2MSFTNGP11.phx.gbl...
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsinstall/htm/gs_installingrs_v1_72jq.asp
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Frank" <nospam@.nospam.org> wrote in message
> news:%23ecRMB4mEHA.3900@.TK2MSFTNGP10.phx.gbl...
>> Can someone tell me what is the difference between
>> RS Developer Edition
>> RS Standard Edition
>> RS Enterprise Edition
>> What should I be installing on the reporting service server that I don't
>> intend to do report development on?
>>
>