Unable to Access SQL Reporting Services using Server Name

A recent installation of SQL Reporting Services installed successfully but then when testing the site, no matter how the Reporting Services Configuration Manager was configured, the Reporting Manager could not be access using the server name. I couldn’t even connect to the database engine using the server name in Management Studio. Then I remembered something.

I remembered that sometimes, this issue can be resolved by commenting out the line in the reportserver.config file that shows <RSWindowsNegotiate>. After commenting this out and restarting the Reporting Service, I was able to not only get to the Reporting Manager, but I was also able to connect to the database using the server name in Management Studio.

Leave a Reply