Need help with SQL Server 2014 Error 18456 Severity 14 State 38

One of my clients is a single server environment, Windows server 2016 Essentials, running SQL Server (Express) 2014.  

They are running Thompson Reuters PracticeCS with the database hosted on this server.

Until about 4 weeks ago, things were running along normally.  Then, logins started failing until a variable time between 8:00 am and 8:30 am.  Once the logins start working, they work for everyone the reset of the day.  

Backups run at 12:00 am and finish within minutes.  The database is "Always on".

I have contacted the vendor and they claim that it is a SQL problem and refuse to help troubleshoot.

Any help is appreciated.  Below are the recent logs.  At 8:37, users could log in.

Date      Source      Severity      Message
9/18/2018 8:37      spid53      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 8:31      spid20s      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 8:27      spid60      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 8:17      spid53      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 8:15      spid51      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 8:11      spid53      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 8:11      Logon      Unknown      Login failed for user 'CreativeSolutionsPracticeCsDatabaseOwner'. Reason: Failed to open the explicitly specified database 'CSP_203449_DBSPC'. [CLIENT: 10.0.0.62]
9/18/2018 8:11      Logon      Unknown      Error: 18456<c/> Severity: 14<c/> State: 38.
9/18/2018 8:11      Logon      Unknown      Login failed for user 'CreativeSolutionsPracticeCsDatabaseOwner'. Reason: Failed to open the explicitly specified database 'CSP_203449_DBSPC'. [CLIENT: 10.0.0.62]
9/18/2018 8:11      Logon      Unknown      Error: 18456<c/> Severity: 14<c/> State: 38.
9/18/2018 8:11      spid54      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 8:10      spid53      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 8:07      spid51      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 8:02      Logon      Unknown      Login failed for user 'CreativeSolutionsPracticeCsDatabaseOwner'. Reason: Failed to open the explicitly specified database 'CSP_203449_DBSPC'. [CLIENT: 10.0.0.63]
9/18/2018 8:02      Logon      Unknown      Error: 18456<c/> Severity: 14<c/> State: 38.
9/18/2018 8:01      Logon      Unknown      Login failed for user 'CreativeSolutionsPracticeCsDatabaseOwner'. Reason: Failed to open the explicitly specified database 'CSP_203449_DBSPC'. [CLIENT: 10.0.0.63]
9/18/2018 8:01      Logon      Unknown      Error: 18456<c/> Severity: 14<c/> State: 38.
9/18/2018 8:01      spid53      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 8:01      spid20s      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 8:01      spid20s      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 8:00      spid53      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 7:59      Logon      Unknown      Login failed for user 'CreativeSolutionsPracticeCsDatabaseOwner'. Reason: Failed to open the explicitly specified database 'CSP_203449_DBSPC'. [CLIENT: 10.0.0.63]
9/18/2018 7:59      Logon      Unknown      Error: 18456<c/> Severity: 14<c/> State: 38.
9/18/2018 7:59      Logon      Unknown      Login failed for user 'CreativeSolutionsPracticeCsDatabaseOwner'. Reason: Failed to open the explicitly specified database 'CSP_203449_DBSPC'. [CLIENT: 10.0.0.63]
9/18/2018 7:59      Logon      Unknown      Error: 18456<c/> Severity: 14<c/> State: 38.
9/18/2018 7:59      spid53      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 7:59      spid51      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 7:58      Logon      Unknown      Login failed for user 'CreativeSolutionsPracticeCsDatabaseOwner'. Reason: Failed to open the explicitly specified database 'CSP_203449_DBSPC'. [CLIENT: 10.0.0.61]
9/18/2018 7:58      Logon      Unknown      Error: 18456<c/> Severity: 14<c/> State: 38.
9/18/2018 7:58      Logon      Unknown      Login failed for user 'CreativeSolutionsPracticeCsDatabaseOwner'. Reason: Failed to open the explicitly specified database 'CSP_203449_DBSPC'. [CLIENT: 10.0.0.61]
9/18/2018 7:58      Logon      Unknown      Error: 18456<c/> Severity: 14<c/> State: 38.
9/18/2018 7:58      spid53      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 7:58      Logon      Unknown      Login failed for user 'CreativeSolutionsPracticeCsDatabaseOwner'. Reason: Failed to open the explicitly specified database 'CSP_203449_DBSPC'. [CLIENT: 10.0.0.61]
9/18/2018 7:58      Logon      Unknown      Error: 18456<c/> Severity: 14<c/> State: 38.
9/18/2018 7:57      spid54      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 7:57      Logon      Unknown      Login failed for user 'CreativeSolutionsPracticeCsDatabaseOwner'. Reason: Failed to open the explicitly specified database 'CSP_203449_DBSPC'. [CLIENT: 10.0.0.61]
9/18/2018 7:57      Logon      Unknown      Error: 18456<c/> Severity: 14<c/> State: 38.
9/18/2018 7:57      spid53      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 7:57      spid51      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 7:47      spid51      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 7:37      spid52      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 7:30      spid28s      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 7:30      spid28s      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 7:27      spid51      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 7:17      spid51      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 7:07      spid51      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 7:00      spid38s      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 7:00      spid38s      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 6:57      spid51      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 6:47      spid52      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 6:47      spid51      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 6:37      spid51      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 6:30      spid18s      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 6:30      spid18s      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 6:29      Logon      Unknown      Login failed for user 'CreativeSolutionsPracticeCsDatabaseOwner'. Reason: Failed to open the explicitly specified database 'CSP_203449_DBSPC'. [CLIENT: 10.0.0.63]
9/18/2018 6:29      Logon      Unknown      Error: 18456<c/> Severity: 14<c/> State: 38.
9/18/2018 6:29      Logon      Unknown      Login failed for user 'CreativeSolutionsPracticeCsDatabaseOwner'. Reason: Failed to open the explicitly specified database 'CSP_203449_DBSPC'. [CLIENT: 10.0.0.63]
9/18/2018 6:29      Logon      Unknown      Error: 18456<c/> Severity: 14<c/> State: 38.
9/18/2018 6:29      spid55      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 6:28      spid54      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 6:27      spid51      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 6:17      spid51      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 6:07      spid51      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 5:59      spid26s      Unknown      Starting up database 'CSP_203449_DBSPC'.
9/18/2018 5:59      spid26s      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 5:57      spid51      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 5:47      spid51      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 5:37      spid51      Unknown      Starting up database 'ReportServer$SQLEXPRESSTempDB'.
9/18/2018 5:29      spid36s      Unknown      Starting up database 'CSP_203449_DBSPC'.
Dean EgnerDirector of Professional ServicesAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Éric MoreauSenior .Net ConsultantCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dean EgnerDirector of Professional ServicesAuthor Commented:
Thanks for the advice.  I have turned off the Auto-Close option and will let you know the results.

Dean
0
lcohanDatabase AnalystCommented:
Starting up database....

This sounds like the SQL Server Express is restarting on that box for whatever reason and you (or someone with OS rights) need to check the Event Viewer for more details to figure out why this SQL Service restart is happening.

Also when you say that
The database is "Always on".
What are you referring to from the two definitiones below:
  • AlwaysOn Failover Clustering Instances (AlwaysOn FCI)
  • AlwaysOn Availability Groups (AlwaysOn AG)
0
Dean EgnerDirector of Professional ServicesAuthor Commented:
Thank you all for the responses!  The auto-close disable did the trick.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2016

From novice to tech pro — start learning today.