Ho to run Enterprise Manager on another PC

Hi,
I want to let another user access Enterprise Manager from his PC. How do I
do this? I tried to setup MMC but there is no SQL snap-in to add.
Thanks a lot, Alex.You need to install the client tools from the SQLServer CD. You are entitled
to run the client tools on any device that is licensed with a CAL or any
device that connects to a processor-licensed server.
--
David Portas
--
Please reply only to the newsgroup
--sql

history, subscription links on manager throwing below error

Hi,
When I click on Scheduling, History, new subscription hyperlinks the below error message is popping up, so I couldn't schedule a report. please help me in this regard what needs to be done.
EXECUTE permission denied on object 'xp_sqlagent_notify', database 'master', owner 'dbo'.
ThanksHmm... on the database server, do both the Report Server NT service account
and the ASP.Net service account have the RSExec role on the MSDB database?
-Lukasz
"Subba" <Subba@.discussions.microsoft.com> wrote in message
news:ACD31262-144F-4EE9-8B29-B15AF7B520D2@.microsoft.com...
> Hi,
> When I click on Scheduling, History, new subscription hyperlinks the below
> error message is popping up, so I couldn't schedule a report. please help
> me in this regard what needs to be done.
> EXECUTE permission denied on object 'xp_sqlagent_notify', database
> 'master', owner 'dbo'.
> Thanks|||Use enterprise manager to connect to the SQL Server instance that hosts the
report server database. Navigate to the security folder in the tree and
find roles - it should give you a list of roles in the system and which
users have those roles granted to them.
Whatever account ASP.Net is running as (look in the Machine.config file for
ASP.Net) and whatever account you chose during setup for the ReportServer
service (look in MMC), need to have the RSExec role on the following
databases - ReportServer, ReportServerTempDB, MSDB.
-Lukasz
"Subba" <Subba@.discussions.microsoft.com> wrote in message
news:F8339FD7-7CFE-4527-9D99-780C4280B9A9@.microsoft.com...
> Iam not able to understand what exactly needs to be done, can you be
> please more specific what exactly needs to be done.
> "Subba" wrote:
>> Hi,
>> When I click on Scheduling, History, new subscription hyperlinks the
>> below error message is popping up, so I couldn't schedule a report.
>> please help me in this regard what needs to be done.
>> EXECUTE permission denied on object 'xp_sqlagent_notify', database
>> 'master', owner 'dbo'.
>> Thanks|||Additional information on this:
Service accounts (in my case I have 3: NT Authority\Local Service, NT Authority\Network Service, NT Authority\System) need to have execute permission for 'xp_sqlagent_notify', which is in Master | Sytem Stored Procedures. The normal way to do this is to have these accounts be within the RSExec role and make sure that RSExec has execute permissions on the above stored procedure. When I tried this, it didn't fix my problem. When I gave execute permissions to all of the above service accounts (instead of relying on them getting the permissions through their membership in RSExec) the problem was fixed.
From http://www.developmentnow.com/g/115_2004_7_0_0_448752/history-subscription-links-on-manager-throwing-below-error.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||Update to my previous post - there must be something wrong with my SQL Server installation 'cause I kept getting permission errors. For some objects (tables, stored procedures) giving explicit permissions to the service accounts was not enough. I had to give Execute or Select permissions to the Public group (not real good for security, but it was the only way to get my installation to work).
Each time I would add another "Public" permission I'd need to attempt to add a subscription, get the error message, look in the log file for the next object that needed permission.
Oh well, at least I can add subscriptions now
From http://www.developmentnow.com/g/115_2004_7_0_0_448752/history-subscription-links-on-manager-throwing-below-error.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.comsql

history of Process info

i think i might a have a slight clue about this but need help...
in SQL Server Enterprise Manager -- Management -- Current Activity --
Process Info i can see the current info for SPIDs and users and all sorts of
great info.
How can i view that same info from yesterday at a specific time?
thanks a million.
You could use a log reader tool of which there are many to choose eg
Lumigent's LogExplorer.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||"Paul Ibison" wrote:

> You could use a log reader tool of which there are many to choose eg
> Lumigent's LogExplorer.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
> Lumgent wants $995
|||Ok there's a new low-cost ($195) alternative from Redgate:
http://www.red-gate.com/products/SQL_Log_Rescue/index.htm.
BTW I'm assuming that you actually have the log as a backup, or have been
using full recovery mode. if you've used simple then this strategy won't
work for the particular transaction you're looking for.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

history of Process info

