Showing posts with label appears. Show all posts
Showing posts with label appears. Show all posts

Monday, March 19, 2012

Deploying SQL Express Throughout the Organization/Enterprise

What are some recommended methods for deploying SQL Express throughout an entire organization? It appears that Active Directory/GPO deployment is out of the equation.

Thanks,

Shane

hi Shane,

as SQLExpress is SQL Server, and as SQL Server is a service potentially serving lot's of user, SQLExpress is usually installed on a machine available through the whole lan.. all the clients connect to that instance and it answers to all the incoming requests... this is the "traditional" scenario of an enterprise wide database server...

what is your "problem"?

regards

|||

In our case SQL Express needs to be deployed to each PC because the product is used connected and disconnected to the network. Is there a documented or recommended method of deploying SQL Express to each PC?

Thanks,

Shane

|||

hi Shane,

a nice article has been written by Robert Walters including ClickOnce as well..

regards

|||

Andrea,

Thanks for the information. I have seen that article before and it is very good. We are using the ClickOnce bootstrapper but not actually using ClickOnce itself. What I am really looking for is recommendations on pushing SQL Express to PCs in an organization. Active Directory/GPO is commonly used for Windows Installer installations and while SQL Express is a Windows Installer installation under the hood it doesn't appear it would be practical and possibly not even possible to push it out this way. Is this a valid assessment? There are other electronic software delivery tools out there like SMS that may do the job, but we don't have experience with those tools. Would these tools be appropraite for pushing out SQL Express? Has anyone tried this successfully?

Thanks,

Shane

Friday, February 24, 2012

deploy reports to several subfolders

