Prev: Update - Microsoft Responds to the Evolution of Community
Next: unable to delete column
From: Joël on 8 May 2010 06:03
Hello!
Into a Windows domain, I have 2 windows 2008 servers. All of them have their
firewall activated.

The 1st one is the host for SqlServer DB engine, and the 2nd one hosts
Reporting Services. As you gest Reporting Services use the SQL Server DB
Engine on the 1st server.

Today, the firewall is configurated to allow access to SQLServer DB Engine
on the 1st host. I can create queries and administer the db throw Management
Studio, from any computer in the domain.

And the firewall on the 2nd host is configurated to allow me to access the
Reporting Services web site from anywhere in the domain. I can add and open
reports from the Reports web site.
However, I'm not able to administer my Reporting Services using Management
Studio (for example, to create specific roles). It seems the firewall is
blocking me.

What is the minimum configuration should I apply to the windows firewall, to
allow me to manage Reporting Services throw Management Studio? I need remote
management, because Management Studio is not installed on the 2nd host.

Thanks for your help.
From: Uri Dimant on 9 May 2010 03:10
Hi
If you go to the second server and type http://servername/reports , there
are you able to create roles?


"Jo?l" <Jol(a)discussions.microsoft.com> wrote in message
news:8BADDDDB-6DCC-4A8E-8FFD-74F7FC76314F(a)microsoft.com...
> Hello!
> Into a Windows domain, I have 2 windows 2008 servers. All of them have
> their
> firewall activated.
>
> The 1st one is the host for SqlServer DB engine, and the 2nd one hosts
> Reporting Services. As you gest Reporting Services use the SQL Server DB
> Engine on the 1st server.
>
> Today, the firewall is configurated to allow access to SQLServer DB Engine
> on the 1st host. I can create queries and administer the db throw
> Management
> Studio, from any computer in the domain.
>
> And the firewall on the 2nd host is configurated to allow me to access the
> Reporting Services web site from anywhere in the domain. I can add and
> open
> reports from the Reports web site.
> However, I'm not able to administer my Reporting Services using Management
> Studio (for example, to create specific roles). It seems the firewall is
> blocking me.
>
> What is the minimum configuration should I apply to the windows firewall,
> to
> allow me to manage Reporting Services throw Management Studio? I need
> remote
> management, because Management Studio is not installed on the 2nd host.
>
> Thanks for your help.


 | 
Pages: 1
Prev: Update - Microsoft Responds to the Evolution of Community
Next: unable to delete column