Vista and Windows 7 (and 2008) include UAC (User Access Control) and this is directly stopping you from accessing a SQL reporting website unless you make the following changes.
The error that you get looks much like this:
User ‘domain\user’ does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed
Its actually pretty easy to fix this issue. You just need to add this site to the trusted sites in IE and all sorted
Following these instructions will get you there:
1. Open Internet Explorer
2. Click on the "Tools" menu and select "Internet Options"
3. Click on the "Security" tab
4. Click once on "Local intranet"
5. Click on the "Sites" button
6. Click on the "Advanced" button
7. Make sure "Require server verification (https:) for all sites in this zone is unchecked.
8. Add "http://[ ComputerName]" to the Websites list.
9. Click the "Close" button to close the Advanced window.
10. Click the “Custom Level” button near the bottom.
11. Scroll down to the end and you will see the “User Authentication” section.
12. User “User Authentication” and then “Logon” verify that “Automatic logon only in Intranet Zone” is selected. If not select it.
13. Click “OK” to close the Security Settings – Local Intranet Zone window.
14. Click the "OK" button to close the Local intranet window.
15. Click the "OK" button to close the Internet Options Window
16. Close Internet Explorer
17. Re-open Internet Explorer and browse to http://[ ComputerName]/Reports. You should no longer be prompted to login.
Once completed you should now be able to login without issue