i think i might a have a slight clue about this but need help...
in SQL Server Enterprise Manager -- Management -- Current Activity --
Process Info i can see the current info for SPIDs and users and all sorts of
great info.
How can i view that same info from yesterday at a specific time?
thanks a million.You could use a log reader tool of which there are many to choose eg
Lumigent's LogExplorer.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||"Paul Ibison" wrote:

> You could use a log reader tool of which there are many to choose eg
> Lumigent's LogExplorer.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
> Lumgent wants $995|||Ok there's a new low-cost ($195) alternative from Redgate:
http://www.red-gate.com/products/SQ...scue/index.htm.
BTW I'm assuming that you actually have the log as a backup, or have been
using full recovery mode. if you've used simple then this strategy won't
work for the particular transaction you're looking for.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .

High Volume of Net Traffic coming from MSSQL

We're having a bit of an issue with network traffic being generated from one
of our MSSQL Servers.
It seems that when we launch Enterprise Manager on a remote computer
(usually at another office), the MSSQL servers start sending packets to the
EM regardless of whether we are maintaining an active connection to the
server or not. What is happening is that these packets are being lost and
reported in our firewall as 'host unreachable'. These packets are also
firing every second for each EM open across our network, so this is becoming
a bit of a pain for our poor network guys. The other odd thing is that the
firewall is only reporting one-way traffic, from the server to the client,
but the client is not sending any traffic back down unless it is actively
connected to the remote server.
Any thoughts as to why this might be happening, or better yet, a way to cull
this traffic?
We're running MSSQL 2000 SP3a on Windows 2003 servers.
Thanks in advance!
Mike,Have you applied the post-SP3a hotfix?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
We're having a bit of an issue with network traffic being generated from one
of our MSSQL Servers.
It seems that when we launch Enterprise Manager on a remote computer
(usually at another office), the MSSQL servers start sending packets to the
EM regardless of whether we are maintaining an active connection to the
server or not. What is happening is that these packets are being lost and
reported in our firewall as 'host unreachable'. These packets are also
firing every second for each EM open across our network, so this is becoming
a bit of a pain for our poor network guys. The other odd thing is that the
firewall is only reporting one-way traffic, from the server to the client,
but the client is not sending any traffic back down unless it is actively
connected to the remote server.
Any thoughts as to why this might be happening, or better yet, a way to cull
this traffic?
We're running MSSQL 2000 SP3a on Windows 2003 servers.
Thanks in advance!
Mike,|||We have the entire SP3a hotfix installed, but I am unaware of a post SP3a fi
x
- are you referring to SP4?
"Tom Moreau" wrote:

> Have you applied the post-SP3a hotfix?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
> news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
> We're having a bit of an issue with network traffic being generated from o
ne
> of our MSSQL Servers.
> It seems that when we launch Enterprise Manager on a remote computer
> (usually at another office), the MSSQL servers start sending packets to th
e
> EM regardless of whether we are maintaining an active connection to the
> server or not. What is happening is that these packets are being lost and
> reported in our firewall as 'host unreachable'. These packets are also
> firing every second for each EM open across our network, so this is becomi
ng
> a bit of a pain for our poor network guys. The other odd thing is that th
e
> firewall is only reporting one-way traffic, from the server to the client,
> but the client is not sending any traffic back down unless it is actively
> connected to the remote server.
> Any thoughts as to why this might be happening, or better yet, a way to cu
ll
> this traffic?
> We're running MSSQL 2000 SP3a on Windows 2003 servers.
> Thanks in advance!
> Mike,
>|||Define "entire SP3a hotfix". There is the service pack - SP3a - and then
there is the hotfix. Are you saying that you have applied SP3a but not the
hotfix? IOW, have you applied:
http://support.microsoft.com/kb/821277
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
news:5D90B16F-7EDB-401C-8022-106365D44347@.microsoft.com...
We have the entire SP3a hotfix installed, but I am unaware of a post SP3a
fix
- are you referring to SP4?
"Tom Moreau" wrote:

> Have you applied the post-SP3a hotfix?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
> news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
> We're having a bit of an issue with network traffic being generated from
> one
> of our MSSQL Servers.
> It seems that when we launch Enterprise Manager on a remote computer
> (usually at another office), the MSSQL servers start sending packets to
> the
> EM regardless of whether we are maintaining an active connection to the
> server or not. What is happening is that these packets are being lost and
> reported in our firewall as 'host unreachable'. These packets are also
> firing every second for each EM open across our network, so this is
> becoming
> a bit of a pain for our poor network guys. The other odd thing is that
> the
> firewall is only reporting one-way traffic, from the server to the client,
> but the client is not sending any traffic back down unless it is actively
> connected to the remote server.
> Any thoughts as to why this might be happening, or better yet, a way to
> cull
> this traffic?
> We're running MSSQL 2000 SP3a on Windows 2003 servers.
> Thanks in advance!
> Mike,
>

