Forum Discussion

joshlabtech

Copper Contributor

Jul 20, 2023

Error msg: Login failed for user... Reason: Failed to open the explicitly specified database 'JetSer

Hi Community, May I know where do I check for errors like this? I'm using SQL Server Management Studio 2016 Thank you!

joshlabtech

Copper Contributor

Jul 21, 2023

Hi Ben_Miller_DBADuck

Thanks for youre reply. I'm still quite new to sql so hope to have some guidance. May I know where can I see this NETWORK SERVICE login?

This error message has been happening everyday, but I don't recall we have anything that requires to login to sql everyday other than our backups.

Ben_Miller_DBADuck

MVP

Jul 22, 2023

Because the CLIENT indicates in the error message that it is from ::1 it means that it is from the local machine. NETWORK SERVICE could be a service that is logging in as that. You can see quickly if it is related to SQL Server services by going into the SQL Configuration Manager on the server and go to Services and see if NETWORK SERVICE is a login that uses this account.