Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
solent
Starting Member
33 Posts |
 Posted - 2006-01-20 : 03:03:26
|
| i have setup a separate server and run SRS on it and access the SQL Server database from another server.I use integrated windows authentication on the SQL Server database and grant exec perms on sprocs to windows domain users.Now on the reporting services in order for the IIS to authenticate the NT Account in the directory security tab you have to set authentication access on Basic Authentication and disable all other methods.This method is working but every time a client accesses the http://SRSName/Reports he is asked for his credentials although the client is already authenticated on the domain.Any ideas how I can remove that popup credentials window if thats an option at all? |
|
|
jhermiz
3564 Posts |
Posted - 2006-01-27 : 00:09:46
|
quote:
Originally posted by solent
i have setup a separate server and run SRS on it and access the SQL Server database from another server.I use integrated windows authentication on the SQL Server database and grant exec perms on sprocs to windows domain users.Now on the reporting services in order for the IIS to authenticate the NT Account in the directory security tab you have to set authentication access on Basic Authentication and disable all other methods.This method is working but every time a client accesses the http://SRSName/Reports he is asked for his credentials although the client is already authenticated on the domain.Any ideas how I can remove that popup credentials window if thats an option at all?
Did you enable anonomyous access, I think you have to. Also what are the permissions for those end users when they access the report server. Remember in RS you should create a group with those users and give them read / write / execute access.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
solent
Starting Member
33 Posts |
Posted - 2006-02-03 : 07:38:37
|
| ok i did enable anonymous access but when i open http://RServer/Reports/ the page opens whitout the need of putting in windows credentials, but i cannot see my folders.when you mean permissions you mean the RS permissions or the NTFS permissions?any i tried both i gave the group that needs access to RS read/write/exec perms on the Virual direcotry Reports under my IIS and also i have setup that group on my RS as Browser Role. |
|
|
|
|
|
|
SRS Tier3 Authentication