Help and Support

Article ID: 842517 - Last Review: June 22, 2004 - Revision: 1.1

FIX: The Reporting Services Login dialog box appears repeatedly when you deploy a report on a remote computer by using Report Designer

View products that this article applies to.

On This Page

Expand all | Collapse all

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.
Back to the top

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  (http://support.microsoft.com/kb/842440/ ) How to obtain the latest service pack for SQL Server 2000 Reporting Services
Back to the top

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.
Back to the top

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.
Back to the top

MORE INFORMATION

Steps to reproduce the behavior

  1. Start Microsoft Visual Studio .NET 2003.
  2. Create a new report project.
  3. Add a new report to the report project by using the Report Wizard.
  4. On the Project menu, click ReportProjectName Properties.
  5. In the ReportProjectName Property Pages dialog box, type the URL of a remote report server in the TargetServerURL box, and then click OK.
  6. On the Build menu, click Deploy ReportProjectName.
  7. 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.
  8. Click OK.

    You may notice that the Reporting Services Login dialog box appears again.
Back to the top
APPLIES TO
  • Microsoft SQL Server 2000 Reporting Services
Back to the top
Keywords: 
kbsecurity kbuser kblogin kbdeployment kbauthentication kbreport kbdesigner kbsqlserv2000rssp1fix kbfix KB842517
Back to the top

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations