Wednesday, March 7, 2012

ReportingServer Path (Url)

Hello
I develop my reports local on my pc (VS2003, IIS5, SQL Server 2000 and
ReportingServer are on the same Pc) and when i be finish then i want
transfer the reports to official ReportingServer.
Now my question witch files must transfer to the ReportingServer? And when i
transfer the files to another server then i think i must change the
ReportingServer-Path, how can do that? I see that i can change the path in
the VS-Project-Code, but can i do that purhaps with a Config-File or at real
time?
Thank you very much
Regards
RogerIf you are talking about reports ONLY , then the .RDL file is the only file
which must be transferred...
A common method is to use the Web interface on the production server to
UPLOAD the RDL files. That way you do not have to change anything on your
test side...Just tell the production guy where the RDL is.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"R.Odermatt" <roger.odermatt@.nospam.swica.ch> wrote in message
news:uME3TRi%23EHA.1544@.TK2MSFTNGP11.phx.gbl...
> Hello
> I develop my reports local on my pc (VS2003, IIS5, SQL Server 2000 and
> ReportingServer are on the same Pc) and when i be finish then i want
> transfer the reports to official ReportingServer.
> Now my question witch files must transfer to the ReportingServer? And when
i
> transfer the files to another server then i think i must change the
> ReportingServer-Path, how can do that? I see that i can change the path in
> the VS-Project-Code, but can i do that purhaps with a Config-File or at
real
> time?
> Thank you very much
> Regards
> Roger
>|||The only issue deployment might give you is if you have used jump to url
action. Otherwise everything is handled for you. Install your production
server, then from the the development environment you set the
TargetServerURL (you can have multiple configuration, for instance I have a
debug server and a production server). To set the TargetServerURL you do a
right mouse click on the project in your solution explorer, properties.
Then you deploy from the IDE (you can also script this but using the Visual
Studio is easiest). It deploys the data sources as well and after deployment
you might need to configure them at the server. After deploying once VS does
not overwrite the data sources, it just warns, so once you setup the data
sources on your production server they will not get overwritten.
Be sure to read up on how to setup security as well on the production
server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"R.Odermatt" <roger.odermatt@.nospam.swica.ch> wrote in message
news:uME3TRi%23EHA.1544@.TK2MSFTNGP11.phx.gbl...
> Hello
> I develop my reports local on my pc (VS2003, IIS5, SQL Server 2000 and
> ReportingServer are on the same Pc) and when i be finish then i want
> transfer the reports to official ReportingServer.
> Now my question witch files must transfer to the ReportingServer? And when
i
> transfer the files to another server then i think i must change the
> ReportingServer-Path, how can do that? I see that i can change the path in
> the VS-Project-Code, but can i do that purhaps with a Config-File or at
real
> time?
> Thank you very much
> Regards
> Roger
>

No comments:

Post a Comment