Forum Discussion
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 , for each server login you can define a "Default database", like "JetServices" as in the error message.
But if the database isn't available for some reasons, the login attempt for the user. One reason, why it's not best pratice do define a user database as default; always define system database "master" as defautl.
See Create a Login - SQL Server | Microsoft Learn => Step 9 "From the Default database list, select a default database for the login. Master is the default for this option."
