October 23, 2009 at 12:54 pm
As part of a server migration, I recently installed a new version of SQL Server 2005 SP3 with Reporting Services 2005 on another server. I used the attach/detach method to move the ReportServer and ReportServerTempDB databases to the new server. I backed up and restored the Reporting Services key from the old database and restored it to the new database. I used the "default" factory settings for the website creation.
When I connect to Reporting Services from SQL Server Management Studio 2005 from any computer (localhost or personal desktop computer), I get the following error:
The requrest failed with HTTP status 407: Proxy Authentication Required. (Microsoft.SqlServer.Management.UI.RSClient)
I am a computer administrator on the new server. I am able to log into the Reporting Services website (http://localhost/reports) without any problems with my active directory credentials.
How do I go about fixing/troubleshooting this connection problem?
October 23, 2009 at 3:03 pm
As part of a server migration, I recently installed a new version of SQL Server 2005 SP3 with Reporting Services 2005 on another server. I used the attach/detach method to move the ReportServer and ReportServerTempDB databases to the new server. I backed up and restored the Reporting Services key from the old database and restored it to the new database. I used the "default" factory settings for the website creation.
The migration process require backup and restore of ReportServerDB and ReportServerTempDB instead of the datasource db so you need to print out the link below and use the very detailed instructions to fix what you missed in your very simple migration plan.
http://msdn.microsoft.com/en-us/library/ms143724(SQL.90).aspx
Kind regards,
Gift Peddie
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply