Discussion:
Cannot connect either locally or fqdn to http://server/reportserve
(too old to reply)
JZ
2007-06-28 22:42:28 UTC
Permalink
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,
John
BERKE Janos
2007-07-01 19:21:56 UTC
Permalink
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
Post by JZ
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,
John
JZ
2007-07-10 21:30:00 UTC
Permalink
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.
Post by BERKE Janos
Hi,
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.
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
Post by JZ
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,
John
Vic Plaskett
2011-01-06 15:55:05 UTC
Permalink
This was the needle in the hay stack that I was looking for. Just one simple command to determine the real cause of the problem.
Thanks!!!
Post by JZ
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,
John
Post by BERKE Janos
Hi,
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.
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
Post by JZ
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.
Submitted via EggHeadCafe
Microsoft .NET DataBase Access For Beginners
http://www.eggheadcafe.com/training-topic-area/Microsoft-NET-DataBase-Access/1/SQL-Server-Oracle-DB2-Informix-Query-Samples.aspx
Loading...