High Volume of Net Traffic coming from MSSQL

We're having a bit of an issue with network traffic being generated from one
of our MSSQL Servers.
It seems that when we launch Enterprise Manager on a remote computer
(usually at another office), the MSSQL servers start sending packets to the
EM regardless of whether we are maintaining an active connection to the
server or not. What is happening is that these packets are being lost and
reported in our firewall as 'host unreachable'. These packets are also
firing every second for each EM open across our network, so this is becoming
a bit of a pain for our poor network guys. The other odd thing is that the
firewall is only reporting one-way traffic, from the server to the client,
but the client is not sending any traffic back down unless it is actively
connected to the remote server.
Any thoughts as to why this might be happening, or better yet, a way to cull
this traffic?
We're running MSSQL 2000 SP3a on Windows 2003 servers.
Thanks in advance!
Mike,
Have you applied the post-SP3a hotfix?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
"Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
We're having a bit of an issue with network traffic being generated from one
of our MSSQL Servers.
It seems that when we launch Enterprise Manager on a remote computer
(usually at another office), the MSSQL servers start sending packets to the
EM regardless of whether we are maintaining an active connection to the
server or not. What is happening is that these packets are being lost and
reported in our firewall as 'host unreachable'. These packets are also
firing every second for each EM open across our network, so this is becoming
a bit of a pain for our poor network guys. The other odd thing is that the
firewall is only reporting one-way traffic, from the server to the client,
but the client is not sending any traffic back down unless it is actively
connected to the remote server.
Any thoughts as to why this might be happening, or better yet, a way to cull
this traffic?
We're running MSSQL 2000 SP3a on Windows 2003 servers.
Thanks in advance!
Mike,
|||We have the entire SP3a hotfix installed, but I am unaware of a post SP3a fix
- are you referring to SP4?
"Tom Moreau" wrote:

> Have you applied the post-SP3a hotfix?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
> news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
> We're having a bit of an issue with network traffic being generated from one
> of our MSSQL Servers.
> It seems that when we launch Enterprise Manager on a remote computer
> (usually at another office), the MSSQL servers start sending packets to the
> EM regardless of whether we are maintaining an active connection to the
> server or not. What is happening is that these packets are being lost and
> reported in our firewall as 'host unreachable'. These packets are also
> firing every second for each EM open across our network, so this is becoming
> a bit of a pain for our poor network guys. The other odd thing is that the
> firewall is only reporting one-way traffic, from the server to the client,
> but the client is not sending any traffic back down unless it is actively
> connected to the remote server.
> Any thoughts as to why this might be happening, or better yet, a way to cull
> this traffic?
> We're running MSSQL 2000 SP3a on Windows 2003 servers.
> Thanks in advance!
> Mike,
>
|||Define "entire SP3a hotfix". There is the service pack - SP3a - and then
there is the hotfix. Are you saying that you have applied SP3a but not the
hotfix? IOW, have you applied:
http://support.microsoft.com/kb/821277
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
"Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
news:5D90B16F-7EDB-401C-8022-106365D44347@.microsoft.com...
We have the entire SP3a hotfix installed, but I am unaware of a post SP3a
fix
- are you referring to SP4?
"Tom Moreau" wrote:

> Have you applied the post-SP3a hotfix?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
> news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
> We're having a bit of an issue with network traffic being generated from
> one
> of our MSSQL Servers.
> It seems that when we launch Enterprise Manager on a remote computer
> (usually at another office), the MSSQL servers start sending packets to
> the
> EM regardless of whether we are maintaining an active connection to the
> server or not. What is happening is that these packets are being lost and
> reported in our firewall as 'host unreachable'. These packets are also
> firing every second for each EM open across our network, so this is
> becoming
> a bit of a pain for our poor network guys. The other odd thing is that
> the
> firewall is only reporting one-way traffic, from the server to the client,
> but the client is not sending any traffic back down unless it is actively
> connected to the remote server.
> Any thoughts as to why this might be happening, or better yet, a way to
> cull
> this traffic?
> We're running MSSQL 2000 SP3a on Windows 2003 servers.
> Thanks in advance!
> Mike,
>

