# Error on deploying app with SSRS

**URL:** <https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561>\
**Category:** Epicor ERP 10\
**Tags:** ssrs\
**Created:** [July 8, 2019, 2:18pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561 "2019-07-08T14:18:07Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [July 8, 2019, 2:18pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/1 "2019-07-08T14:18:07Z")

</div>

New Install of 10.2.300…

Trying to enable SSRS on an App that successfully deployed w/o SSRS Configured. But I get the following:

“SSRS - The SSRS URL is not valid.”

![image](https://www.epiusers.help/uploads/default/original/3X/9/d/9d4466f7f850886fdea015a4b97bc92fe1ef44db.png)

Which URL is that referring to?  
The “SSRS Web Service URL”, or the “SSRS ReportServer Location”

The SQL server is on a different box than the App server.  
But if I enter the SSRS Web Service URL into IE on the App server, I get an HTTP error 500  
 ![image](https://www.epiusers.help/uploads/default/original/3X/c/b/cbf6a70354d45dd87d91cae8a776cf3ec696897f.png)

Yet from the App server, I can use IE to see [http://xxxx00375/Reports](http://xxxx00375/Reports) (which redirects to “[http://xxxx00375/Reports/browse/](http://xxxx00375/Reports/browse/)”

![image](https://www.epiusers.help/uploads/default/original/3X/9/b/9b7c7fb71a46feca2e760c2727f2eea2f63d7d37.png)

Can someone point in the right direction?

---

<div class="post-metadata">

**Author:** ![josecgomez](https://www.epiusers.help/user_avatar/www.epiusers.help/josecgomez/32/55731_2.png) [@josecgomez](https://www.epiusers.help/u/josecgomez)\
**Post date:** [July 8, 2019, 2:23pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/2 "2019-07-08T14:23:02Z")

</div>

Firewall issue? I’m guessing you meant to say you can access it from SQL Server but not app server

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [July 8, 2019, 2:47pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/3 "2019-07-08T14:47:14Z")

</div>

Both the images above are from the App server.

I get the HTTP Error 500 when trying to get to [http://xxxx00375/ReportServer](http://xxxx00375/ReportServer) while on the SQL server (\xxxx00375), too.

---

<div class="post-metadata">

**Author:** ![josecgomez](https://www.epiusers.help/user_avatar/www.epiusers.help/josecgomez/32/55731_2.png) [@josecgomez](https://www.epiusers.help/u/josecgomez)\
**Post date:** [July 8, 2019, 2:48pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/4 "2019-07-08T14:48:25Z")

</div>

Go to the SQL Server box open Report Configuration Manager  
and see what the Services URL is in that?

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [July 8, 2019, 2:57pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/5 "2019-07-08T14:57:47Z")

</div>

That’s where I got the URL from

 ![image](https://epiusers.help/uploads/default/original/3X/9/d/9d84fe0cca2d83e5374a18bde9b58a4776775c35.png)

And is it okay to use the network path containing a “C$” to reference the C drive of a remote computer? Or should I create a share on that computer? (highlighted below)

 ![image](https://epiusers.help/uploads/default/original/3X/1/c/1c59b38b0ff15d5929e48b4044f9993c641851b2.png)

---

<div class="post-metadata">

**Author:** ![victorcarabez](https://www.epiusers.help/user_avatar/www.epiusers.help/victorcarabez/32/17626_2.png) [@victorcarabez](https://www.epiusers.help/u/victorcarabez)\
**Post date:** [July 8, 2019, 4:07pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/6 "2019-07-08T16:07:41Z")

</div>

Did you open file sharing ports on windows firewall (MSSQL Server)?

- UDP 138, File and Printer Sharing (NB-Datagram-In)
- UDP 137, File and Printer Sharing (NB-Name-In)
- TCP 139, File and Printer Sharing (NB-Session-In)
- TCP 445, File and Printer Sharing (SMB-In)

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [July 8, 2019, 4:21pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/7 "2019-07-08T16:21:49Z")

</div>

They are all open

---

<div class="post-metadata">

**Author:** ![Chris\_West](https://www.epiusers.help/user_avatar/www.epiusers.help/chris_west/32/20334_2.png) [@Chris\_West](https://www.epiusers.help/u/Chris_West)\
**Post date:** [February 9, 2020, 8:33pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/8 "2020-02-09T20:33:35Z")

</div>

Was there ever a solution to this? We are getting this exact same error for some reason and I have confirmed all the same checks to make sure the URL matches what we have on SQL Server. I can put the url in on our APP Server, SQL Server and my desktop and all seem to work and bring up Live/Pilot/Test report folder dir. This was working until recently when we started to try and start working with SSRS reports vs. Crystal which most are custom reports use currently. I was able to deploy the newer version if I unchecked SSRS but obviously we need to use SSRS reports with E10.

Hopefully this was already figured out but just not posted.

Thank you,

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [February 9, 2020, 11:45pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/9 "2020-02-09T23:45:52Z")

</div>

It turned out to be something rather stupid, which compounded upon deployment…

I had the path to SSRS (the field near the bottom of the SSRS tab in EAC) using ‘/’ , instead of ‘’.  
`//servername/c$/....` was bad. Not only would the deployment fail, it would mess up the webconfig file.

`\\servername\c$\....` worked. (After fixing the webconfig file too)

Post #5 shows it the right way. It still wasnt working after i changed it, UNTIL I fixed the webconfig file.

---

<div class="post-metadata">

**Author:** ![Chris\_West](https://www.epiusers.help/user_avatar/www.epiusers.help/chris_west/32/20334_2.png) [@Chris\_West](https://www.epiusers.help/u/Chris_West)\
**Post date:** [February 22, 2020, 7:25pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/10 "2020-02-22T19:25:18Z")

</div>

Thanks for the update, For us it actually turned out to be an issue with corrupt encryption keys for the SSRS reports DB. Epicor support wanted us to just restore our whole LIVE DB back to a date when it was working (3-4 days ago). It turns out we got a girl in support that was so far out of her comfort zone that she even started the call with a backup person on IM to assist. So long story short it took us about 45 min. to just re-install the SSRS report DB after deleting the old one ( **saved all our custom reports first** ) then we were back up and able to again deploy Report Services again. So what I think anyone that has used Epicor for more then 10 years knows already is make sure you get a second opinion if you end up with a inexperienced support agent especially when they give you the “ultimate fix” to restore everything back to a time when it did work. I am very sure if I had of told our accounting department what Epicor support had told us to do they all would have quit since it was month-end when this happened. On another note: thankfully we still use Crystal Reports and I was able to keep things going (quotes, invoices, shop travellers, etc.) by using the Crystal Report versions I still keep and some we still use instead of SSRS report due to complexities with the reports.

---

<div class="post-metadata">

**Author:** ![henry\_rivera](https://www.epiusers.help/user_avatar/www.epiusers.help/henry_rivera/32/31329_2.png) [@henry\_rivera](https://www.epiusers.help/u/henry_rivera)\
**Post date:** [September 10, 2021, 5:53pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/11 "2021-09-10T17:53:15Z")

</div>

hola buenas tardes , por favor necesito ayuda con el tema mencionado…si me puedes ayudar le agradezco

 ![image](https://www.epiusers.help/uploads/default/original/3X/0/b/0bfbdba0a8e98d6a55250eb8f9ef57e983f4d36f.png)

---

<div class="post-metadata">

**Author:** ![utaylor](https://www.epiusers.help/user_avatar/www.epiusers.help/utaylor/32/64664_2.png) [@utaylor](https://www.epiusers.help/u/utaylor)\
**Post date:** [September 10, 2021, 5:58pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/12 "2021-09-10T17:58:23Z")

</div>

Oye Henry, por que usas el nobmre de la base de datos en este espacio?

Igual quitas eso.

![image](https://www.epiusers.help/uploads/default/original/3X/6/4/6472fdfa674e60dd172b1a9fef08230478639c8e.png)

---

<div class="post-metadata">

**Author:** ![utaylor](https://www.epiusers.help/user_avatar/www.epiusers.help/utaylor/32/64664_2.png) [@utaylor](https://www.epiusers.help/u/utaylor)\
**Post date:** [September 10, 2021, 6:03pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/13 "2021-09-10T18:03:06Z")

</div>

Pero al final, con referencia a los que han escrito antes, es algo con el enlace final de “SSRS Report Server Location.”

Has llamado a Epicor ya? Tienen un equipo de instalaciones que pueden ayudarte.

---

<div class="post-metadata">

**Author:** ![henry\_rivera](https://www.epiusers.help/user_avatar/www.epiusers.help/henry_rivera/32/31329_2.png) [@henry\_rivera](https://www.epiusers.help/u/henry_rivera)\
**Post date:** [September 10, 2021, 6:57pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/14 "2021-09-10T18:57:15Z")

</div>

y llame pero me dijeron que estaba dañado este archivo…pero como no era de problema de ellos no me podian resolver

 ![image](https://www.epiusers.help/uploads/default/original/3X/5/d/5dde511a03b6c0c098585f4e6908c26af4ebae7c.png)

---

<div class="post-metadata">

**Author:** ![utaylor](https://www.epiusers.help/user_avatar/www.epiusers.help/utaylor/32/64664_2.png) [@utaylor](https://www.epiusers.help/u/utaylor)\
**Post date:** [September 10, 2021, 7:30pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/15 "2021-09-10T19:30:54Z")

</div>

Ninguno de tus instalaciones funcionan o solo este? Veo k tienes EpicorPilot, Test, y otros.

---

<div class="post-metadata">

**Author:** ![ckrusen](https://www.epiusers.help/user_avatar/www.epiusers.help/ckrusen/32/50584_2.png) [@ckrusen](https://www.epiusers.help/u/ckrusen)\
**Post date:** [September 10, 2021, 7:43pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/16 "2021-09-10T19:43:07Z")

</div>

Is it normal for your executable files (.exe) to show with the Notepad icon?

Is your server is setup to always show file extensions in the File Manager?  
I ask because the file displayed as “RSPortal” has type “Application”

the one that displays as “RSPortal.exe” may actually be RSPorta.exe.config, with files with the .config extension having Notepad as their default program.

Open “RSPortal.exe” (the one that looks like a notepad icon), and then hit CTRL+END. There might be info in that file it is just way off to the right side.

---

<div class="post-metadata">

**Author:** ![henry\_rivera](https://www.epiusers.help/user_avatar/www.epiusers.help/henry_rivera/32/31329_2.png) [@henry\_rivera](https://www.epiusers.help/u/henry_rivera)\
**Post date:** [September 10, 2021, 8:33pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/17 "2021-09-10T20:33:47Z")

</div>

el archivo esta totalmente en blanco…puedes conectarse conmigo al WhatsApp al +573046338148

---

<div class="post-metadata">

**Author:** ![henry\_rivera](https://www.epiusers.help/user_avatar/www.epiusers.help/henry_rivera/32/31329_2.png) [@henry\_rivera](https://www.epiusers.help/u/henry_rivera)\
**Post date:** [September 10, 2021, 8:36pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/18 "2021-09-10T20:36:34Z")

</div>

ninguna

---

<div class="post-metadata">

**Author:** ![utaylor](https://www.epiusers.help/user_avatar/www.epiusers.help/utaylor/32/64664_2.png) [@utaylor](https://www.epiusers.help/u/utaylor)\
**Post date:** [September 10, 2021, 8:38pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/19 "2021-09-10T20:38:28Z")

</div>

Calvin, I can’t tell if the issue is that reporting services were setup wrong on the SQL server or if the deployment is just failing because of a setting in the admin console… What is your take?

---

<div class="post-metadata">

**Author:** ![henry\_rivera](https://www.epiusers.help/user_avatar/www.epiusers.help/henry_rivera/32/31329_2.png) [@henry\_rivera](https://www.epiusers.help/u/henry_rivera)\
**Post date:** [September 10, 2021, 8:44pm UTC](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561/20 "2021-09-10T20:44:23Z")

</div>

estaba funcionando todo sin inconvenientes…pero el dia de ayer se reinicio el servidor y desde ese momento tengo ese inconveniente …

1. no me cargaba el servicio del SQL server reporting service…emplace el archivo web.config  
y luego se verifico y veo que tambien el RSportal.exe.config esta dañado…no tiene ninguna informacion

[Next page](https://www.epiusers.help/t/error-on-deploying-app-with-ssrs/57561.md?page=2)
