title: SSRS login failure after DB restore
body: <p>In SSRS I have a shared Data Source where the authentication is set to "Credentials stored securely in the report server" and my reports were authenticating correctly and running as expected.</p>
  
  <p>After restoring the DB from a backup, it seems to have "broken" the user permissions. I checked that the user has "connect" permissions on the server AND "select" permissions on the DB that was restored. </p>
  
  <p>Also, I can successfully login through sql server management studio with the user in question. But when I try to Test the connection on the SSRS Data Source it fails.</p>
  
  <p>Thoughts?</p>