Deploying Report application question

I've finally got a report project (2005) finished and I'd like to 'deploy'
it
I've set up a website on a network server (with IIS running). Then, I set up
the targetSiteURL to that url - but I get the dreaded error message:
"A connection could not be made to the report server...(url)"
Maybe I misunderstood - I thought I was deploying the project as a web app,
so all I'd need was a working website directory.
What am I missing?You've missed a critical part. You are deploying to Reporting Services.
Reporting Services is a asp.net application. You do need IIS but when you
install reporting services it will create the two websites it uses. When you
deploy your report VS uses webservices to send the report, the data sources,
etc to reporting services. It then stored the report definition in the
database. No rdl exists as a file on the server.
Reporting Services also ships with a portal called Report Manager that is
used for managing roles and other admin tasks as well as providing a portal
for users (if you want to use it, that is all I use but some people create
their own web front end).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Elmo Watson" <sm@.here.com> wrote in message
news:%23TJgNJiUIHA.4880@.TK2MSFTNGP03.phx.gbl...
> I've finally got a report project (2005) finished and I'd like to 'deploy'
> it
> I've set up a website on a network server (with IIS running). Then, I set
> up the targetSiteURL to that url - but I get the dreaded error message:
> "A connection could not be made to the report server...(url)"
> Maybe I misunderstood - I thought I was deploying the project as a web
> app, so all I'd need was a working website directory.
> What am I missing?
>
>|||Thanks - next question is, how do I install Reporting Services on the other
server, so that it will create the two websites?
Can I do it remotely, through Business Management Studio, or does it need to
be done with a CD on that server?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23JJArQiUIHA.1164@.TK2MSFTNGP02.phx.gbl...
> You've missed a critical part. You are deploying to Reporting Services.
> Reporting Services is a asp.net application. You do need IIS but when you
> install reporting services it will create the two websites it uses. When
> you deploy your report VS uses webservices to send the report, the data
> sources, etc to reporting services. It then stored the report definition
> in the database. No rdl exists as a file on the server.
> Reporting Services also ships with a portal called Report Manager that is
> used for managing roles and other admin tasks as well as providing a
> portal for users (if you want to use it, that is all I use but some people
> create their own web front end).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Elmo Watson" <sm@.here.com> wrote in message
> news:%23TJgNJiUIHA.4880@.TK2MSFTNGP03.phx.gbl...
>> I've finally got a report project (2005) finished and I'd like to
>> 'deploy' it
>> I've set up a website on a network server (with IIS running). Then, I set
>> up the targetSiteURL to that url - but I get the dreaded error message:
>> "A connection could not be made to the report server...(url)"
>> Maybe I misunderstood - I thought I was deploying the project as a web
>> app, so all I'd need was a working website directory.
>> What am I missing?
>>
>|||Business Management Studio is just for the development of the reports. As
you have seen you can develop reports without the server.
You need to get the media for SQL 2005 and install Reporting Services from
that. Besides IIS it also needs a database server somewhere. It creates two
databases that it uses for its metadata/object caching. The databases can
either be on the same box or a different box. Also, the DB can be either
2000 or 2005 for Reporting Services 2005. However, when installing RS 2005
you need a license for SQL 2005 even if you use SQL 2000 as your data store.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Elmo Watson" <sm@.here.com> wrote in message
news:u7MvKciUIHA.5264@.TK2MSFTNGP02.phx.gbl...
> Thanks - next question is, how do I install Reporting Services on the
> other server, so that it will create the two websites?
> Can I do it remotely, through Business Management Studio, or does it need
> to be done with a CD on that server?
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23JJArQiUIHA.1164@.TK2MSFTNGP02.phx.gbl...
>> You've missed a critical part. You are deploying to Reporting Services.
>> Reporting Services is a asp.net application. You do need IIS but when you
>> install reporting services it will create the two websites it uses. When
>> you deploy your report VS uses webservices to send the report, the data
>> sources, etc to reporting services. It then stored the report definition
>> in the database. No rdl exists as a file on the server.
>> Reporting Services also ships with a portal called Report Manager that is
>> used for managing roles and other admin tasks as well as providing a
>> portal for users (if you want to use it, that is all I use but some
>> people create their own web front end).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Elmo Watson" <sm@.here.com> wrote in message
>> news:%23TJgNJiUIHA.4880@.TK2MSFTNGP03.phx.gbl...
>> I've finally got a report project (2005) finished and I'd like to
>> 'deploy' it
>> I've set up a website on a network server (with IIS running). Then, I
>> set up the targetSiteURL to that url - but I get the dreaded error
>> message:
>> "A connection could not be made to the report server...(url)"
>> Maybe I misunderstood - I thought I was deploying the project as a web
>> app, so all I'd need was a working website directory.
>> What am I missing?
>>
>>
>

