Microsoft KB Archive/842517

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

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  \ .



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 &quot;Applies to&quot; section. This problem was first corrected in Microsoft SQL Server 2000 Reporting Services Service Pack 1.



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   Properties.
 * 5) In the   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  .
 * 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  \ .
 * 8) 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.