Showing posts with label sysadmin. Show all posts
Showing posts with label sysadmin. Show all posts

Friday, March 30, 2012

Reporting services access problem !!!!!!!

Hi ..

I am facing a peculiar problem ... We have Sql Server 2005 reporting services installed on our server ...unfortunately our sysadmin by mistake has reinstalled the IIS on the server due to which the report server is not accessible .. The sql server is working fine no problem ..

normally we used to give .. http://domainname/reports and all the reports will be shown.

Now how do i reinstate the settings of the IIS ... for the Reporting services.

Could anybody suggest some ideas ...

Rgds

Chandru

Should be able to run the Reporting Services configuration, and just re-set the Virtual Directories and the Web Service Identity.|||

Ya .. thats ok .. But what is the virtual directory mappings i should give in IIS for the Team Foundation Server ....

Kindly enlighten me on this ....

|||

In your Configuration settings stop the report server. Then restart IIS, then restart the report server. This may or may not work but is worth a try

sql

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.