I had the same problem for a while and then I fixed it based on these links. I also created a new login user for only that database so that I can use it with Ignition only (I put the link below).
If you did everything that the manual said, my recommendation is to create a new login.
