Article ID: 842517
Article Last Modified on 6/22/2004
APPLIES TO
- Microsoft SQL Server 2000 Reporting Services
SYMPTOMS
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.
RESOLUTION
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
WORKAROUND
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.
STATUS
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.
MORE INFORMATION
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
ReportProjectNameProperties. - In the
ReportProjectNameProperty 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. - Click OK.
You may notice that the Reporting Services Login dialog box appears again.
Keywords: kbfix kblogin kbuser kbdesigner kbsecurity kbreport kbauthentication kbdeployment kbsqlserv2000rssp1fix KB842517
