Limiting access to Report Designer Only

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!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).
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
> 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!|||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!
"Norman Yuan" wrote:
> 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).
> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
> > 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!
>
>|||Hi Norman, we have the same issue. It seems that VS 2005 does not ship with
report designer. Can it be downloaded seperately?
"Norman Yuan" wrote:
> 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).
> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
> > 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!
>
>|||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.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ron Van Zanten" <RonVanZanten@.discussions.microsoft.com> wrote in message
news:6C6447BE-DFC7-424B-9EAF-F99436A7DD12@.microsoft.com...
> Hi Norman, we have the same issue. It seems that VS 2005 does not ship
> with
> report designer. Can it be downloaded seperately?
> "Norman Yuan" wrote:
>> 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).
>> "clutch" <clutch@.discussions.microsoft.com> wrote in message
>> news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
>> > 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!
>>|||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!
"Bruce L-C [MVP]" wrote:
> 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.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ron Van Zanten" <RonVanZanten@.discussions.microsoft.com> wrote in message
> news:6C6447BE-DFC7-424B-9EAF-F99436A7DD12@.microsoft.com...
> > Hi Norman, we have the same issue. It seems that VS 2005 does not ship
> > with
> > report designer. Can it be downloaded seperately?
> >
> > "Norman Yuan" wrote:
> >
> >> 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).
> >>
> >> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> >> news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
> >> > 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!
> >>
> >>
> >>
>
>|||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.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:0E6CFB95-93CB-4537-989C-0E13C37A7228@.microsoft.com...
> 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!
> "Bruce L-C [MVP]" wrote:
>> 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.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Ron Van Zanten" <RonVanZanten@.discussions.microsoft.com> wrote in
>> message
>> news:6C6447BE-DFC7-424B-9EAF-F99436A7DD12@.microsoft.com...
>> > Hi Norman, we have the same issue. It seems that VS 2005 does not ship
>> > with
>> > report designer. Can it be downloaded seperately?
>> >
>> > "Norman Yuan" wrote:
>> >
>> >> 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).
>> >>
>> >> "clutch" <clutch@.discussions.microsoft.com> wrote in message
>> >> news:C5788379-967C-4EC3-B561-57E19C898AC1@.microsoft.com...
>> >> > 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!
>> >>
>> >>
>> >>
>>

Limiting a users resource ie CPU, disk and/or memory

We are currently using Great Plains. This accounting package runs on SQL Server and we have performance problems running integration manager. The result is that users can not get work done when integration manager is running.
Is there any way I can limit the user running integration manager to a certain amount of CPU time and allocate the rest to the other users?
In Oracle, this is easy - I could just use resource plans, but I don't know if there is a way to do this with SQL Server 2K.
TIA
No, SQL Server does not support the ability to limit the amount of =
resources an application or a connections uses.
--=20
Keith
"ramick" <anonymous@.discussions.microsoft.com> wrote in message =
news:9327DE01-32DA-47B7-917F-E2513C31CB5C@.microsoft.com...
> We are currently using Great Plains. This accounting package runs on =
SQL Server and we have performance problems running integration manager. =
The result is that users can not get work done when integration manager =
is running.
>=20
> Is there any way I can limit the user running integration manager to a =
certain amount of CPU time and allocate the rest to the other users?
>=20
> In Oracle, this is easy - I could just use resource plans, but I don't =
know if there is a way to do this with SQL Server 2K.
>=20
> TIA

Limiting a users resource ie CPU, disk and/or memory

We are currently using Great Plains. This accounting package runs on SQL Se
rver and we have performance problems running integration manager. The resu
lt is that users can not get work done when integration manager is running.
Is there any way I can limit the user running integration manager to a certa
in amount of CPU time and allocate the rest to the other users?
In Oracle, this is easy - I could just use resource plans, but I don't know
if there is a way to do this with SQL Server 2K.
TIANo, SQL Server does not support the ability to limit the amount of =
resources an application or a connections uses.
--=20
Keith
"ramick" <anonymous@.discussions.microsoft.com> wrote in message =
news:9327DE01-32DA-47B7-917F-E2513C31CB5C@.microsoft.com...
> We are currently using Great Plains. This accounting package runs on =
SQL Server and we have performance problems running integration manager. =
The result is that users can not get work done when integration manager =
is running.
>=20
> Is there any way I can limit the user running integration manager to a =
certain amount of CPU time and allocate the rest to the other users?
>=20
> In Oracle, this is easy - I could just use resource plans, but I don't =
know if there is a way to do this with SQL Server 2K.
>=20
> TIA

Limiting a users resource ie CPU, disk and/or memory

We are currently using Great Plains. This accounting package runs on SQL Server and we have performance problems running integration manager. The result is that users can not get work done when integration manager is running
Is there any way I can limit the user running integration manager to a certain amount of CPU time and allocate the rest to the other users
In Oracle, this is easy - I could just use resource plans, but I don't know if there is a way to do this with SQL Server 2K
TIANo, SQL Server does not support the ability to limit the amount of =resources an application or a connections uses.
-- Keith
"ramick" <anonymous@.discussions.microsoft.com> wrote in message =news:9327DE01-32DA-47B7-917F-E2513C31CB5C@.microsoft.com...
> We are currently using Great Plains. This accounting package runs on =SQL Server and we have performance problems running integration manager. = The result is that users can not get work done when integration manager =is running.
> > Is there any way I can limit the user running integration manager to a =certain amount of CPU time and allocate the rest to the other users?
> > In Oracle, this is easy - I could just use resource plans, but I don't =know if there is a way to do this with SQL Server 2K.
> > TIA