Deploying RDL and RDS to customer without Visual Studio

I was asked to design and deliver SQL Reporting Services reports to a
customer. The customer will not have Visual Studio on their network. I've
read that you can script the deployment of reports and shared datasources
using RS.EXE but have not been able to figure it out with the instructions in
the documentation.
Can anyone provide an example of how I would do this?I posted this message earlier today, but let me try one more time:
Why not use the upload file buttom of the Report Manager
(http://yourreportsite/reports) to do the deployment?
a) Upload the rdl;
b) Create the db connection manually again within the Report Manager.
Tao
"AdamB" wrote:
> I was asked to design and deliver SQL Reporting Services reports to a
> customer. The customer will not have Visual Studio on their network. I've
> read that you can script the deployment of reports and shared datasources
> using RS.EXE but have not been able to figure it out with the instructions in
> the documentation.
> Can anyone provide an example of how I would do this?|||I will do that for now, thanks. But I was hoping to create an ASP.Net
application where I could select an rdl or rds file and call the web service
to add the selected resource behind the scenes
"Tao Zuo" wrote:
> I posted this message earlier today, but let me try one more time:
> Why not use the upload file buttom of the Report Manager
> (http://yourreportsite/reports) to do the deployment?
> a) Upload the rdl;
> b) Create the db connection manually again within the Report Manager.
> Tao
>
> "AdamB" wrote:
> > I was asked to design and deliver SQL Reporting Services reports to a
> > customer. The customer will not have Visual Studio on their network. I've
> > read that you can script the deployment of reports and shared datasources
> > using RS.EXE but have not been able to figure it out with the instructions in
> > the documentation.
> >
> > Can anyone provide an example of how I would do this?|||Do you still require assistance regarding thiis topic. Have you tried
running the PublishSampleReports.rss script from the command window. Or have
you not reached that far as yet. If you have not then search for "sample
scripts" in Visual Studio.Net help. There is a link "Script for Publishing
Sample Reports". Click on the link and then read the instructions that
follow. If you are still unclear as to what to do, then i will try and help
u further.
Cheers
"AdamB" <AdamB@.discussions.microsoft.com> wrote in message
news:6E73D669-1411-4440-8DDB-EFD7AA0615AD@.microsoft.com...
>I will do that for now, thanks. But I was hoping to create an ASP.Net
> application where I could select an rdl or rds file and call the web
> service
> to add the selected resource behind the scenes
> "Tao Zuo" wrote:
>> I posted this message earlier today, but let me try one more time:
>> Why not use the upload file buttom of the Report Manager
>> (http://yourreportsite/reports) to do the deployment?
>> a) Upload the rdl;
>> b) Create the db connection manually again within the Report Manager.
>> Tao
>>
>> "AdamB" wrote:
>> > I was asked to design and deliver SQL Reporting Services reports to a
>> > customer. The customer will not have Visual Studio on their network.
>> > I've
>> > read that you can script the deployment of reports and shared
>> > datasources
>> > using RS.EXE but have not been able to figure it out with the
>> > instructions in
>> > the documentation.
>> >
>> > Can anyone provide an example of how I would do this?|||Thanks, I'll check it out. What about deploying data sources. I see that
the Web Service has a CreateDataSource class. Do you know if this is pretty
straightforward?
"Sanjeev" wrote:
> Do you still require assistance regarding thiis topic. Have you tried
> running the PublishSampleReports.rss script from the command window. Or have
> you not reached that far as yet. If you have not then search for "sample
> scripts" in Visual Studio.Net help. There is a link "Script for Publishing
> Sample Reports". Click on the link and then read the instructions that
> follow. If you are still unclear as to what to do, then i will try and help
> u further.
> Cheers
> "AdamB" <AdamB@.discussions.microsoft.com> wrote in message
> news:6E73D669-1411-4440-8DDB-EFD7AA0615AD@.microsoft.com...
> >I will do that for now, thanks. But I was hoping to create an ASP.Net
> > application where I could select an rdl or rds file and call the web
> > service
> > to add the selected resource behind the scenes
> >
> > "Tao Zuo" wrote:
> >
> >> I posted this message earlier today, but let me try one more time:
> >>
> >> Why not use the upload file buttom of the Report Manager
> >> (http://yourreportsite/reports) to do the deployment?
> >>
> >> a) Upload the rdl;
> >> b) Create the db connection manually again within the Report Manager.
> >>
> >> Tao
> >>
> >>
> >>
> >> "AdamB" wrote:
> >>
> >> > I was asked to design and deliver SQL Reporting Services reports to a
> >> > customer. The customer will not have Visual Studio on their network.
> >> > I've
> >> > read that you can script the deployment of reports and shared
> >> > datasources
> >> > using RS.EXE but have not been able to figure it out with the
> >> > instructions in
> >> > the documentation.
> >> >
> >> > Can anyone provide an example of how I would do this?
>
>

