Why this 401 error?


  • I generate a ATOMSVC file from  Reporting Services and save it to my desktop and when I try
    to import into PowerPivot Excel I get the "The remote server returned an error: (401) Forbidden."
    error in the Table Import Wizard.

    I have the proper authentication information for the datasource (in fact in a previous step of the wizard, the test connection succeeds).
    The ATOMSVC file has the proper security information.
    The Excel 2010 security is set correctly.
    Feed wizard's Advanced Settings have the USER/PASSWORD Information.

    Where is the problem?

    Windows 7 Ultimate 32 Bit

    • Edited by Jayaram KrishnaswamyEditor Wednesday, June 02, 2010 8:50 PM 403 changed to 401
    • Moved by Vikram JayaramMicrosoft employee Thursday, June 03, 2010 4:30 PM Moving to the regular SQL forums now that SQL 2008 R2 has RTM'ed. the Beta forums are just for TAP customers and for customers still on CTP3 and RC builds (From:SQL Server 2008 R2 PowerPivot for Excel)
    Wednesday, June 02, 2010 8:26 PM