Groups | Blog | Home
all groups > sql server reporting services > june 2007 >

sql server reporting services : Cannot connect either locally or fqdn to http://server/reportserve


JZ
6/28/2007 3:42:28 PM
I keep getting asked credentials when I try to login to the above site. Now
matter what credentials I use it just gets prompting me. The most
frustrating thing is that there are no real errors in event viewer. I get
the 401.1 and 401.2 depending if I change basic auth on the IIS side. Any
help would be appreciated.
Thanks in advance,
BERKE Janos
7/1/2007 9:21:56 PM
Hi,

Well, then you should check the following:
ReportServer and Reports virtual directory should set for windows
authentication.

Check the virtual directories NTFS permissions. You must have the SSRS
groups added. (SQLServer2005ReportingServicesWebServiceUser$<computer
name>$MSSQLSERVER, and SQLServer2005ReportServerUser$<computer
name>$MSSQLSERVER)Also you should check the
c:\Windows\Microsoft.NET\Framework\v2.0.50727\ Temporary ASP.NET Files
folder permission. IIS_IUSR user must have the appropiate permission on it.
If you still have the problem, try the following:

Start a command prompt, then navigate to the C:\Inetpub\Adminscripts folder
where the adsutil.vbs located.
Check the authentication providers with this in the command prompt: cscript
adsutil.vbs get w3svc/NTAuthenticationProviders
If you get "The parameter "NTAuthenticationProviders" is not set at this
node" message, then type cscript adsutil.vbs set
w3svc/NTAuthenticationProviders "NTLM" in cmd. After this try to open the
report manager from a remote machine.

I hope this solves the problem.

Regards,

Janos

[quoted text, click to view]
JZ
7/10/2007 2:30:00 PM
Thanks for your reply. I did try all your suggestions, but what it turned
out to be was a bad IIS install. Had to uninstall and reinstall to make
things happy.

[quoted text, click to view]
AddThis Social Bookmark Button