publishing web api core 3.1 with database (sqlserver) to local IIS RSS

5 replies

Last post Jan 29, 2020 07:10 PM by lextm

  • publishing web api core 3.1 with database (sqlserver) to local IIS

    Jan 24, 2020 01:34 PM|matloob_salem|LINK

    How to publish an Asp.net Core 3.1 Web API to LOCAL IIS, the app is using SQL Server as backend.
    I was able to publish core 3.1 web API that does not have a database, however, with database and DB context used, I am getting 500 HTTP status code.

    Thanks

  • Re: publishing web api core 3.1 with database (sqlserver) to local IIS

    Jan 27, 2020 02:36 AM|Brando Zhang|LINK

    Hi matloob,

    According to your decription, I couldn't understand your issue claerly.

    Could you please post the details error message abotu your 500 error?

    Besides, you mean you add some codes to use EF core in your web api application and you just modify the conenction string and then face the 500 error?

    I suggest you could also use SSMS to connect to your database to make your server could access your database.

    Best Regards,

    Brando

  • Re: publishing web api core 3.1 with database (sqlserver) to local IIS

    Jan 27, 2020 11:05 AM|matloob_salem|LINK

    Hi Brando,

    First, thank you for your response.

    "Could you please post the details error message abotu your 500 error?"

    ans: There is no error message return, only the response code and it is 500,

    I used SSMS, and when i run the application in the IDE it works fine and i can do my CRUD operations against the DB, however, when i publish the application to the local IIS then when try to access the application i get 500 error code.

    Regards

  • Re: publishing web api core 3.1 with database (sqlserver) to local IIS

    Jan 27, 2020 01:33 PM|lextm|LINK

    matloob_salem

    ans: There is no error message return, only the response code and it is 500,

    FRT should reveal much more,

    https://docs.microsoft.com/en-us/iis/troubleshoot/using-failed-request-tracing/troubleshooting-failed-requests-using-tracing-in-iis 

    Lex Li
    https://lextudio.com
    ---------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
  • Re: publishing web api core 3.1 with database (sqlserver) to local IIS

    Jan 29, 2020 04:39 PM|matloob_salem|LINK

    here is the log i got

    <?xml version="1.0" encoding="UTF-8" ?>
    <?xml-stylesheet type='text/xsl' href='freb.xsl'?>
    <!-- saved from url=(0014)about:internet -->
    <failedRequest url="https://dev.crudef.com:443/api/teachers"
    siteId="3"
    appPoolId="crudef"
    processId="11436"
    verb="GET"
    remoteUserName=""
    userName=""
    tokenUserName="NT AUTHORITY\IUSR"
    authenticationType="anonymous"
    activityId="{8000000A-0003-FF00-B63F-84710C7967BB}"
    failureReason="STATUS_CODE"
    statusCode="500"
    triggerStatusCode="500"
    timeTaken="109"
    xmlns:freb="http://schemas.microsoft.com/win/2006/06/iis/freb"
    >
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>0</Level>
    <Opcode>1</Opcode>
    <Keywords>0x0</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.374Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    <Data Name="SiteId">3</Data>
    <Data Name="AppPoolId">crudef</Data>
    <Data Name="ConnId">1610612744</Data>
    <Data Name="RawConnId">0</Data>
    <Data Name="RequestURL">https://dev.crudef.com:443/api/teachers</Data>
    <Data Name="RequestVerb">GET</Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>GENERAL_REQUEST_START</Opcode>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{D42CF7EF-DE92-473E-8B6C-621EA663113A}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>4</Level>
    <Opcode>55</Opcode>
    <Keywords>0x0</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.374Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    <Data Name="RemoteAddress">127.0.0.1</Data>
    <Data Name="RemotePort">57461</Data>
    <Data Name="LocalAddress">127.0.0.1</Data>
    <Data Name="LocalPort">443</Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>GENERAL_ENDPOINT_INFORMATION</Opcode>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{D42CF7EF-DE92-473E-8B6C-621EA663113A}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>4</Level>
    <Opcode>50</Opcode>
    <Keywords>0x0</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.374Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    <Data Name="Headers">Cache-Control: no-cache
    Connection: keep-alive
    Accept: */*
    Accept-Encoding: gzip, deflate, br
    Host: dev.crudef.com
    User-Agent: PostmanRuntime/7.22.0
    Postman-Token: 3c563408-0f54-4861-a3b9-ccdfa192f2e6
    </Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>GENERAL_REQUEST_HEADERS</Opcode>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{D42CF7EF-DE92-473E-8B6C-621EA663113A}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>4</Level>
    <Opcode>30</Opcode>
    <Keywords>0x0</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.374Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    <Data Name="PhysicalPath"></Data>
    <Data Name="AccessPerms">513</Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>GENERAL_GET_URL_METADATA</Opcode>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{D42CF7EF-DE92-473E-8B6C-621EA663113A}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>4</Level>
    <Opcode>43</Opcode>
    <Keywords>0x0</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.374Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    <Data Name="OldHandlerName"></Data>
    <Data Name="NewHandlerName">aspNetCore</Data>
    <Data Name="NewHandlerModules">AspNetCoreModuleV2</Data>
    <Data Name="NewHandlerScriptProcessor"></Data>
    <Data Name="NewHandlerType"></Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>HANDLER_CHANGED</Opcode>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{D42CF7EF-DE92-473E-8B6C-621EA663113A}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>4</Level>
    <Opcode>10</Opcode>
    <Keywords>0x2</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.374Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    <Data Name="AuthTypeSupported">1</Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>AUTH_START</Opcode>
    <Keywords>
    <Keyword>Authentication</Keyword>
    </Keywords>
    <freb:Description Data="AuthTypeSupported">Anonymous</freb:Description>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{C33BBE8F-985B-4080-81E6-005F1A06B9E2}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>4</Level>
    <Opcode>27</Opcode>
    <Keywords>0x2</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.374Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    <Data Name="RequestAuthType">1</Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>AUTH_REQUEST_AUTH_TYPE</Opcode>
    <Keywords>
    <Keyword>Authentication</Keyword>
    </Keywords>
    <freb:Description Data="RequestAuthType">Anonymous</freb:Description>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{C33BBE8F-985B-4080-81E6-005F1A06B9E2}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>4</Level>
    <Opcode>11</Opcode>
    <Keywords>0x2</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.374Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    <Data Name="AuthType">4</Data>
    <Data Name="NTLMUsed">false</Data>
    <Data Name="RemoteUserName"></Data>
    <Data Name="AuthUserName"></Data>
    <Data Name="TokenImpersonationLevel">2</Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>AUTH_SUCCEEDED</Opcode>
    <Keywords>
    <Keyword>Authentication</Keyword>
    </Keywords>
    <freb:Description Data="AuthType">NT</freb:Description>
    <freb:Description Data="TokenImpersonationLevel">ImpersonationImpersonate</freb:Description>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{C33BBE8F-985B-4080-81E6-005F1A06B9E2}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>4</Level>
    <Opcode>44</Opcode>
    <Keywords>0x0</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.374Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    <Data Name="AuthType"></Data>
    <Data Name="UserName"></Data>
    <Data Name="SupportsIsInRole">true</Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>USER_SET</Opcode>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{D42CF7EF-DE92-473E-8B6C-621EA663113A}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>4</Level>
    <Opcode>28</Opcode>
    <Keywords>0x2</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.374Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>AUTH_END</Opcode>
    <Keywords>
    <Keyword>Authentication</Keyword>
    </Keywords>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{C33BBE8F-985B-4080-81E6-005F1A06B9E2}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>4</Level>
    <Opcode>56</Opcode>
    <Keywords>0x0</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.483Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    <Data Name="HeaderName">X-Powered-By</Data>
    <Data Name="HeaderValue">ASP.NET</Data>
    <Data Name="Replace">false</Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>GENERAL_SET_RESPONSE_HEADER</Opcode>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{D42CF7EF-DE92-473E-8B6C-621EA663113A}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>5</Level>
    <Opcode>52</Opcode>
    <Keywords>0x0</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.483Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    <Data Name="Reason">2</Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>GENERAL_NOT_SEND_CUSTOM_ERROR</Opcode>
    <freb:Description Data="Reason">SETSTATUS_TRYSKIP</freb:Description>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{D42CF7EF-DE92-473E-8B6C-621EA663113A}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>4</Level>
    <Opcode>35</Opcode>
    <Keywords>0x0</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.483Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>GENERAL_FLUSH_RESPONSE_START</Opcode>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{D42CF7EF-DE92-473E-8B6C-621EA663113A}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>4</Level>
    <Opcode>47</Opcode>
    <Keywords>0x0</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.483Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    <Data Name="Headers">Transfer-Encoding: chunked
    Server: Microsoft-IIS/10.0
    X-Powered-By: ASP.NET
    </Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>GENERAL_RESPONSE_HEADERS</Opcode>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{D42CF7EF-DE92-473E-8B6C-621EA663113A}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>4</Level>
    <Opcode>36</Opcode>
    <Keywords>0x0</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.483Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    <Data Name="BytesSent">154</Data>
    <Data Name="ErrorCode">0</Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>GENERAL_FLUSH_RESPONSE_END</Opcode>
    <freb:Description Data="ErrorCode">The operation completed successfully.
    (0x0)</freb:Description>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{D42CF7EF-DE92-473E-8B6C-621EA663113A}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>4</Level>
    <Opcode>35</Opcode>
    <Keywords>0x0</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.483Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>GENERAL_FLUSH_RESPONSE_START</Opcode>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{D42CF7EF-DE92-473E-8B6C-621EA663113A}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>5</Level>
    <Opcode>49</Opcode>
    <Keywords>0x0</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.483Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    <Data Name="Buffer">0

    </Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>GENERAL_RESPONSE_ENTITY_BUFFER</Opcode>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{D42CF7EF-DE92-473E-8B6C-621EA663113A}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>4</Level>
    <Opcode>36</Opcode>
    <Keywords>0x0</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.483Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    <Data Name="BytesSent">5</Data>
    <Data Name="ErrorCode">0</Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>GENERAL_FLUSH_RESPONSE_END</Opcode>
    <freb:Description Data="ErrorCode">The operation completed successfully.
    (0x0)</freb:Description>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{D42CF7EF-DE92-473E-8B6C-621EA663113A}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
    <System>
    <Provider Name="WWW Server" Guid="{3A2A4E84-4C21-4981-AE10-3FDA0D9B0F83}"/>
    <EventID>0</EventID>
    <Version>1</Version>
    <Level>0</Level>
    <Opcode>2</Opcode>
    <Keywords>0x0</Keywords>
    <TimeCreated SystemTime="2020-01-29T16:37:47.483Z"/>
    <Correlation ActivityID="{8000000A-0003-FF00-B63F-84710C7967BB}"/>
    <Execution ProcessID="11436" ThreadID="13036"/>
    <Computer>SALEM-MATLOOB</Computer>
    </System>
    <EventData>
    <Data Name="ContextId">{8000000A-0003-FF00-B63F-84710C7967BB}</Data>
    <Data Name="BytesSent">159</Data>
    <Data Name="BytesReceived">238</Data>
    <Data Name="HttpStatus">500</Data>
    <Data Name="HttpSubStatus">0</Data>
    </EventData>
    <RenderingInfo Culture="en-US">
    <Opcode>GENERAL_REQUEST_END</Opcode>
    </RenderingInfo>
    <ExtendedTracingInfo xmlns="http://schemas.microsoft.com/win/2004/08/events/trace">
    <EventGuid>{D42CF7EF-DE92-473E-8B6C-621EA663113A}</EventGuid>
    </ExtendedTracingInfo>
    </Event>
    </failedRequest>

  • Re: publishing web api core 3.1 with database (sqlserver) to local IIS

    Jan 29, 2020 07:10 PM|lextm|LINK

    FRT indicated that the 500.0 error response was indeed coming from your ASP.NET Core app. Therefore, you have to enable Kestrel logging to see what it might log there,

    https://docs.microsoft.com/en-us/aspnet/core/host-and-deploy/aspnet-core-module?view=aspnetcore-3.1#enhanced-diagnostic-logs 

    Lex Li
    https://lextudio.com
    ---------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.