Deploying many reports to different network

Hello,
We have a situation where we have a main reporting server on our main
network and a separate isolated network with it's own reporting server. There
is no external connectivity to the second network.
We need to be able to periodically synchronise the two servers (copy all
new/updated reports from the main server to the isolated server). We have
over 150 reports to transfer in this way (and only likely to increase), any
ideas on the easiest way to do this would be much appreciated. Is it a
question of copying the RDLs to the server and then running a script to
deploy the reports? Or can you backup and restore the RS databases?
Cheers,
--
BenHi Ben,
I would probably recommend following the strategy of writing a custom script
to extract all of the reports by enumerating through all of the report
objects - Reports, Datasources and Security settings etc. to extract them
out. Then write another script to migrate them to the new database.
From what I have seen the reporting service databases are fairly specific to
a machine/webfarm and it would be probably more trouble that it is worth to
just to a detach/attach.
regards,
Adrian.
"Ben S" <BenS@.discussions.microsoft.com> wrote in message
news:A8A126FA-C1CE-4126-972B-D4EBB28F0722@.microsoft.com...
> Hello,
> We have a situation where we have a main reporting server on our main
> network and a separate isolated network with it's own reporting server.
> There
> is no external connectivity to the second network.
> We need to be able to periodically synchronise the two servers (copy all
> new/updated reports from the main server to the isolated server). We have
> over 150 reports to transfer in this way (and only likely to increase),
> any
> ideas on the easiest way to do this would be much appreciated. Is it a
> question of copying the RDLs to the server and then running a script to
> deploy the reports? Or can you backup and restore the RS databases?
> Cheers,
> --
> Ben|||Or just follow MS suggested method of migrating an RS database :)
http://support.microsoft.com/?kbid=842425
"Ben S" <BenS@.discussions.microsoft.com> wrote in message
news:A8A126FA-C1CE-4126-972B-D4EBB28F0722@.microsoft.com...
> Hello,
> We have a situation where we have a main reporting server on our main
> network and a separate isolated network with it's own reporting server.
> There
> is no external connectivity to the second network.
> We need to be able to periodically synchronise the two servers (copy all
> new/updated reports from the main server to the isolated server). We have
> over 150 reports to transfer in this way (and only likely to increase),
> any
> ideas on the easiest way to do this would be much appreciated. Is it a
> question of copying the RDLs to the server and then running a script to
> deploy the reports? Or can you backup and restore the RS databases?
> Cheers,
> --
> Ben|||Thank you Adrian for both options.
I will leave this option as for now and try the scripting option first - I
should then be able to write it to only pick those reports modified after a
particular date to save transferring the whole lot each time.
Thanks again
Ben
"Adrian Russell" wrote:
> Or just follow MS suggested method of migrating an RS database :)
> http://support.microsoft.com/?kbid=842425
> "Ben S" <BenS@.discussions.microsoft.com> wrote in message
> news:A8A126FA-C1CE-4126-972B-D4EBB28F0722@.microsoft.com...
> > Hello,
> >
> > We have a situation where we have a main reporting server on our main
> > network and a separate isolated network with it's own reporting server.
> > There
> > is no external connectivity to the second network.
> >
> > We need to be able to periodically synchronise the two servers (copy all
> > new/updated reports from the main server to the isolated server). We have
> > over 150 reports to transfer in this way (and only likely to increase),
> > any
> > ideas on the easiest way to do this would be much appreciated. Is it a
> > question of copying the RDLs to the server and then running a script to
> > deploy the reports? Or can you backup and restore the RS databases?
> >
> > Cheers,
> > --
> > Ben
>
>|||Try 'RSScripter' from http://www.sqldbatips.com/ - it can create the
scripts and supporting files for you|||Thanks Parker, that looks very useful!
"Parker" wrote:
> Try 'RSScripter' from http://www.sqldbatips.com/ - it can create the
> scripts and supporting files for you
>

