Sage 100

 View Only
  • 1.  I'm learning more than I ever wanted about the dar

    Posted 08-24-2017 15:08
      |   view attached
    I'm learning more than I ever wanted about the dark arts of sData. I have a third party trying to use it at a client and two things are happening: When I install the sData adapter I'm getting the message ""ASP.NET must be installed and enabled for IIS service"". The IT department assures me that it is installed. When I try to do the test connect to https://<server>/sdata/MasApp/MasContract/ABC/$schema I'm getting a ""not found"" error. Has anyone made this work and might know where to look? I'm beginning to Google and mess with the server which always goes well...


  • 2.  RE: I'm learning more than I ever wanted about the dar

    Posted 08-24-2017 15:11
    Sage 100 version? Server op system?


  • 3.  RE: I'm learning more than I ever wanted about the dar

    Posted 08-24-2017 15:16
    Sorry! - Sage 100c Advanced 2017.1. Server is 2008 r2.


  • 4.  RE: I'm learning more than I ever wanted about the dar

    Posted 08-24-2017 15:17
      |   view attached


  • 5.  RE: I'm learning more than I ever wanted about the dar

    Posted 08-24-2017 15:24
    @KevinMoyes - IIS 7.5 is the default for Server 2008R2, are you saying that IIS 8 should be installed?


  • 6.  RE: I'm learning more than I ever wanted about the dar

    Posted 08-25-2017 06:09
      |   view attached
    No, just that just having ASP.NET installed doesn't mean that it's the correct version. That was a quote from the sData documentation PDF (for which there may be a newer version).


  • 7.  RE: I'm learning more than I ever wanted about the dar

    Posted 08-25-2017 15:42
      |   view attached
    Try schema request as http instead of https - if it works it means there is no SSL cert on the IIS box or cert is there but needs to be attached to the website in IIS (sometimes people bind the cert to the default website but not the particular one for the SData or web service). Also like everything else, Allow External Access needs to be checked in Company Maint. Also, I'm sure you've covered basics but just in case (don't hit me) have you turned on SData in System Config and enabled access in Role Maint and installed the ""SData Adapter.exe"" from the Sage 100 2017 image to the IIS box? Also I know this from our own Web Services for clients who's IIS box was not same as one running Sage 100. When you installed the SData Adapter, was the Windows user account you specified in the installer a domain account? Essentially this user (context) will be accessing ..\mas90\.. via a UNC and we don't want it to be challenged for user creds and want it to not have Read Only access through the share. Here are some other testing you or client's IT can do: * Run schema request inside the IIS box (remote into it) as a domain account which is a local administrator (doesn't have to be domain admin). * Run schema request inside the IIS box (remote into it) as the Windows user uses during SData Adapter installation. If it works from here you prolly have firewall problem. If doesn't, just right there in File Explorer type \\server\share\<path to \mas90> and press Enter and see if you get challenged for user creds. If not, then in ..\mas90 try to create a text file then delete it. * SData uses BOI (almost all web services do). So run one of your BOI scripts on IIS box while logged into as the Windows user for SData. Also outside of the Guide that Kevin posted, here is a Sage Summit presentation some seasons ago by Kent Mackall. Follow the ""Quick Setup Instructions.txt"" and the PDF. All other files should go on the root of the website's virtual directory on the IIS box. You could try this all on your own machine too.

    Attachment(s)

    zip
    P-51_Sage_100_ERP_SData.zip   213 KB 1 version


  • 8.  RE: I'm learning more than I ever wanted about the dar

    Posted 08-27-2017 15:02
    An update on this: Installing WCF services fixed the issue. Thanks @KevinMoyes and @AlnoorCassim for providing the PDF with all the sData secrets. Thank you!!


  • 9.  RE: I'm learning more than I ever wanted about the dar

    Posted 08-27-2017 15:07
    @KateKrueger - Are you now the sData guru for the group??


  • 10.  RE: I'm learning more than I ever wanted about the dar

    Posted 08-27-2017 15:10
    only if I can secretly ask Kevin and Alnoor all my questions.