Deployment of Server Reports

HI,
We have Server Reports in our application deployed on the Report
Server(local host). What all steps need to be done when we make an MSI of the
project for deplying reports on the new server? Do we need to first deploy
the reports on new server and then make an MSI? Need help.
Thanks in Advance.
ParimalYou do not/cannot use MSI to deploy reports. There are three ways to deploy
reports.
1. Use the IDE to deploy reports to production server (that is what I do).
2. Copy reports to server and then use Report Manager to add reports
3. Write a script. Search Books Online under scripting, samples
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Parimal" <Parimal@.discussions.microsoft.com> wrote in message
news:FC5A0A06-B81B-4183-83F4-98C4414A1B0A@.microsoft.com...
> HI,
> We have Server Reports in our application deployed on the Report
> Server(local host). What all steps need to be done when we make an MSI of
> the
> project for deplying reports on the new server? Do we need to first
> deploy
> the reports on new server and then make an MSI? Need help.
> Thanks in Advance.
> Parimal

Deployment files needed by sqlserver 2005 driver

Hello all

I built an application that connect to MS SqlServer2005 using Native driver (sqlncli.msi) I install that file from MS site, I need to deply my application to the end-user, and I would like to know what files do I need to deploy to make sure the application is gona run okay on the client PC's.

I search in the registry for the driver, and I found this "sqlncli.dll", is it enough or I need to include more files !!

Thanks and best regrdas

Waleed

SQLNCLI does not have specific dependencies, however your customers should have MDAC installed, which should be not a problem with the recent releases of Windows.

See also http://technet.microsoft.com/en-us/library/ms131334.aspx

Deploying SQL Database

Hi All,

Can anyone tell me,is it possible to create an exe or msi for sql stored procedures,tables and triggers?I want to deploy the database objects(stored proc,tables,views and functions) as an exe file..just like publishing and deploying the asp.net application.Is it possible for sql server database objects.Pls,let me know.

Thank U[:)]Usually database with all objects gets backed up and then restored on another Server. It is the best and safest way to do it.

You also can extract scripts of all objects and then run them on another Server using exe or any means which can connect to that Server.

Good Luck.

Deploy SQL Server Management Studio

Hello,

I need to deploy Server Management Studio by Active directory and I will like to know where I can find the MSI do it. (I didn't find it on the CD)

Thank you for your help

There is no separate msi file for SQL Server 2005 Management Studio. Instead, SQL Server Management Studio is packed in SqlRun_Tools.msi under tools directory.

deploy management studio to users

is there a way to deploy only the workstation tools? Can I create an msi or
sms package to install only the tools I need for users to have? Can I lock
down the interface so all options are greyed out other than workstation tools?
There are several different ways that you can do this all made super easy by
SQL 2005.
I dont need to waste my time writing the steps since someone wrote a really
nice blog...
http://www.databasejournal.com/featu...le.php/3611426
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
Tech Blog - www.technologyis.com
*/
"vision" <vision@.discussions.microsoft.com> wrote in message
news:9A3263B3-DA01-4DF8-B23A-142B6094F095@.microsoft.com...
> is there a way to deploy only the workstation tools? Can I create an msi
> or
> sms package to install only the tools I need for users to have? Can I
> lock
> down the interface so all options are greyed out other than workstation
> tools?
>
|||thanks, I found that and followed the steps. the only thing is it also
installs configuration manager. we only want to install management studio.
I tried removing all except for sql tools and still the same result
thanks for your time.
"Warren Brunk" wrote:

> There are several different ways that you can do this all made super easy by
> SQL 2005.
> I dont need to waste my time writing the steps since someone wrote a really
> nice blog...
> http://www.databasejournal.com/features/mssql/article.php/3611426
>
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> Tech Blog - www.technologyis.com
> */
>
> "vision" <vision@.discussions.microsoft.com> wrote in message
> news:9A3263B3-DA01-4DF8-B23A-142B6094F095@.microsoft.com...
>
>