ICF, SQL SERVER 2000 and Windows 2003

Is it possible to configure a W2K3 server's ICF (internet connection
firewall) to allow remote connection of EM (enterprise manager) to SQL
Server 2000? I tried creating 2 new "applications" on port 1433 TCP and
1433 UDP, and was unable to connect. Disabling ICF does allow EM to
connect and function.
Tia - MarkCheck your firewall log to see what is being blocked.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

I want the user to only see the History Tab and nothing else

Dear Anyone,

Is it possible to configure the security of a report to only allow the user to see the history tab and not the properties, subcription and view tab and in addition, only view the snapshot reports and not the actual report itself?

Thanks,

Joseph

Joseph,

This is not possible with the current security granularity. You can apply "Manage Report History" which gives the user the rights to view history snapshots, but this also gives the ability to manage report history and execution properties.

You could apply "View Reports", but this also gives the ability to view the live report.

A crude simulation of what you want can be achieved with a combination of security and configuration:

1. configure the report to render from a snapshot, using Execution settings

2. select "Store all report execution snapshots in history" under History properties

3. give the user only View Reports permissions

Now, the user will only be able to view the report from either the most current snapshot (which is also the most current history snapshot), or through older history snapshots. The user wil not be able to view the report live, and will not be able to change the execution or history configuration. He will still see the Properties tab, but the only information available will be "General" information.

I need to put my main page on IE when some one request for it.

Hi

Can anybody tell me that how can i configure the things that will show my main report page when i enter Url like http://localhost/ReportServer. It gives directory struction first & then we have to select particular report

Rajnish

Hi Rajnish,

You can provide the entire URL, not just the directory name. Something like this: http://Servername/ReportServer/Pages/ReportViewer.aspx?%2fReportName&rs:Command=Render