High PF Usage

The system is a Clustered x64 SQL Server 2005 SP2 Standard 32G of RAM. The task manager show the PF Usage as high as 27G. Any ideas why the usage would be so high?

Did you give the "Lock Pages in Memory" right to the SQL Server Service account? This is extremely important for 64-bit SQL Server 2005. Otherwise, the OS controls paging instead of SQL Server. I have some more details below:

http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!115.entry

High CPU time per user as soon as they connect?

On a couple of our servers, users are currently scoring very
high on "CPU Time" as reported by Enterprise Manager and by
sp_who2, both as soon as they log in, and afterwards -
5,000,000 at login and 47,000,000 later on are the top figures.
Most of the fleet is on SQL Server 2000 Service Pack 2, with
between 2 and 8 hard-working processors. The hardest working
server is on Service Pack 3(a), clustered, and its top 5
current values in CPU time are between 382,847 and 705,879.
The servers are all on clients' sites and networks, with client's
choice of firewall. Usual application is a Java interface using
jTDS, but CPU time is also reported high for a new Query Analyzer
connection. SQL Server, not Windows, accounts are most often used.
Clients aren't complaining of poor performance, apparently, but
maybe they already gave up phoning for that.
So, should we worry? Reboot? Reindex? Patch? Disinfect?
Or ask around, "Who left SQL Profiler running"...i would run profiler to find out whats going on.
i would also run perfmon to find out what average cpu is
over the entire day
otherwise, you have nothing from which to make reasonable
assessments
>--Original Message--
>On a couple of our servers, users are currently scoring
very
>high on "CPU Time" as reported by Enterprise Manager and
by
>sp_who2, both as soon as they log in, and afterwards -
>5,000,000 at login and 47,000,000 later on are the top
figures.
>Most of the fleet is on SQL Server 2000 Service Pack 2,
with
>between 2 and 8 hard-working processors. The hardest
working
>server is on Service Pack 3(a), clustered, and its top 5
>current values in CPU time are between 382,847 and
705,879.
>The servers are all on clients' sites and networks, with
client's
>choice of firewall. Usual application is a Java
interface using
>jTDS, but CPU time is also reported high for a new Query
Analyzer
>connection. SQL Server, not Windows, accounts are most
often used.
>Clients aren't complaining of poor performance,
apparently, but
>maybe they already gave up phoning for that.
>So, should we worry? Reboot? Reindex? Patch?
Disinfect?
>Or ask around, "Who left SQL Profiler running"...
>.
>

hiding/password Protecting Enterprise Manager

I have installed SQL 2000 and Enterprise Manager. I have a .Net application
I am developing. I need Enterprise Manager to make data table changes as I
finish my application, but I am afraid my test and final users will use the
Enterprise Manager to change data. I do not want users to change data
without using my application. Can I limit Enterprise Manager or password
protect or block access to other users?
Thanks
Paul DeWitt
Paul DeWitt wrote:
> I have installed SQL 2000 and Enterprise Manager. I have a .Net
> application I am developing. I need Enterprise Manager to make data
> table changes as I finish my application, but I am afraid my test and
> final users will use the Enterprise Manager to change data. I do not
> want users to change data without using my application. Can I limit
> Enterprise Manager or password protect or block access to other users?
> Thanks
> Paul DeWitt
Users can only perform operations that they have security to perform. If
you don't grant access to the tables and use stored procedures to change
and select data, then users logging into the database using any tool
(SQL Enterprise Manager, Query Analyzer, ISQL, OSQL, etc.) will not be
able to change any data unless they call the stored procedures from
those apps. If you do not provide some underlying security in the
database or your users have dbo or admin rights in the database, there
is nothing to prevent them from changing data and nothing you can really
do to stop it, short of encrypting yourself in the application.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Check out application roles (sp_setapprole).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul DeWitt" <PaulDeWitt@.discussions.microsoft.com> wrote in message
news:E0B9510C-7A3A-4EBB-8EA7-A202FC715D1E@.microsoft.com...
>I have installed SQL 2000 and Enterprise Manager. I have a .Net application
> I am developing. I need Enterprise Manager to make data table changes as I
> finish my application, but I am afraid my test and final users will use the
> Enterprise Manager to change data. I do not want users to change data
> without using my application. Can I limit Enterprise Manager or password
> protect or block access to other users?
> Thanks
> Paul DeWitt

Hiding the Find option in REPORT Manager - Viewing report