Deploying a report to a remote server

How do I deploy are report that is not on my network?
I need to deploy my report to the production server. I have FTP access, and
I usually Remote Desktop to the machine, but its not on my network.
When I try to deploy to the remote server, I get an error saying that that
server can't be accessed.
What is the solution? How can I deploy my reports?
Thank you!!I believe all you need to do is copy the RDL to a folder accessible from the
production server, then Add the report on the production server. There's a
button to Browse that lets you pick the RDL file from a folder on the
production server.
At my company (www.icco.com) we have built a tool to deploy batches of
reports at a time. If you are interested contact me by email or phone (954)
5471293.
"Julie" wrote:
> How do I deploy are report that is not on my network?
> I need to deploy my report to the production server. I have FTP access, and
> I usually Remote Desktop to the machine, but its not on my network.
> When I try to deploy to the remote server, I get an error saying that that
> server can't be accessed.
> What is the solution? How can I deploy my reports?
> Thank you!!

Deployed report fails to start

VS2005 project with imbedded SQL Server reports works fine in VS IDE going agianst a network SQL Server 2005 or the local SQL Server 2005. However, when the application is deployed (to another computer). the application starts and connects successfully to the network SQL Server 2005. Everything works until the user tries to produce a report. Then the following error is generated:

Named Pipes Provider, error: 0 - No process is on the other end of the pipe (the verbose part of the error message is left out). SQL Server agent is running both on the file server and the local computer. Also, named pipes and shared memory are enabled in file server and local computer (TCP and VIA protocoles are disabled). Same is done for Client protocoles.

Any suggestions are greatly appreciated.

Go to SQL Surface are configuration -&gt; Surface Area configuration for services and connections -&gt;; Datsbase engine -&gt; remote connections and check if remote connections using TCP/IP and named pipes is enabled.gatharia|||

Have you enabled remote network connections?

http://codebetter.com/blogs/sahil.malik/archive/2005/11/05/134318.aspx

|||

