report in asp.net

[Aleks Kleyn]

I install on my Vista 64 bit PC Sql Server 64 bit latest release. Using
busines inteligent studio i prepared report. this report works fine in
studio environment. Next step I deployed this report to report server. I
used target server url= http://localhost/reportserver.
1. However when I run IIS I do not see such folder there. when I go to this
url I get error

Description: An error occurred while accessing the resources required to
serve this request. You might not have permission to view the requested
resources.

Error message 401.3: You do not have permission to view this directory or
page using the credentials you supplied (access denied due to Access Control
Lists). Ask the Web server's administrator to give you access to 'C:\Program
Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting
Services\ReportManager\home.aspx
------
How this works,

2. When I go to asp.net there I see control rsweb:ReportViewer.
2a. this control demanded from me to add code
<add verb="*" path="Reserved.ReportViewerWebControl.axd" type =
"Microsoft.Reporting.WebForms.HttpHandler, Microsoft.ReportViewer.WebForms,
Version=9.0.0.0, Culture=neutral, PublicKeyToken=....." />
into web.config into httpHandlers.
but i am not sure if this is enough

2b. when I add code <ServerReport ReportPath="..."/> it responds me that
RSClientController' is undefined

2c. then I changed to <LocalReport ReportPath=".."></LocalReport>
Then I got responce
The definition of the report 'Main Report' is invalid.
The report definition is not valid. Details: The report definition has an
invalid target namespace
'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition'
which cannot be upgraded.

The question is how I can see this report.

--

Aleks Kleyn
http://www.geocities.com/aleks_kleyn

[Norman Yuan]

You need a bit more study on what is SQL Server reporting services. When you
install SQL Server2005, you have chance to choose install Reporting Services
or not. If you do, you must have IIS installed before hand.

If you did installed Reporting Services, you could open IIS Manager to
verify it: underneath "Default Web Site", you should see two virtual
directories(applications): Reports and ReportServer (they may suffixed with
"$ServerName", if your SQL Server is a named instance);

If the Reporting Services did get installed, then you should be able to
browse to its Report Manager by this address:
http://localhost[servername]/reports. Of course you need to configure the
reproting services and/or IIS to give access permission: Reporting Services
are just a regular ASP.NET application.

Once you have the proper access to Report services, you can then deploy your
report designed in VS.

"Aleks Kleyn" <Aleks...@MailAps.org> wrote in message
news:F2D6D915-40F2-400A...@microsoft.com...

[Aleks Kleyn]

I do not think you read careful my email before claim that I did not learn
something. However back to subject.

This is not sql 2005, but sql 2008, and may be MS has still there some bugs.
Here possible two options.

MS makes visible report server only to specific user (then for which user)
or they forgot to add this folder to IIS at all.
Then again. If I create this folder I need properly show them to real folder
(assume I know where) and to give proper permitions (this is more harder).
And again. if this folder does not exist at all how it possible that I
deployed succesfully.

--

Aleks Kleyn
http://www.geocities.com/aleks_kleyn

"Norman Yuan" <Fake...@FakeEmail.Not> wrote in message
news:%23bPyPON...@TK2MSFTNGP06.phx.gbl...

[Aleks Kleyn]

I still not have answer to this questions. Searching on other forums I found
next responce

t sounds like you are using the VS 2008 report viewer control (which is
still based on the 2005 RDL namespace) in local mode and you try to run a RS
2008 RDL with it.

This is not supported. The VS 2008 report viewer control can only run
2000/2005 RDLs, but not 2007/2008 RDLs.

There are plans to release an updated report viewer control after RS 2008
RTM is released. The updated report viewer control includes the new
processing and rendering engine that ships in RS 2008 and will work with all
versions of RDL (2000, 2005, 2007/2008). However, the exact timing for an
updated report viewer release is not determined at this point.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3234546&SiteID=1

--

Aleks Kleyn
http://www.geocities.com/aleks_kleyn

"Norman Yuan" <Fake...@FakeEmail.Not> wrote in message
news:%23bPyPON...@TK2MSFTNGP06.phx.gbl...

[Aleks Kleyn]

research shows that to define namespace for report we need code

<Report
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner"
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">

The year 2008 can be changed to 2005 and this will be namespace for report
2005. Site

http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition

exist, but site

http://schemas.microsoft.com/sqlserver/reporting/208/01/reportdefinition

yet not ready and first link is not good for report 2008.

I can understand this. however this is not clear why browsing of report
should depend on Microsoft web site. tomorow will be power down in Redmond
for a week. As result people will not be able to see reports. For a lot of
applications report is core. the question is not when Microsoft will be
ready to provide report, but how is reliable his product.

[Jayaram Krishnaswamy]

Reports with extension rdlc can be published to the Local web server(IIS). By
default this port is 80. If a Report Server(2008) is configured on the same
machine (unless it is Windows 2003, I am not sure how it is with Vista) it
has to use a different port. From the messages you show it appears that you
did deploy it to the Report Server and in this case your IIS will not show
it.

To see if your report is deployed or not is to access your Report Server
perferably from the Configuration Manager Tool which in the case of SQL
Server 2008 will have configured it ready to go if you have chosen the native
mode. I have had no problem in deploying my
RDLC files to IIS Web Server
RDL files to the Report Server

I have discussed some of these on my blog,
http://hodentek.blogspot.com

mysorian

[Guerrero@discussions.microsoft.com Jaimir Guerrero]

Hi Aleks,
1. SQL 2005 use iis, SQL 2008 doesn't. SSRS is a windows service that opens
the port 80.
2. This problem is not about ReportViewer.
3. SSRS2008 need windows authentication for authorization of users to view
the reports and browse the web site.
4. SSRS 2008's web site is locate 'C:\Program Files\Microsoft SQL
Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager.
5. You need create a local security group with your Report´s users and
assign read & execute permission for this folder 'C:\Program Files\Microsoft
SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportManager.

Jaimir G.

[Martin@discussions.microsoft.com Jennifer Martin]

Thanks Jaimir, for the concise and accurate solution, as I had the same
issue. I think you are the only responder that actually understood the issue.

Jennifer