Article ID: 842517 - View products that this article applies to.
When you try to deploy a report by using Report Designer on a remote computer that is running Microsoft SQL Server 2000 Reporting Services, you may not be able to deploy the report successfully. You may notice that the Reporting Services Login dialog box that prompts the user to enter the connection credentials appears repeatedly. This behavior occurs even if you provide a valid user name and password for authentication. This problem may occur if all the following conditions are true:
To resolve this problem, obtain the latest service pack for SQL Server 2000 Reporting Services. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/842440/ )How to obtain the latest service pack for SQL Server 2000 Reporting Services
To work around this problem, when you deploy a report on a remote computer that is running SQL Server 2000 Reporting Services, specify the user name but do not qualify the user name with the domain name in the Reporting Services Login dialog box.
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft SQL Server 2000 Reporting Services Service Pack 1.
Steps to reproduce the behavior
Article ID: 842517 - Last Review: June 22, 2004 - Revision: 1.1