Tks for suggestion. Both on the file server and the local computer I have set the Surface Area ... to TCP/IP and Named Pipes. Please note that the access to and use of the SQL server database engine is not a problem. Everything works. The problem is related to the SSRS. That is the problem occurs when the report program tries to access the database.Maybe in the way the report dataset or datasource is defined. But then why does it work from within IDE?

|||

Yes I have. Connecting to database engine is no problem. Failure occurs when the report function tries to access the database.

|||Are you using integrated security for your datsets? I recommend using sql login.

dependency relations are different from different mining structures with same mining algorithms?

Hi, all here..

I got one problem in my data analysis case with SQL Server 2005 data mining algorithms-in the dependency network, the attributes mostly affected the predictive value are different in different mining structures tho.

For example, I got a, b,c as input attributes to predict attribute d, in mining structure 1 (with all attributes discretized), i got a as the attribute which has the strongest relation with predictive attribute d. However in mining structure 2 (with all attributes values continuous), I got attribute b as the strongest attribute with predictive attribute d?

So what is the problem tho? In this case, how can I tell which attribute actually has the strongest relation with predictive attribute?

Thanks a lot in advance for help.

This is expected. You are modeling two different problems here. In the discretized space you are asking "are ranges of data predictive of my target", in the other you are using the raw values.

For example, say you are predicting credit worthyness based on age and salary. If you discretize you are asking "which age and salary ranges indicate creditworthiness." Your ranges for age could be 0-10,11-20,21-40, etc. and salary could be 0-30k, 30-60k, etc.

In this model you may find that people who are in the 0-10 bucket have very little creditworthiness and therefore Age is the strongest predictor.

If you choose continuous, you may find that overall, a very low salary, e.g. < 13K was a stronger indicator and age overall played a minor role. This could be because the bucketing hid detail from the algorithm, or even (if predicting a continuous) because the salary played a stronger role in a regression formula.

|||Hi, Jamie,thanks a lot .

Dependency network question!!

Hi, I have a question concerning microsoft data mining in sql server 05.

The thing is: when i create a new AS project in my visual studio define data source view and create model, let it be decition tree, i can see "dependency network" where i can figure how one column relate to another.

I want to use this knowledge in my C# application in order to choose right column to my next task. How do i get the result using dmx or amo? Do you have any idea?

Run SQL Server Profiler when opening dependancy network tab of the viewer. You will see what store procedure the viewer calls to display the dependency network. Then call the store procedure from your C# application.

Here is what you get back from the store procedure. (I executed

CALL System.Microsoft.AnalysisServices.System.DataMining.DecisionTreesDepNet.DTGetNodeGraph('v Target Mail', 60) )

NODE_TYPE NODE_UNIQUE_NAME_1 NODE_UNIQUE_NAME_2 MSOLAP_NODE_SCORE
1 3 Date First Purchase
1 0 Bike Buyer
1 2 Commute Distance
1 5 English Occupation
1 4 English Education
1 1 Birth Date
2 5 0 1
2 2 0 4
2 3 0 5
2 1 0 3
2 4 0 2

NODE_TYPE 1 is a node, NODE_TYPE 2 is an edge.

Node "Date First Purchase" has an ID 3, "Bike Buyer" has an ID 0, "Commute Distance" has ID 2 etc.

The strongest edge with MSOLAP_NODE_SCORE = 5 goes from node 3 to node 0, i.e. from "Date First Purchase" to "Bike Buyer".

Tatyana

|||Great thx a lot... it helps me more than you can imagine. Take care Tatyana

Langsuyuar

Dependency network question!!

Hi, I have a question concerning microsoft data mining in sql server 05.

The thing is: when i create a new AS project in my visual studio define data source view and create model, let it be decition tree, i can see "dependency network" where i can figure how one column relate to another.

I want to use this knowledge in my C# application in order to choose right column to my next task. How do i get the result using dmx or amo? Do you have any idea?

Run SQL Server Profiler when opening dependancy network tab of the viewer. You will see what store procedure the viewer calls to display the dependency network. Then call the store procedure from your C# application.