i have a reporting project which i want to deploy several reports into
several sub folders.
it appears not possible from the ui, and i found a few articles on the
web from 2004 suggesting it wasnt possible.
can anyone confirm if its still not possible?
thanks in advance
dbCan you deploy directly from Visual Studio to the server hosting Reporting
Services?
In that case, you organize your report solution in VS with more than one
project, and then give each sub-project a link to a subfolder of RS on the
server.
In your report solution, right click on the Solution, and click Add -> New
Project. Give the new project a descriptive name, and store it in a
subfolder of your solution. I usually have a sub project called "Dev", where
I put the development edition of each report, and a main project with the
finished reports.
When you have a sub project, right click this project and click Properties.
If your solution is called MyReports, and your server is called MyServer,
then
TargetServerURL : http://myserver/reportserver/
TargetReportFolder MyReports/Dev
When you deploy reports in the Dev (sub)project, they will be deployed to
http://myserver/reportserver/MyReports/Dev instead of
http://myserver/reportserver/MyReports/ .
You have to create Shared Data sources in your new project. You can copy the
existing ones, but I find that they sometimes loose the credentials, so you
just have to double check on them after having copied them.
Kaisa M. Lindahl Lervik
"bb" <barnseenio@.gmail.com> wrote in message
news:1158847587.230893.243740@.m73g2000cwd.googlegroups.com...
>i have a reporting project which i want to deploy several reports into
> several sub folders.
> it appears not possible from the ui, and i found a few articles on the
> web from 2004 suggesting it wasnt possible.
> can anyone confirm if its still not possible?
> thanks in advance
> db
>|||Thanks for the tip, but yes i was aware that i could create a different
project for each 'subfolder'. My problem is im using the report folders
to group the reports, as i want to leave all this metadata in SSRS
rather than creating database tables to describe reporting groups.
I have around 10 folders and within each one i have some subfolders, so
the project idea is a bit painful.
I think im going to write an app which can programmatically deploy
different rdls to different subfolders, which can be used by the
develoeprs to deploy their reports.
db
Kaisa M. Lindahl Lervik wrote:
> Can you deploy directly from Visual Studio to the server hosting Reporting
> Services?
> In that case, you organize your report solution in VS with more than one
> project, and then give each sub-project a link to a subfolder of RS on the
> server.
> In your report solution, right click on the Solution, and click Add -> New
> Project. Give the new project a descriptive name, and store it in a
> subfolder of your solution. I usually have a sub project called "Dev", where
> I put the development edition of each report, and a main project with the
> finished reports.
> When you have a sub project, right click this project and click Properties.
> If your solution is called MyReports, and your server is called MyServer,
> then
> TargetServerURL : http://myserver/reportserver/
> TargetReportFolder MyReports/Dev
> When you deploy reports in the Dev (sub)project, they will be deployed to
> http://myserver/reportserver/MyReports/Dev instead of
> http://myserver/reportserver/MyReports/ .
> You have to create Shared Data sources in your new project. You can copy the
> existing ones, but I find that they sometimes loose the credentials, so you
> just have to double check on them after having copied them.
> Kaisa M. Lindahl Lervik
>
> "bb" <barnseenio@.gmail.com> wrote in message
> news:1158847587.230893.243740@.m73g2000cwd.googlegroups.com...
> >i have a reporting project which i want to deploy several reports into
> > several sub folders.
> >
> > it appears not possible from the ui, and i found a few articles on the
> > web from 2004 suggesting it wasnt possible.
> >
> > can anyone confirm if its still not possible?
> >
> > thanks in advance
> >
> > db
> >|||OK, you might want to check out a post I wrote "Re: Use rs.exe to publish
ALL .rdl files in a folder"
Sent to this newsgroup on sept 18. I wrote a script that extends the sample
script to publish reports.
Also, you might want to check out Reporting Services Scripter 2.0.0.2, might
give you some tips on how to do things with scripts as well.
Kaisa M. Lindahl Lervik
"bb" <barnseenio@.gmail.com> wrote in message
news:1158913333.694125.327440@.k70g2000cwa.googlegroups.com...
> Thanks for the tip, but yes i was aware that i could create a different
> project for each 'subfolder'. My problem is im using the report folders
> to group the reports, as i want to leave all this metadata in SSRS
> rather than creating database tables to describe reporting groups.
> I have around 10 folders and within each one i have some subfolders, so
> the project idea is a bit painful.
> I think im going to write an app which can programmatically deploy
> different rdls to different subfolders, which can be used by the
> develoeprs to deploy their reports.
> db
>
> Kaisa M. Lindahl Lervik wrote:
>> Can you deploy directly from Visual Studio to the server hosting
>> Reporting
>> Services?
>> In that case, you organize your report solution in VS with more than one
>> project, and then give each sub-project a link to a subfolder of RS on
>> the
>> server.
>> In your report solution, right click on the Solution, and click Add ->
>> New
>> Project. Give the new project a descriptive name, and store it in a
>> subfolder of your solution. I usually have a sub project called "Dev",
>> where
>> I put the development edition of each report, and a main project with the
>> finished reports.
>> When you have a sub project, right click this project and click
>> Properties.
>> If your solution is called MyReports, and your server is called MyServer,
>> then
>> TargetServerURL : http://myserver/reportserver/
>> TargetReportFolder MyReports/Dev
>> When you deploy reports in the Dev (sub)project, they will be deployed to
>> http://myserver/reportserver/MyReports/Dev instead of
>> http://myserver/reportserver/MyReports/ .
>> You have to create Shared Data sources in your new project. You can copy
>> the
>> existing ones, but I find that they sometimes loose the credentials, so
>> you
>> just have to double check on them after having copied them.
>> Kaisa M. Lindahl Lervik
>>
>> "bb" <barnseenio@.gmail.com> wrote in message
>> news:1158847587.230893.243740@.m73g2000cwd.googlegroups.com...
>> >i have a reporting project which i want to deploy several reports into
>> > several sub folders.
>> >
>> > it appears not possible from the ui, and i found a few articles on the
>> > web from 2004 suggesting it wasnt possible.
>> >
>> > can anyone confirm if its still not possible?
>> >
>> > thanks in advance
>> >
>> > db
>> >
>