Hi I've just installed Full SQL 2005, however after I've configured Reporting Services I can't seem to access it.
When I go to http://localhost/reports I get this prompt for a username and password and no mather what I put there it fails with 401.1 Access Denied.
I've disabled kerberos on Reports and ReportServer virtual directories, nothing changed.
I've enabled anonymous auth and got: Internet Explorer cannot display the webpage.
When I access from another machine, I get the user and password prompt only once and get the same error.
If I try to access with Management Studio i get this error:
TITLE: Microsoft SQL Server Management Studio
The underlying connection was closed: An unexpected error occurred on a receive. (Microsoft.SqlServer.Management.UI.RSClient)
ADDITIONAL INFORMATION:
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)
An existing connection was forcibly closed by the remote host (System)
BUTTONS:
OK
Server is Win 2003 R2 Standard with IIS 6
UPDATE: Reporting Services Configuration Manager is all green, I've configured it completely, all accounts are domain accounts, the SQL database server is the same server, the databases are created successfully, if I add a index.html page on Reports virtual directory (directory) I can access it normally (with integrated security enabled).
UPDATE2: I've re-downloaded SQL 2005 from microsoft site. Uninstalled, deleted the remaining folders, Re-installed and I'm still stuck with the same error. I got the KRB_AP_ERR_MODIFIED Kerberos Error on System eventviewer after I reinstalled...
UPDATE3: I've downloaded SQL 2005 SP3 and have applied it to SQL, and still have the same problem. I also noted that on Surface Area Configuration when I click Reporting Services Feature Windows Integrated Security I get this error:
TITLE: Surface Area Configuration
The underlying connection was closed: An unexpected error occurred on a receive. (SQLSAC)
ADDITIONAL INFORMATION:
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)
An existing connection was forcibly closed by the remote host (System)
BUTTONS:
OK
I Found this link relating the above error and will try to reinstall IIS.
Can't seem to understand this. Does anyone have a hint?
UPDATE 4: Solved reinstalling IIS with the correct files (thank god SQL 2008 doesn't use IIS anymore).