Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / November 2005

Tip: Looking for answers? Try searching our database.

Limiting access to Report Designer Only

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
clutch - 29 Nov 2005 19:33 GMT
Hi,

Has anyone tried to limit access to Report Designer only? We have report
developers that can't have access to Integration Services, Analysis Services,
Report Models, etc. What files or directories can we remove to limit their
access?

Thanks for your help!
Norman Yuan - 29 Nov 2005 19:44 GMT
You do not need to run reporting services to design report with VS.NET. That
is, you can cut all your report developers' access to your reporting
services, they still can design report on their own computer, as long as
report designer is installed along with VS.NET and they have data source to
test it (of coourse they cannot test deployment).

> Hi,
>
[quoted text clipped - 5 lines]
>
> Thanks for your help!
clutch - 30 Nov 2005 14:11 GMT
Thanks for the reply. We've installed vs.net 2005 but don't see report
designer. How do you install it? Is there a snap-in or plug-in for Report
Designer?

Thanks!

> You do not need to run reporting services to design report with VS.NET. That
> is, you can cut all your report developers' access to your reporting
[quoted text clipped - 11 lines]
> >
> > Thanks for your help!
Ron Van Zanten - 30 Nov 2005 14:17 GMT
Hi Norman, we have the same issue. It seems that VS 2005 does not ship with
report designer. Can it be downloaded seperately?

> You do not need to run reporting services to design report with VS.NET. That
> is, you can cut all your report developers' access to your reporting
[quoted text clipped - 11 lines]
> >
> > Thanks for your help!
Bruce L-C  [MVP] - 30 Nov 2005 15:17 GMT
Install the client tools from RS 2005. It no longer requires having VS. It
comes with it's own VS that gets installed if you don't have it.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Hi Norman, we have the same issue. It seems that VS 2005 does not ship
> with
[quoted text clipped - 19 lines]
>> >
>> > Thanks for your help!
clutch - 30 Nov 2005 15:49 GMT
Hi Bruce,

We have installed the client tools from RS 2005 using the sql server 2005
release C2 disk. The problem is we need to be able to limit access to only
use Report Designer for certain developers. We don't want certain developers
to be able to use certain features such as SSIS, Analysis Services, Report
model designer, etc. Make sense? Is there a separate install for RS 2005
client tools?

Thanks for your help!

> Install the client tools from RS 2005. It no longer requires having VS. It
> comes with it's own VS that gets installed if you don't have it.
[quoted text clipped - 22 lines]
> >> >
> >> > Thanks for your help!
Bruce L-C  [MVP] - 30 Nov 2005 16:45 GMT
What you can do is they can develop but they cannot deploy. That is easy.
Also you can manage rights to the database which would determine what they
can do. Not sure about Report model designer. I don't know much about that.

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Hi Bruce,
>
[quoted text clipped - 38 lines]
>> >> >
>> >> > Thanks for your help!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.