ssrs 2008 deployment
-
hi all,
after I create a new report, I always struggle to deploy the report.
to start with, can you help me with reporting services configuration manager?
what's the difference btw WEB SERVER URL and REPORT MANAGER URL? can both be the same?
Where is my virtual directories for both?
After that, what should I need to key in to my RDL properties?
thanks!
P
-
after I create a new report, I always struggle to deploy the report.
to start with, can you help me with reporting services configuration manager?
I think you need a book but here is a link to get started print is out use it then post problems so I can help you.
http://technet.microsoft.com/en-us/library/cc304416.aspx
what's the difference btw WEB SERVER URL and REPORT MANAGER URL? can both be the same?
Report manager is for SSRS while the web server is for Asp.net.
Where is my virtual directories for both?
I am assuming you are talking about Asp.net default site and SSRS site, IIS adds the Asp.net default site to help web developers while SQL Server installer adds SSRS site to help SSRS developers.
After that, what should I need to key in to my RDL properties?
RDL is Microsoft proprietry XML used by SSRS and the only thing you do to deploy is copy all files including all associated solution files to report manager. This will get you started.
Kind regards,
Gift Peddie -
thanks for your prompt reply..
1. I got a book, but it keeps on telling me go to IE and type in:
I think my localhost is called: John-PC/mysqlinstance
My database instance is called: mysqlinstance
My questions are:
*** what will my ReportServer's name be?
*** what URL do I need to type in to get my reports on IE?
I only worry about SSRS, don't care abt .NET at all.
2. How can I copy all files to Report Manager?
Where is Report Manager locate in my PC by default??
3. In visual studio, report solution explorer, what should I type in for TargetServerURL under report's property tab?
many thanks
P
-
Hi,
http://localhost/ReportServer is the default report server URL.
To know the name of your report server go to Report Server Virtual Directory in Reporting Services Configuration Manager .
There you can find the name of the ReportServer.Then just type in http://yourLocalhostname/ReportServerName in IE.
To go to the report manager,type
http://localhost/Reports. This the default report manger URL .
To know the name of your report manager go to Report manager Virtual Directory in Reporting Services Configuration Manager .
There you can find the name of the ReportManager.Then just type in http://yourLocalhostname/ReportManagerName in IE.
In visual studio, report solution explorer, you need to type http://yourLocalhostname/ReportServerName which is nothing but the report server URL under report's property tab.
Hope this works for you.
Thanks,
Nemo
-
In visual studio, report solution explorer, I typed in TargetServerURL the following:
http://myLocalhostname/MyReportServerName
and leave TargetDataSourceFolder - empty
and leave TargetReportFolder - empty
but once I deployed the report, it pops up requesting user login and password, as usual and as always...
-
It usually occurs if the Report services is not configured during SSRS installation.
Go to IIS and try changing the authentication type in the Report Server and Reportmanager's Directory Security.
Am not sure if it works, just give it a try..
-
I think this is a very common problem, I searched on google, many users had similar experiences that is very difficult to deploy reports.
Is there any to deploy reports without user login authenticaton? it's just really annoy.
thanks Nemo
-
pilypala (9/17/2009)
In visual studio, report solution explorer, I typed in TargetServerURL the following:http://myLocalhostname/MyReportServerName
and leave TargetDataSourceFolder - empty
and leave TargetReportFolder - empty
but once I deployed the report, it pops up requesting user login and password, as usual and as always...
Does it prompt you when you deploy the report or does it prompt you when the report is ran from the website?
If it when you deploy them, does it also prompt you when to fill in the default datasources and report folders?
If it's when the report is ran, you need to set your user authentication in the data source for the report.
-
It prompts when I try to deploy the report from Visual Studio, that is I right click on the report name and click on "Deploy".
I am not 100% sure what are my default report source and folder. But when I deployed it, all three fields (report source, folder and targetURL) are filled.
Can you tell me what are the default report source and folder?
thanks
P
-
Hi, pilypala.
Maybe you can try RAQ Report[/url], for it provides a better integration solution.
RAQ Report provides integration as Jar package to programmers. Without independent report server, application infrastructure, and independent management mechanism of user permissions, RAQ Report can help programmers to implement integration conveniently. Its application architecture is shown below:
The advantages of no independent report server:
? The server of RAQ report is submitted as Jar package or application of application server. Therefore, it can get integrated with application program seamlessly to achieve the peak operating efficiency.
? Share the cluster capability and the management capability of connection pool of application server.
? Make unified deployment. Use the user role management mechanism of Web application directly to avoid the incompatible problem of two management mechanisms. Provide a unified login screen, and end users need not to log in twice.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply