Authentication problem: can't bypass the login prompt when browsing to the SQL Reporing Services web
- by laurens
Hi all,
I'm having a hard time configuring Reporting services on one of our servers. I'm not uninitiated in the domain of IIS7 but I cannot get rid of the login prompt when I'm surfing to the Reporting services website.
What I did:
I made a windows and SQL user with the same name:
Then I choose Anonymous authentication in II7 and filled in the credentials of the specific R.S. user http://img32.imageshack.us/i/iis7auth.jpg/
I choose 'Local Service' as the service account in the R.S. configuration mgr http://img88.imageshack.us/i/rsconfigmgr.jpg/
The first problem is that there's always a pop-up when surfing to the website
The second is that when I'm able to log in I get the message that the user doesn't have the appropriate permissions.
The pop-up: http://img693.imageshack.us/i/loginpopup.jpg/
The server is a 2008 Web Server with SQL 2008 R2 Express.
What I'm I doing wrong?
Thanks in advance!