Changed Date Now Unable to Login to BC

-

Introduction

While doing some customization testing, which revolved around using different dates, I realized that once the date is switched back to the correct date, I was unable to connect to Business Central. 
I restarted the server instance, IIS, SQL Server services to no avail.

Pre-requisites

Business Central OnPrem with SSL Setup

References

Verification

Logging into Business Central gave no errors, there were no errors in the Event Viewer that explicitly mention that it is a Date related issue.

The way I stumbled across it being a date related issue is that in the Response that the Business Central server sent to the Login Request, was carrying the wrong date in it.

When I switched the System Date back to the date mentioned in the Response headers, everything seemed to be working again.



Solution

This issue is caused because when the system date is changed, the same is changed in IIS but when you change it back IIS does not refresh it and we have to manually reset it.

Restarting it does not work, trust me, I tried.

One way to do this is to execute the following commands on the Server:net http stop
net http start

These commands took a lot of time so be sure to have available down time before you run them.

The other way, which is much simpler in my opinion, is to simply restart the Server.

This stops all the services and restarts them which forces the IIS to reset as well.



Conclusion

Thus in this blog, we saw how to resolve the issue of being unable to login after change Server Date in Business Central. 

Hope this helps!

Comments

Post a Comment

Popular posts from this blog

Event-Driven Architecture: How to Create Custom Business Events in Business Central

-
Image
Introduction Events are notifications that signal something has happened in the system. A record getting created, updated or deleted, a sales order getting posted, etc are all examples of events. An event driven architecture provides asynchrony and decoupled communication between different components of the system supporting flexibility, scalability and modularity. In Business Central, we have two main types of events - Business and Integration. Integration Events are related to things within Business Central. They are use for extending the functionality of the Base Application without modifying it directly. Business Events are related to things outside of Business Central. They are used for notifying external systems (e.g., via Power Automate or Logic Apps) regarding any changes that happen within Business Central. Microsoft allows us to create custom Integration and Business Events based on our requirements. In this blog, we'll see how to create a custom Business Event and...
Read more

Visualizing Data: How to Add Power BI Reports to Business Central

-
Image
Introduction Power BI is a great tool for turning data into clear, interactive reports and the best part?  It works smoothly with Business Central, right out of the box.  You just need to set it up, and you can start viewing powerful reports right inside within Business Central dashboard.  Microsoft provides several ready-made reports, grouped into different apps, so you can pick and install only what you need.  Once set up, these reports help you track key business insights without switching between systems.  In this blog, we’ll walk you through how to set up and use Power BI reports in Business Central to make smarter decisions. References Introduction to Business Central and Power BI Install Power BI apps for Business Central Configuration Open your Business Central and search for "Assisted Setup". Click on "Connect to Power BI" Once the set up page opens, click on Next. Fiscal : A 12-month calendar that begins in any month and ends 12 months after. Standard ...
Read more

Know Your Users: Automated Usage Tracking for Better System Adoption

-
Image
Introduction After a new Business Central system goes live, it’s important to know if users are actually using it the way they should (Go-Live is just the beginning). Tracking usage statistics helps us understand how well the system is being adopted and where improvements might be needed. To make this easier, I’ve created a small utility that automatically collects user activity data and builds a report from it. This saves time and gives a clear picture of how the system is being used to the management. Here’s what it does: There’s a setup page where you can choose how stats are collected and skip certain users (like consultants or support team members who create test data). A configuration page lets you pick which tables to track. You can also set how often stats should be gathered using a frequency field; it even sets up the background job for you. A report which summarises the generated data in a neat matrix. With this tool, keeping an eye on system adoption becomes simple and autom...
Read more