Deployment and Configuration

I have several clients using several SQL server databases that have all been
setup on one machine which they access remotely using terminal services. Each
client has their own software installation with their own set of databases.
So, there would be many client installations on the same machine. How would i
setup reporting services so that each client has their own set of reports?
How would i go about deploying the reports for each client given that the
clients' databases would have different names and hence the connection
strings will be different? Please help!
regardsSet up a datasource for each client - unless you have hundreds, in which case
I am not sure.sql

Deploying a report to remote server

I would like to develop a report remotely for a customer, and then
deploy it on their intranet at their location. Basically all
development is
off-site, and I will travel onsite to install the completed SRS report.
They
do not have a licensed copy of Visual Studio .NET, so none of the
development/maintenance will be done on their server. When I go to
install
SRS on their server, I will only install the Server components, not the
client components. With that said, how do go about getting the actual
report
installed / deployed on their server? I can do it locally on my
development
box using "deploy" from within VS.NET, but how do I do it "manually" on
a box
without VS.NET? What report "files" do I need to copy from my machine,
and
what needs to be setup in IIS?
Thanks
VikramYou can use report manager to deploy a rdl file (if you don't have a lot
this would be the easiest to do.
Or you can script the deploy. You don't have to have a 3rd party tool for
this but here is a free one from Jasper Smith a SQL Server MVP.
Reporting Services Scripter
http://www.sqldbatips.com/showarticle.asp?ID=62
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<vikram.sattenapalli@.gmail.com> wrote in message
news:1140556432.452749.103260@.o13g2000cwo.googlegroups.com...
> I would like to develop a report remotely for a customer, and then
> deploy it on their intranet at their location. Basically all
> development is
> off-site, and I will travel onsite to install the completed SRS report.
> They
> do not have a licensed copy of Visual Studio .NET, so none of the
> development/maintenance will be done on their server. When I go to
> install
> SRS on their server, I will only install the Server components, not the
> client components. With that said, how do go about getting the actual
> report
> installed / deployed on their server? I can do it locally on my
> development
> box using "deploy" from within VS.NET, but how do I do it "manually" on
> a box
> without VS.NET? What report "files" do I need to copy from my machine,
> and
> what needs to be setup in IIS?
> Thanks
> Vikram
>|||Thanks a lot for the quick response. I will try using the third party
tool and see if i can actually generate the script :)
Vikram

deploy Service pack remotely

How can we deploy SP3a remotely on all our SQL servers ? Is this doable ? Is
there step by step instructions on how to do so and also verify remotely
once completed that it was successful
ThanksI suppose SMS could do this.
You might also try software policies for the Operating System... For
Software policy, that would be doc'c with the operating system and not SQL..
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.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
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O4Dom6RyDHA.560@.TK2MSFTNGP11.phx.gbl...
> How can we deploy SP3a remotely on all our SQL servers ? Is this doable ?
Is
> there step by step instructions on how to do so and also verify remotely
> once completed that it was successful
> Thanks
>|||By the way, you might also try a login script which runs the setup...
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.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
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:O4Dom6RyDHA.560@.TK2MSFTNGP11.phx.gbl...
> How can we deploy SP3a remotely on all our SQL servers ? Is this doable ?
Is
> there step by step instructions on how to do so and also verify remotely
> once completed that it was successful
> Thanks
>