SQL SERVER – Fix : Error: 4064 – Cannot open user default database. Login failed. Login failed for user | Journey to SQL Authority with Pinal Dave

I have received following question nearly 10 times in last week though emails. Many users have received following error while connecting to the database. This error happens when database is dropped for which is default for some of the database user. When user try to login and their default database is dropped following error shows… Continue Reading...

Source: SQL SERVER – Fix : Error: 4064 – Cannot open user default database. Login failed. Login failed for user | Journey to SQL Authority with Pinal Dave