Showing posts with label login. Show all posts
Showing posts with label login. Show all posts

Friday, March 9, 2012

Reporting Service Login dialog when trying to deploy a report

I am using SQGExpress, and can open the home page at
http://localhost/reports, but after previewing a report, when I try to deploy
the report I get a dialog asking for for a user name and password.
1. why do i get this dialog, and
2, what is it expecting; I have tried all that I could think of, but have
found to reponse that is accepted
Thanks
--
TomGHave you allowed Anonymous Access to the Report Server web application? Then
RS won't know which user you are trying to be, and probably bans any
deployment.
Kaisa M. Lindahl Lervik
"TomG" <TomG@.discussions.microsoft.com> wrote in message
news:7FC9358C-9678-45E6-8957-048A1E2F52F9@.microsoft.com...
>I am using SQGExpress, and can open the home page at
> http://localhost/reports, but after previewing a report, when I try to
> deploy
> the report I get a dialog asking for for a user name and password.
> 1. why do i get this dialog, and
> 2, what is it expecting; I have tried all that I could think of, but have
> found to reponse that is accepted
> Thanks
> --
> TomG|||thanks for your response.
I do not know. I will have to find how to determine and/or change if need be.
will do some digging and repost
--
TomG
"Kaisa M. Lindahl Lervik" wrote:
> Have you allowed Anonymous Access to the Report Server web application? Then
> RS won't know which user you are trying to be, and probably bans any
> deployment.
> Kaisa M. Lindahl Lervik
>
> "TomG" <TomG@.discussions.microsoft.com> wrote in message
> news:7FC9358C-9678-45E6-8957-048A1E2F52F9@.microsoft.com...
> >I am using SQGExpress, and can open the home page at
> > http://localhost/reports, but after previewing a report, when I try to
> > deploy
> > the report I get a dialog asking for for a user name and password.
> >
> > 1. why do i get this dialog, and
> > 2, what is it expecting; I have tried all that I could think of, but have
> > found to reponse that is accepted
> >
> > Thanks
> > --
> > TomG
>

Saturday, February 25, 2012

Reporting Server 2005 Login issues

Have SQL Server 2005 September CTP
I am Local admin on box
Sysadmin in SQL Server
Installed reporting server. I used the BI Development Suite (VS) to build
reports. I ran the build with no issues than deployed the reports to the
server successfully. I can log in and view the reports from IE on the server
itself. They show up fine. The security is set to windows in reporting
server. When I attempt to view the report from my workstation I get the
following error:
An error has occurred during report processing.
Cannot impersonate user for data source 'RemoteConnection'.
Logon failed.
For more information about this error navigate to the report server on the
local server machine, or enable remote errors
Again SQL Server 2005 Sept CTP. Any help would really be appreciated.In Report Manager, select the data source you are using in your
report. In the General tab you should see information about
credentials and other connection informaton relevant to the data
source. Have a careful look at all aspects of that, as a first step.
Andrew Watt
MVP - InfoPath
On Fri, 7 Oct 2005 10:07:04 -0700, "T Man"
<TMan@.discussions.microsoft.com> wrote:
>Have SQL Server 2005 September CTP
>I am Local admin on box
>Sysadmin in SQL Server
>Installed reporting server. I used the BI Development Suite (VS) to build
>reports. I ran the build with no issues than deployed the reports to the
>server successfully. I can log in and view the reports from IE on the server
>itself. They show up fine. The security is set to windows in reporting
>server. When I attempt to view the report from my workstation I get the
>following error:
>An error has occurred during report processing.
>Cannot impersonate user for data source 'RemoteConnection'.
>Logon failed.
>For more information about this error navigate to the report server on the
>local server machine, or enable remote errors
>
>Again SQL Server 2005 Sept CTP. Any help would really be appreciated.