Asp.net core database is not working after publishing

Sk Jha

6y2.1k.NET

Give any solution to resolve the issue of database connection after publishing my asp.net core 3.0 with entity framework code first approach in iis server. after publishing application is working but getting error 4o4 page not found on that page which is used database. Help me to resolve it.

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Viswanatha Swamy6y ago
Sk Jha,

Good evening. If you go to the Event Viewer you should see similar Error. Then I changed the connection string to localhost. It worked.

Event Viewer Log:
Exception:
Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Cannot create an automatic instance. See the Windows Application event log for error details.
)
---> System.ComponentModel.Win32Exception (0x89C50118): Unknown error (0x89c50118)
at DeltaSoftLIS.Controllers.LoginController.Index(String username, String password) in
Viswanatha Swamy6y ago
Sent the email id to your as a message. Please look into the message section.
Sk Jha6y ago
can you please give me your email id that I can share my project with you.
Viswanatha Swamy6y ago
Hello Sk Jha,

Good evening. I am unable to find the project. Please advise. Many thanks.

Regards,

Swamy
Sk Jha6y ago
Hi Swamy,

I am giving LoginController file here.
public class LoginController : Controller
   {
       private readonly ApplicationDbContext _db;

       public LoginController(ApplicationDbContext context)
       {
           _db = context;
       }
       public IActionResult Index()
       {
           return View();
       }


       [HttpPost]
       [Route("~/Login/Index/{username?}/{password?}")]
       public IActionResult Index(string ? username, string ? password)
       {
           var userId = _db.logins.Where(p=>p.UserName==username && p.Password==password && p.ExpiryDate> DateTime.Now).Select(p=>p.Id).FirstOrDefault();
           if (userId>0)
           {
               HttpContext.Session.SetString("username", username);
               return Redirect("~/Reception/Home/Index");
           }
           else
           {
               ViewBag.error = "Invalid Login..!";
               return View("Index");
           }
       }

       [HttpPost]
       public IActionResult Logout()
       {
           HttpContext.Session.Remove("username");
           return Redirect("~/Login");
       }
   }
and I am also attaching my project kindly look and resolve the issue
Thanks alot
Viswanatha Swamy6y ago
Hello Sk Jha,
I am seeing the HTTP-verb as POST. Are you making a POST call for this? Could you please paste the code of Login/Index .cs? Also could you please open the Developer tools and capture the images from network and console tabs. Many thanks.

Regards,
Swamy

Log:
<failedRequest url="http://delta.lis.com:81/Login/Index"
               siteId="2"
               appPoolId="DeltaSoftLIS"
               processId="10288"
               verb="POST"
               remoteUserName=""
               userName=""
               tokenUserName="NT AUTHORITY\IUSR"
               authenticationType="anonymous"
               activityId="{800000BA-0003-FF00-B63F-84710C7967BB}"
               failureReason="STATUS_CODE"
               statusCode="404"
               triggerStatusCode="404"
               timeTaken="14594"
               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>0EventID>
  <Version>1Version>
  <Level>0Level>
  <Opcode>1Opcode>
  <Keywords>0x0Keywords>
  <TimeCreated SystemTime="2020-05-09T13:57:41.823Z"/>
  <Correlation ActivityID="{800000BA-0003-FF00-B63F-84710C7967BB}"/>
  <Execution ProcessID="10288" ThreadID="5684"/>
  <Computer>DESKTOP-B88OQR6Computer>
System>
<EventData>
  <Data Name="ContextId">{800000BA-0003-FF00-B63F-84710C7967BB}Data>
  <Data Name="SiteId">2Data>
  <Data Name="AppPoolId">DeltaSoftLISData>
  <Data Name="ConnId">1610612916Data>
  <Data Name="RawConnId">0Data>
  <Data Name="RequestURL">http://delta.lis.com:81/Login/IndexData>
  <Data Name="RequestVerb">POSTData>
EventData>
Jignesh Kumar6y ago
Hi,

Please try this one,
https://stackoverflow.com/questions/42865161/asp-net-core-application-not-connecting-to-database-after-publishing
Sk Jha6y ago
Hi swamy,

I am attaching failed request tracing log file here..
Viswanatha Swamy6y ago
Hello Sk Jha,
Good evening. Ok, next could you please pull a couple of Urls that works. Also if it is possible to get the IIS Failed Request Tracing Logs? That will give the exact issue. Many thanks.
Sk Jha6y ago
Thanks for the suggestion Viswanatha Swamy.
The error given below.

No webpage was found for the web address: http://delta.lis.com:81/Login/Index
HTTP ERROR 404

I think the problem is in the database because the only database used pages are not loading. but non-database pages are loading properly.
Viswanatha Swamy6y ago
Hello Sk Jha,
Good morning. Are you getting 404 is for the route? OR Is it something related to Database configuration? Could you please post the error message to start with? Many thanks.

Regards,
Swamy