Hi,
I want to suppress the "Find" option in Report Manager when I am viewing the report. Is it possible?
How can we do this?

Thanks in advance.You can do this by creating a custom CSS for the viewer toolbar, modifying the RSReportServer.config file to use this CSS, and setting the find section of the toolbar to display:none in the CSS file.

I am planning on writing a blog entry for more details about this.

Hiding the Database list from a certain user\group

Is there a way to limit what user will see in Enterprise Manager? I
would like them to only see there db's and not all them.On Jun 18, 12:59 pm, OVDaddy <d...@.wemhoff.comwrote:

Quote:

Originally Posted by

Is there a way to limit what user will see in Enterprise Manager? I
would like them to only see there db's and not all them.

I have read and see that I am not able to do this.|||OVDaddy (dan@.wemhoff.com) writes:

Quote:

Originally Posted by

On Jun 18, 12:59 pm, OVDaddy <d...@.wemhoff.comwrote:

Quote:

Originally Posted by

>Is there a way to limit what user will see in Enterprise Manager? I
>would like them to only see there db's and not all them.

>
I have read and see that I am not able to do this.

I believe that in EM, you will see only the databases you have access to.

In SQL Server Management Studio that comes with SQL 2005, it's a different
story. Here you cannot hide databases.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||By default users see all databases in Enterprise Manager. The following KB
shows a method that you can use so users can see only databases that they
have access to (the title of the article is a bit off topic but in fact it
does show a good method):
http://support.microsoft.com/default.aspx/kb/889696
For SQL Server Management Studio this is much easier, you can just deny a
login the VIEW ANY DATABASE permission and that will do it.

HTH,

Plamen Ratchev
http://www.SQLStudio.com|||Plamen Ratchev (Plamen@.SQLStudio.com) writes:

Quote:

Originally Posted by

For SQL Server Management Studio this is much easier, you can just deny a
login the VIEW ANY DATABASE permission and that will do it.

Arguably. The users will only see the databases they *own*. They could
have access to other databases, but they will not show up.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||"Erland Sommarskog" <esquel@.sommarskog.sewrote in message
news:Xns9954ECC668758Yazorman@.127.0.0.1...

Quote:

Originally Posted by

>
Arguably. The users will only see the databases they *own*. They could
have access to other databases, but they will not show up.
>

Yes, but my understanding of the original post is that it asked for
configuration where users can see only their own databases, so this applies
here. This is what I meant. :)

Plamen Ratchev
http://www.SQLStudio.com

Hiding SQL Server Reporting Services Header

we published some reports and want to give user access to these via report
manager UI to Certain Folders.
Is it possible to hide the header which display SQL Server Reporting
Services, Home, My Subscriptions etc.?
thxHave you tried simply using the ReportServer URL? //SERVERNAME/ReportServer/
Let me know if this helps...
-David.
"nkg" wrote:
> we published some reports and want to give user access to these via report
> manager UI to Certain Folders.
> Is it possible to hide the header which display SQL Server Reporting
> Services, Home, My Subscriptions etc.?
> thx
>
>

Hiding reports

Is there a way to hide reports before publishing and then hiding reports via the Report Manager? We have some subreports that before we publish, we would like to set a flag to hidden so the Report Manager will know after the deploy that this report is to be hidden.

Thanks for the information.

Check out this post.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=546114&SiteID=1

-Somsong

|||

Thanks for the link.

I guess there is not a way to tell the report to be hidden before deploying it to the server. I kind of wished there were without having to go into the Report Manager after the report has been published.

|||

Yes you can. If you use the Reporting Services Web Service to deploy your reports you can pass in properties that sets the hidden property just like you would do in the report manager.

-Somsong

Hiding Report Parameters

