Reporting Services and Directory Browsing?

If I use the URL 'http://my.rportingserver.com/ReportServer', I am presented
with a list of the directory contents, as if Directory Browsing were turned
on for the directory in IIS. At the bottom of the directory listing, is an
indication that this is a Reporting Services function:
Microsoft SQL Server Reporting Services Version 9.00.1314.00
Needless to say, Directory Browsing is turned off in InetMgr. What controls
this directory listing, and can it be turned off ?
Thanks !Report manager is the front for RS. So you will see a listing inspite of
turning off directory browsing. Basically to access all the reports it is
provided if you dont want the listing to be displayed, then remove the access
rights "Read" (I think it is browse) from the configuration.
Amarnath
"RJ" wrote:
> If I use the URL 'http://my.rportingserver.com/ReportServer', I am presented
> with a list of the directory contents, as if Directory Browsing were turned
> on for the directory in IIS. At the bottom of the directory listing, is an
> indication that this is a Reporting Services function:
> Microsoft SQL Server Reporting Services Version 9.00.1314.00
> Needless to say, Directory Browsing is turned off in InetMgr. What controls
> this directory listing, and can it be turned off ?
> Thanks !

Reporting Services 2005 on Vista

Hi All
When I go to http://localhost/reports on my laptop running Vista and SQL
Server Reporting Services 2005 SP2 I recive the following error:
HTTP Error 401.1 - Unauthorized
Description: You do not have permission to view this directory or page using
the credentials that you supplied.
Does anyone know how to resolve this?
Thanks
- DavidNot sure if this is to do with you having to be logged in to the machine as
Admin or someone with admin rights.
"David" wrote:
> Hi All
> When I go to http://localhost/reports on my laptop running Vista and SQL
> Server Reporting Services 2005 SP2 I recive the following error:
> HTTP Error 401.1 - Unauthorized
> Description: You do not have permission to view this directory or page using
> the credentials that you supplied.
> Does anyone know how to resolve this?
> Thanks
> - David
>|||I don't run Vista but here is a post I saved that might help you:
>>>>>
1) Control Panel / User Accounts / Turn User Account Control - off
2) run "%windir%\Microsoft.NET\Framework\version\aspnet_regiis.exe" -i
>>>>>>
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <David@.discussions.microsoft.com> wrote in message
news:90D7717A-5883-4EB8-BFDF-A97EE9E5FE40@.microsoft.com...
> Hi All
> When I go to http://localhost/reports on my laptop running Vista and SQL
> Server Reporting Services 2005 SP2 I recive the following error:
> HTTP Error 401.1 - Unauthorized
> Description: You do not have permission to view this directory or page
> using
> the credentials that you supplied.
> Does anyone know how to resolve this?
> Thanks
> - David
>

Reporting Services 2005 : The report server cannot open a connection to the report server databa

Hi,

I am getting the following error whenever I try to open the reportserver 2005 default web page

http://home/reportserver

Reporting Services Error
--
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

--
SQL Server Reporting Services

SQL SERVER 2005 DEVELOPER EDITION ERROR LOG
2006-01-24 17:54:52.65 Server The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.

REPORTING SERVICES 2005 ERROR LOG
aspnet_wp!runningjobs!15!1/24/2006-18:41:26:: e ERROR: Error in timer Running Requests DB : Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. > System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

SURFACE AREA CONFIGURATION TOOL
SQL Server 2005 -> Reporting Services -> Integrated Security hangs 60 seconds

Next, long error stack trace follows with a message near the beginning ...

The report server can not open a connection to the SQL Server database.

All of my instances are up and running.
All of my instances allow both Windows Authentication and SQL Server Authentication.
Each has an sa password. (They are all the same.) I have tested each and can connect to each instance.
All of my instances allow remote connections. I have up'ed the connection timeout to 60 seconds.

Any ideas?

Any place that I could look to find SQL Server 2005 Reporting Services database connection Troubleshooting documentation?

Thank you very much.

AIMDBA

This error sounds like reporting services cannot communicate to the reportservices database, which is just a standard sql server 2005 database. Are you hosting the database server and reporting services on the same physical machine?|||

JonM,

Yes, I am hosting SQL Server 2005 Developers Edition database edition and SQL Server 2005 Reporting Services Developer Edition reporting server on the same machine. I just went through the regular install.

Any directions to try to start debugging this problem?

AIMDBA

|||The first thing to do is to go the 'Reporting Services Configuration Manager' Please make sure there is a green check mark next to everything (except encryption keys and execution accounts). Many common problems can be diagnosed here. Specifically make sure the 'Database Setup' looks correct.|||

Yes,

The SQL Server 2005 Developer Edition Report Server and the SQL Server 2005 Developer Edition Database Server are on the same machine.

I also did the following ...

Went into Report Server configuration ...

Set and Tested the login creditions to be

SQL Server Credentials

.

SA

password

I used a . for the local database. That all worked fine.

Next, I changed the Execution Account to be .\Administrator.

That seems O.K.

Next, I changes the Reporting Services Service to run under .\Administrator.

I shut down and restarted everything.

When I do : http://localhost/reportserver

Now, I get a new message:

Reporting Services Error

---

The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. (rsAccessDeniedToSecureData) Get Online Helpsql

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
>

Reporting service 400 bad request error

I have my reporting services installed on a Windows 2003 server. I have my Http://localhost/RepsortServer file directory opens fine.

However, I get this error when I try to access http://localhost/Reports.

Error

The request failed with HTTP status 400: Bad Request. Home

HELP

Any red X shows up when you open the configuration tool? Do you reportserver and reports vdirs live in the same application pool?

Try to recreate the report manager virtual directory using the configuration tool.

Reporting off ADO.NET datasets

hi,

I am trying to implement this:
http://blogs.msdn.com/bimusings/archive/2006/03/24/560026.aspx

my web service seems to work because i can view the data in the page when i invoke the public web method i created.

i'm trying to retreive the data and use it as the dataset in a report. this is my query string:
<Query>

<ElementPath IgnoreNamespaces="True">
GiveMeDataResponse {}/
GiveMeDataResult/diffgram{}/
Results {}/Table {CompanyID, CompanyName, ABN, Abbreviation}
</ElementPath>

<SoapAction>
http://tempuri.org/GiveMeData
</SoapAction>
<Method Namespace="http://tempuri.org/"
Name="GiveMeData">
</Method>
</Query>

When i try to run the query, it returns my four columns, but there is no data in the columns. it just returns one empty row.

what am i doing wrong?i don't know what i was doing wrong, but i got the example working.

But now i have a new problem and was hoping someone can help me?

I'm still following this example:
http://msdn2.microsoft.com/en-us/library/aa337489.aspx

I've changed the web method to return a dataset that has a datatable added to it. here is my code:

DataSet ds = new DataSet("Results");

DataTable dt = new DataTable("Results");

dt.Columns.Add("FirstName");
dt.Columns.Add("LastName");
dt.Columns.Add("Address");
dt.Columns.Add("City");
dt.Columns.Add("State");
dt.Columns.Add("PhoneNumber");

DataRow row = dt.NewRow();
row["FirstName"] = "Bob";
row["LastName"] = "The Builder";
row["Address"] = "10 My Street";
row["City"] = "Sydney";
row["State"] = "NSW";
row["PhoneNumber"] = "123456";
dt.Rows.Add(row);

ds.Tables.Add(dt);

return ds;

the query in Reporting Services doesn't return any data. It doesn't throw an error, it just returns one empty row.

Thanks for your help.