Here is what you get back from the store procedure. (I executed

CALL System.Microsoft.AnalysisServices.System.DataMining.DecisionTreesDepNet.DTGetNodeGraph('v Target Mail', 60) )

NODE_TYPE NODE_UNIQUE_NAME_1 NODE_UNIQUE_NAME_2 MSOLAP_NODE_SCORE
1 3 Date First Purchase
1 0 Bike Buyer
1 2 Commute Distance
1 5 English Occupation
1 4 English Education
1 1 Birth Date
2 5 0 1
2 2 0 4
2 3 0 5
2 1 0 3
2 4 0 2

NODE_TYPE 1 is a node, NODE_TYPE 2 is an edge.

Node "Date First Purchase" has an ID 3, "Bike Buyer" has an ID 0, "Commute Distance" has ID 2 etc.

The strongest edge with MSOLAP_NODE_SCORE = 5 goes from node 3 to node 0, i.e. from "Date First Purchase" to "Bike Buyer".

Tatyana

|||Great thx a lot... it helps me more than you can imagine. Take care Tatyana

Langsuyuar

Dependency Network Graph Question

I have some problems in understanding the dependency network graph which is built in the association rules algorithm. My questions are:

1) Assuming an arrow goes from Node A to Node B ( A --> B), is Node A dependent from Node B or is Node B dependent from Node A?
2) Are only rules used with one element on each side of the rule (itemset size = 2) or is the graph also influenced by rules with more elements?
3) it is said that the slider on the left side is related to the probability of the rules. when viewing my rules table I don't understand why some rules are viewable later then other ones because they have the same probability. Is there another parameter influencing this slider? Which one?

I would be grateful for your help!

Regards, David

1: read it as A -> B, that means that the presence of A imples the presence of B.

2: The dep net currently only uses rules generated from two itemsets

3: I believe the slider is more the importance of the rule than the probability. A rule A->B where both occur 100% in the data isn't very interesting, so I think that's what you are seeing.

Dependency Net Viewer

Hi,

I've got a Decision Tree model and I'm trying to browse the dependency network. Apparently, there are too many nodes and they don't all show up in the view. I know that I can find hidden nodes, but is there a way to show all w/o having to add them one by one to view? How does the UI determine which ones to filter out?

Thanks,

Mike

Excellent question!

The dependency net viewer takes the top 60 nodes determined by a heuristic to be interesting. It uses a mix of input and output nodes to make sure that you don't get all inputs or all outputs (that wouldn't make an interesting diagram, would it?)

Using the dependency net viewer control, you can only add nodes one by one. However, if you use the Data Mining Templates for Visio 2007 (part of the SQL Server 2005 Data Mining Addins for Office 2007 - preview currently available here) you can create a dependency net with however many nodes you like. You can also "grow" a network dynamically by searching for a node and then adding related nodes and then adding related nodes to the related nodes and so on. The preview build requires the Beta 2 Technical Refresh version of Office 2007 to run - in particular for this case, the Beta 2 Technical Refresh of Visio 2007.

Deny remote network access to MSDE

HI!
I'd like turn off remote network access for a user group in the user
manager.
Are users of this group still capable of accessing the MSDE while
working on the local machine?
What does local access mean?
Can they access the MSDE via TCP to 127.0.0.1?
Or must they access the MSDE through a named pipe?
Ciao, Michael.
If I'm not mistaken, MSDE 2000 SP3a already disables remote access by
default.
joe.
"Michael Strder" <michael@.stroeder.com> wrote in message
news:sauhi2-5k4.ln1@.nb2.stroeder.com...
> HI!
> I'd like turn off remote network access for a user group in the user
> manager.
> Are users of this group still capable of accessing the MSDE while
> working on the local machine?
> What does local access mean?
> Can they access the MSDE via TCP to 127.0.0.1?
> Or must they access the MSDE through a named pipe?
> Ciao, Michael.