I have a report with 3 parameters (Run Date, Branch, and Account Manager #).
We are using this report to show 3 different views (Corporate, Branch, and
Account Manager) and want to hide/disable the parameters that are not
required.
If the user wants to view the Corporate View, only the Run Date parameter is
to be displayed. The Branch and Account Manager # are defaulted to All using
the URL.
If the user wants to view the Branch View, only the Run Date and Branch
parameters are to be displayed. The Account Manager # is defaulted to All
using the URL.
Is it possible to hide these parameters in SQL Reporting Services 2000 using
the URL passed to the report?
If not, are there other ways?Yes. Push the report to a directory then create linked reports in 3
separate folders (corp, branch, acctMgr). You can specify whether or not
the parameter is hidden when you set up the linked report. You can then
grant the appropriate privileges on each of the three folders (don't grant
privileges to the three roles below on the primary report).
HTH
-Tim
"rwhitelaw" <rwhitelaw@.discussions.microsoft.com> wrote in message
news:FA85FF28-8F64-4FAC-80E1-8644629997CA@.microsoft.com...
>I have a report with 3 parameters (Run Date, Branch, and Account Manager
>#).
> We are using this report to show 3 different views (Corporate, Branch, and
> Account Manager) and want to hide/disable the parameters that are not
> required.
> If the user wants to view the Corporate View, only the Run Date parameter
> is
> to be displayed. The Branch and Account Manager # are defaulted to All
> using
> the URL.
> If the user wants to view the Branch View, only the Run Date and Branch
> parameters are to be displayed. The Account Manager # is defaulted to All
> using the URL.
> Is it possible to hide these parameters in SQL Reporting Services 2000
> using
> the URL passed to the report?
> If not, are there other ways?

Hiding Navigation Pane?

Hello,
Is there a querystring parameter I can use to hide the Navigation Pane on
the MSRS report manager. I want to embed the "My Reports" folder into a
frame, but don't want the end user to be able to navigate out of that page
by clicking on the "Home" link or search.
Anyhow know how I'd accomplish this?
Thanks,
Benjamin PierceYes there is...see "Using URL Access Parameters" in RS BOL.
"Benjamin Pierce" <bpierce@.opentext.com> wrote in message
news:%23jl6JUCZEHA.228@.TK2MSFTNGP10.phx.gbl...
> Hello,
> Is there a querystring parameter I can use to hide the Navigation Pane on
> the MSRS report manager. I want to embed the "My Reports" folder into a
> frame, but don't want the end user to be able to navigate out of that page
> by clicking on the "Home" link or search.
> Anyhow know how I'd accomplish this?
>
> Thanks,
> Benjamin Pierce
>
>|||Thanks for the help, unfortunately the closest I can see to what I'm looking
for is the "Toolbar" parameter which only hides the report viewer toolbar,
not the rest of the portal navigation...
Is there a parameter I'm missing?
Thanks again,
Benjamin Pierce
"Mick Horne" <mick.horne@.conchango.com> wrote in message
news:O5IdDxCZEHA.2816@.TK2MSFTNGP11.phx.gbl...
> Yes there is...see "Using URL Access Parameters" in RS BOL.
> "Benjamin Pierce" <bpierce@.opentext.com> wrote in message
> news:%23jl6JUCZEHA.228@.TK2MSFTNGP10.phx.gbl...
> > Hello,
> >
> > Is there a querystring parameter I can use to hide the Navigation Pane
on
> > the MSRS report manager. I want to embed the "My Reports" folder into a
> > frame, but don't want the end user to be able to navigate out of that
page
> > by clicking on the "Home" link or search.
> >
> > Anyhow know how I'd accomplish this?
> >
> >
> > Thanks,
> >
> > Benjamin Pierce
> >
> >
> >
>|||are you navigating to the folder using
http://<servername>/Reports/<whatever> ? Does using
http://<servername>/Reportserver/<whatever> work any better?
Mick
"Benjamin Pierce" <bpierce@.opentext.com> wrote in message
news:%23vrgqiDZEHA.2972@.TK2MSFTNGP12.phx.gbl...
> Thanks for the help, unfortunately the closest I can see to what I'm
looking
> for is the "Toolbar" parameter which only hides the report viewer toolbar,
> not the rest of the portal navigation...
> Is there a parameter I'm missing?
>
> Thanks again,
> Benjamin Pierce
> "Mick Horne" <mick.horne@.conchango.com> wrote in message
> news:O5IdDxCZEHA.2816@.TK2MSFTNGP11.phx.gbl...
> > Yes there is...see "Using URL Access Parameters" in RS BOL.
> >
> > "Benjamin Pierce" <bpierce@.opentext.com> wrote in message
> > news:%23jl6JUCZEHA.228@.TK2MSFTNGP10.phx.gbl...
> > > Hello,
> > >
> > > Is there a querystring parameter I can use to hide the Navigation Pane
> on
> > > the MSRS report manager. I want to embed the "My Reports" folder into
a
> > > frame, but don't want the end user to be able to navigate out of that
> page
> > > by clicking on the "Home" link or search.
> > >
> > > Anyhow know how I'd accomplish this?
> > >
> > >
> > > Thanks,
> > >
> > > Benjamin Pierce
> > >
> > >
> > >
> >
> >
>