Just like Jay mentioned, you need to check that all the permissions on the DB account are setup correctly. I found the solution on the documents from MS Learn.