I did not need to create any user on sql server. Maybe try adding the reporting server to the list of trusted sites in the browser? What kind of security is set up for the browser are you using domain policies?