Despite the error message this problem can be caused by something other than an Authorization failure.  In fact, simply misspelling the Initial Catalog can cause this message to appear.  I wish developers wouldn’t reuse error messages when the problem and solution is completely different.