We are getting this error when logging into Kinetic 2024.1. We had some security updates done over the weekend but now the SQL server won’t connect. Working with EpicCare and it’s outside of their scope. We have also recycled app pool and rebooted servers.
What are you seeing on the app server event viewer logs?
And what about the app server logs?
Can you connect to the SQL database using Microsoft SQL Management Studio?
Yeah that’s the other question I was going to ask.
Can you connect to the database using SQL Server Management studio using the account you have set up for appserver pool.
the only thing listed is about SQL server evaluation expired. which i really hope we didn’t overlook. unfortunately i cannot see the event log personally just from our 3rd party IT.
Is the SQL Server Service started on the SQL server? Or is it off?
yes sql server service is on. for some reason we can’t get into SMSS 19 or 20, but 18 works. 18 doesn’t work with Kinetic though i guess?
Googled it…Microsoft event ID 17051 appears to be an expiration of the SQL Server’s evaluation period…
Unfortunately, it does look like our evaluation period expired as they used a trial
90 day license. Bit of an oversight. re-install of SQL server is hopefully the solution.
Looks like you can do it without a reinstall…look for Edition Upgrade.
It all depends on the version I think, but yeah you might be able to.
Yeah that’s why when you said even Kinetic was giving you this error apart from SSMS that’s when I was thinking there must be a license/version issue, not just an SSMS issue cause I think you can get this error just from SSMS tools.
backup now, thanks for the insight. reinstall worked with a new key. Fun learning new things!
Nice!
Might I suggest marking an answer to this thread so that your learning may help others ?
Niiiiiiiiiiice…glad it worked out for ya