Deploying SSRS

I am trying to get SSRS to work and am having trouble getting it to go.
When I go to IIS and browse, it won't let me see the page, it reads "This
page cannot be displayed". The internet has connectivity because I can get
on my email and other sites.
When I try to deploy the report, I am having issues as well with
connectivity. I get an error that reads "A connection could not be made to
the report server http://localhost/ReportServer"
I went to services on the server and verified that SSRS was running and so
was IIS.
Any thoughts?Check the access (security) rights on the ReportServer.
David
"Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
news:ED56B7A0-274E-4345-914C-3AAFA0B4CF59@.microsoft.com...
>I am trying to get SSRS to work and am having trouble getting it to go.
> When I go to IIS and browse, it won't let me see the page, it reads "This
> page cannot be displayed". The internet has connectivity because I can
> get
> on my email and other sites.
> When I try to deploy the report, I am having issues as well with
> connectivity. I get an error that reads "A connection could not be made
> to
> the report server http://localhost/ReportServer"
> I went to services on the server and verified that SSRS was running and so
> was IIS.
> Any thoughts?|||David,
Do you mean the ReportServer db database in SQL management studio? What
security are you referring to?
Thanks,
Ryan
"David C" wrote:
> Check the access (security) rights on the ReportServer.
> David
> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
> news:ED56B7A0-274E-4345-914C-3AAFA0B4CF59@.microsoft.com...
> >I am trying to get SSRS to work and am having trouble getting it to go.
> > When I go to IIS and browse, it won't let me see the page, it reads "This
> > page cannot be displayed". The internet has connectivity because I can
> > get
> > on my email and other sites.
> >
> > When I try to deploy the report, I am having issues as well with
> > connectivity. I get an error that reads "A connection could not be made
> > to
> > the report server http://localhost/ReportServer"
> >
> > I went to services on the server and verified that SSRS was running and so
> > was IIS.
> >
> > Any thoughts?
>
>|||Go into the Report Manager from your browser. Select the folder that holds
your reports, click the Properties tab and then the Security link. Users
should have at least Browser (I think) to run the reports.
Use the "New Role Assignment" button to add users or groups. I suggest you
use an Active Directory (or local) group as it will be easier to manage.
David
"Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
news:AB4F831D-1CBB-4786-80B4-5747988BA44F@.microsoft.com...
> David,
> Do you mean the ReportServer db database in SQL management studio? What
> security are you referring to?
> Thanks,
> Ryan
> "David C" wrote:
>> Check the access (security) rights on the ReportServer.
>> David
>> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
>> news:ED56B7A0-274E-4345-914C-3AAFA0B4CF59@.microsoft.com...
>> >I am trying to get SSRS to work and am having trouble getting it to go.
>> > When I go to IIS and browse, it won't let me see the page, it reads
>> > "This
>> > page cannot be displayed". The internet has connectivity because I can
>> > get
>> > on my email and other sites.
>> >
>> > When I try to deploy the report, I am having issues as well with
>> > connectivity. I get an error that reads "A connection could not be
>> > made
>> > to
>> > the report server http://localhost/ReportServer"
>> >
>> > I went to services on the server and verified that SSRS was running and
>> > so
>> > was IIS.
>> >
>> > Any thoughts?
>>|||David,
That is the problem, I can't even get the browser page to show up. When I
try to deploy a report, it isn't connecting to the report server. Not sure
what is going on. IIS is on and so is SSRS services.
Any other thoughts?
Ryan
"David C" wrote:
> Go into the Report Manager from your browser. Select the folder that holds
> your reports, click the Properties tab and then the Security link. Users
> should have at least Browser (I think) to run the reports.
> Use the "New Role Assignment" button to add users or groups. I suggest you
> use an Active Directory (or local) group as it will be easier to manage.
> David
> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
> news:AB4F831D-1CBB-4786-80B4-5747988BA44F@.microsoft.com...
> > David,
> > Do you mean the ReportServer db database in SQL management studio? What
> > security are you referring to?
> >
> > Thanks,
> > Ryan
> >
> > "David C" wrote:
> >
> >> Check the access (security) rights on the ReportServer.
> >>
> >> David
> >> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
> >> news:ED56B7A0-274E-4345-914C-3AAFA0B4CF59@.microsoft.com...
> >> >I am trying to get SSRS to work and am having trouble getting it to go.
> >> > When I go to IIS and browse, it won't let me see the page, it reads
> >> > "This
> >> > page cannot be displayed". The internet has connectivity because I can
> >> > get
> >> > on my email and other sites.
> >> >
> >> > When I try to deploy the report, I am having issues as well with
> >> > connectivity. I get an error that reads "A connection could not be
> >> > made
> >> > to
> >> > the report server http://localhost/ReportServer"
> >> >
> >> > I went to services on the server and verified that SSRS was running and
> >> > so
> >> > was IIS.
> >> >
> >> > Any thoughts?
> >>
> >>
> >>
>
>|||Hi,
It seems to be a problem to hit the web server.
Have you check IIS logs ? Do you see connection attempts ? What is the HTTP
status code ?
Does SSRS and IIS on the same server ?
Jean-Pierre
"Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
news:CCE4F651-B458-4435-9FCA-0EFAE4235594@.microsoft.com...
> David,
> That is the problem, I can't even get the browser page to show up. When I
> try to deploy a report, it isn't connecting to the report server. Not
> sure
> what is going on. IIS is on and so is SSRS services.
> Any other thoughts?
> Ryan
> "David C" wrote:
>> Go into the Report Manager from your browser. Select the folder that
>> holds
>> your reports, click the Properties tab and then the Security link. Users
>> should have at least Browser (I think) to run the reports.
>> Use the "New Role Assignment" button to add users or groups. I suggest
>> you
>> use an Active Directory (or local) group as it will be easier to manage.
>> David
>> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
>> news:AB4F831D-1CBB-4786-80B4-5747988BA44F@.microsoft.com...
>> > David,
>> > Do you mean the ReportServer db database in SQL management studio?
>> > What
>> > security are you referring to?
>> >
>> > Thanks,
>> > Ryan
>> >
>> > "David C" wrote:
>> >
>> >> Check the access (security) rights on the ReportServer.
>> >>
>> >> David
>> >> "Ryan Mcbee" <RyanMcbee@.discussions.microsoft.com> wrote in message
>> >> news:ED56B7A0-274E-4345-914C-3AAFA0B4CF59@.microsoft.com...
>> >> >I am trying to get SSRS to work and am having trouble getting it to
>> >> >go.
>> >> > When I go to IIS and browse, it won't let me see the page, it reads
>> >> > "This
>> >> > page cannot be displayed". The internet has connectivity because I
>> >> > can
>> >> > get
>> >> > on my email and other sites.
>> >> >
>> >> > When I try to deploy the report, I am having issues as well with
>> >> > connectivity. I get an error that reads "A connection could not be
>> >> > made
>> >> > to
>> >> > the report server http://localhost/ReportServer"
>> >> >
>> >> > I went to services on the server and verified that SSRS was running
>> >> > and
>> >> > so
>> >> > was IIS.
>> >> >
>> >> > Any thoughts?
>> >>
>> >>
>> >>
>>

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 permission to the object browser in query analizer

I have a sql server 2000 and i want that a user have only acess to a
determined table in a database. I don't want the user can browse the other
objects thru the object browser in the query analizer. Is that possible?
--
JLoboNo they can see objects. They can only access the objects
you grant permissions to though.
-Sue
On Wed, 15 Mar 2006 08:20:11 -0800, JLobo
<JLobo@.discussions.microsoft.com> wrote:

>I have a sql server 2000 and i want that a user have only acess to a
>determined table in a database. I don't want the user can browse the other
>objects thru the object browser in the query analizer. Is that possible?