Try to use this in SSMS: Initial Catalog=DB NAME;ApplicationIntent=ReadOnly

I had the same problem but when I specified which DB to connect to it worked and used all the authorities the...