6:30 spid18s Unknown Starting up database 'CSP_203449_DBSPC'. 6:37 spid51 Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 6:47 spid51 Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 6:47 spid52 Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 6:57 spid51 Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 7:00 spid38s Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 7:00 spid38s Unknown Starting up database 'CSP_203449_DBSPC'. 7:07 spid51 Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 7:17 spid51 Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 7:27 spid51 Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 7:30 spid28s Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 7:30 spid28s Unknown Starting up database 'CSP_203449_DBSPC'. 7:37 spid52 Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 7:47 spid51 Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 7:57 spid51 Unknown Starting up database 'CSP_203449_DBSPC'. 7:57 spid53 Unknown Starting up database 'CSP_203449_DBSPC'. 7:57 Logon Unknown Error: 18456 Severity: 14 State: 38. Reason: Failed to open the explicitly specified database 'CSP_203449_DBSPC'. 7:57 Logon Unknown Login failed for user 'CreativeSolutionsPractice CsDatabase Owner'. 7:57 spid54 Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 7:58 spid53 Unknown Starting up database 'CSP_203449_DBSPC'. 7:58 Logon Unknown Error: 18456 Severity: 14 State: 38. 7:58 Logon Unknown Login failed for user 'CreativeSolutionsPractice CsDatabase Owner'. 7:59 spid51 Unknown Starting up database 'CSP_203449_DBSPC'. 7:59 spid53 Unknown Starting up database 'CSP_203449_DBSPC'. 7:59 Logon Unknown Error: 18456 Severity: 14 State: 38. 7:59 Logon Unknown Login failed for user 'CreativeSolutionsPractice CsDatabase Owner'. 8:00 spid53 Unknown Starting up database 'CSP_203449_DBSPC'. 8:01 spid20s Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 8:01 spid20s Unknown Starting up database 'CSP_203449_DBSPC'. 8:01 spid53 Unknown Starting up database 'CSP_203449_DBSPC'. 8:01 Logon Unknown Error: 18456 Severity: 14 State: 38. 8:01 Logon Unknown Login failed for user 'CreativeSolutionsPractice CsDatabase Owner'. 8:02 Logon Unknown Error: 18456 Severity: 14 State: 38. 8:02 Logon Unknown Login failed for user 'CreativeSolutionsPractice CsDatabase Owner'. 8:07 spid51 Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 8:10 spid53 Unknown Starting up database 'CSP_203449_DBSPC'. 8:11 spid54 Unknown Starting up database 'CSP_203449_DBSPC'. 8:11 Logon Unknown Error: 18456 Severity: 14 State: 38. 8:11 Logon Unknown Login failed for user 'CreativeSolutionsPractice CsDatabase Owner'. 8:11 spid53 Unknown Starting up database 'CSP_203449_DBSPC'. 8:15 spid51 Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 8:17 spid53 Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 8:27 spid60 Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 8:31 spid20s Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. 8:37 spid53 Unknown Starting up database 'ReportServer$SQLEXPRESSTe mpDB'. I have contacted the vendor and they claim that it is a SQL problem and refuse to help troubleshoot.Īny help is appreciated. Once the logins start working, they work for everyone the reset of the day.īackups run at 12:00 am and finish within minutes. Then, logins started failing until a variable time between 8:00 am and 8:30 am. Until about 4 weeks ago, things were running along normally.
They are running Thompson Reuters PracticeCS with the database hosted on this server.
One of my clients is a single server environment, Windows server 2016 Essentials, running SQL Server (Express) 2014.