Reporting Server 2005 Login issues -- sql server reporting services

T Man
10/7/2005 10:07:04 AM

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.

Andrew Watt [MVP - InfoPath]
10/7/2005 9:43:44 PM

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"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Reporting Server 2005 Login issues