Link to home
Start Free TrialLog in
Avatar of scottsanpedro
scottsanpedro

asked on

Moving ReportServer : The request failed with HTTP status 401: Unauthorized

     
Hi,
I am in the process of moving reportserver and reportmanager from one server to another due to upgrade. SQL Server remains in the same place.
I am getting the above error when trying to conenct to my reportmanger
https://reportshare.thegmcgroup.local/reports
I have SSL set up using SELFSSL.exe
I can access the lisy of report vis
https://reportshare.thegmcgroup.local/reportserver
BUT get the error when trying the previous URL

Any ideas?

SQL Server 2005
Windows 2003 Server
All SP added and up to date.
Avatar of James Murrell
James Murrell
Flag of United Kingdom of Great Britain and Northern Ireland image

a friend had this once... he ended up having to  reinstall the entire SQL Server environment to get rid of error and have the reports display properly.
401 error

would you have a proxy on your network by any chance?
if you do, consider creating rules to allow users to ignore the proxy for internal networks.

also check how users are suppose to be identified to reporting services, it is normally AD, and check if there is a connection between them.

see if that helps.
Avatar of scottsanpedro
scottsanpedro

ASKER

Yes we have a proxy, and users are bypassed through Lan Settings on IE.
I can revert back to the original install on \\REPORTSERVER and conenct no problems to all the reports. As soon as I stop that services and initiate the new service on \\REPORTSHARE I get the 401 error.
I have backed up the Encryption Key from the old server and cleared out any reference via RSKeyMgmt on new install. Then restored the old key. BTW this doesn't seem to change anything when listing the keys on RSKeyMgmt -l  !
The encryption must be working because I can access the reports if I go via  https://reportshare.thegmcgroup.local/reportserver
Must be a permissions problem somewhere.
ASKER CERTIFIED SOLUTION
Avatar of scottsanpedro
scottsanpedro

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Done
Closed, 200 points refunded.
Vee_Mod
Community Support Moderator