DPE and Report Models

To my horror I have discovered that you can not specify a provdier that
is anything other than SQL Data Provider in a report model project.
Here's my problem. I'd like to provide one set of models for my schema
and be able to dynamically change the connection string using a DPE
that we have developed.
This way I publish the models and the datasource and we can connect to
different DB's at runtime.
If this can be done in a standard report project why can't it be done
in a report model project?
If this is "impossible" are there any plans to support custome DPE's
with report models in the next service pack / version.
Help, at the moment we have to maintain and publish a set of models for
every client we have that has their own database and majority of the
schema's are identical.
Regards
Toby.Ok found some more providers, but no DPE.
Toby|||Tobi wrote:
> Ok found some more providers, but no DPE.
> Toby
Anybody for any Ideas? Anybody There? Help?sql

Domain admin?

Hi,
Can I specify "read only" to one of the member of Domain admin? how to do
that?
Thanks...You can post this in the Security section for a definite answer but I think
to do this you need to remove Domain Admins and Local Admins from your SQL
Server Logins or restrict the whole group to have lower access and then give
more permissions to individuals.
Jeff Duncan
MCDBA, MCSE+I
"js" <js@.someone@.hotmail.com> wrote in message
news:eSc3ZerLEHA.3904@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Can I specify "read only" to one of the member of Domain admin? how to do
> that?
> Thanks...
>

Domain admin?

Hi,
Can I specify "read only" to one of the member of Domain admin? how to do
that?
Thanks...
You can post this in the Security section for a definite answer but I think
to do this you need to remove Domain Admins and Local Admins from your SQL
Server Logins or restrict the whole group to have lower access and then give
more permissions to individuals.
Jeff Duncan
MCDBA, MCSE+I
"js" <js@.someone@.hotmail.com> wrote in message
news:eSc3ZerLEHA.3904@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Can I specify "read only" to one of the member of Domain admin? how to do
> that?
> Thanks...
>

Domain admin?

Hi,
Can I specify "read only" to one of the member of Domain admin? how to do
that?
Thanks...You can post this in the Security section for a definite answer but I think
to do this you need to remove Domain Admins and Local Admins from your SQL
Server Logins or restrict the whole group to have lower access and then give
more permissions to individuals.
--
Jeff Duncan
MCDBA, MCSE+I
"js" <js@.someone@.hotmail.com> wrote in message
news:eSc3ZerLEHA.3904@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Can I specify "read only" to one of the member of Domain admin? how to do
> that?
> Thanks...
>

Domain admin?

Hi,
Can I specify "read only" to one of one member of Domain admin? and still
keep Other Domain admin full access righrs. how to do that?
Thanks...
<<You can post this in the Security section for a definite answer but I
think
<<to do this you need to remove Domain Admins and Local Admins from your SQL
<<Server Logins or restrict the whole group to have lower access and then
give
<<more permissions to individuals.
Jeff Duncan
MCDBA, MCSE+I
"js" <js@.someone@.hotmail.com> wrote in message
news:eSc3ZerLEHA.3904@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Can I specify "read only" to one of the member of Domain admin? how to do
> that?
> Thanks...
>This is defined by granting access to the server. Remove domain admins
from the local admins if they are part of that group.
Add either individual nt users or create a new group and grant them
restricted permissions, like only select rights from a table. There is no
"read only " attribute for SQL. The closest thing we have is select access
to a view.
See this link for our best practices.
http://www.microsoft.com/technet/pr...n/sp3sec00.mspx
Hope this helps.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.