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:
You have logged in as a local Windows user on the computer from where you are deploying the report to a remote computer.
The user name that you specified in the Reporting Services Login dialog box to connect to the remote computer is qualified with the domain name. For example, the user name that was specified is ReportsServer\ReportsUser.
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:
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
Start Microsoft Visual Studio .NET 2003.
Create a new report project.
Add a new report to the report project by using the Report Wizard.
On the Project menu, click ReportProjectName Properties.
In the ReportProjectName Property Pages dialog box, type the URL of a remote report server in the TargetServerURL box, and then click OK.
On the Build menu, click Deploy ReportProjectName.
In the Reporting Services Login dialog box, type the user name by qualifying the user name with the domain name in the User name box. For example, the user name is ReportsServer\ReportsUser.
You may notice that the Reporting Services Login dialog box appears again.