Install QA only ?

If we want someone to use Query Analyzer only - allow end
user to run query by themselves, is it necessary for us to
install "Client Connectivity" on that machine as well?
Thanks
This is a duplicate post. It's been answered in another area.
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:01d601c528e5$f105d400$a401280a@.phx.gbl...
> If we want someone to use Query Analyzer only - allow end
> user to run query by themselves, is it necessary for us to
> install "Client Connectivity" on that machine as well?
> Thanks
>
|||Dear Paul,
You suggest to remove the userid from Public database role
as follow:
+++++++++++++++++++++++
If you remove the public role permissions to what it
should have (ZERO), and limit the access users have in the
databases, they won't be able to do anymore with EM than
QA.
+++++++++++++++++++++++
However, from the newsgroup, a lot of people suggest that
we should not remove any user from the Public Role. Is it
OK for me to do so ?
Besides, the user belongs to the db_datareader role only,
is there still any problem ?
Since we are not using Reporting Service, is there any
other way to meet the need ?
Thanks

>--Original Message--
>This is a duplicate post. It's been answered in another
area.
>"Paul" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:01d601c528e5$f105d400$a401280a@.phx.gbl...
end[vbcol=seagreen]
to
>
>.
>

Install QA only ?

If we want someone to use Query Analyzer only - allow end
user to run query by themselves, is it necessary for us to
install "Client Connectivity" on that machine as well?
ThanksThis is a duplicate post. It's been answered in another area.
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:01d601c528e5$f105d400$a401280a@.phx.gbl...
> If we want someone to use Query Analyzer only - allow end
> user to run query by themselves, is it necessary for us to
> install "Client Connectivity" on that machine as well?
> Thanks
>|||Dear Paul,
You suggest to remove the userid from Public database role
as follow:
+++++++++++++++++++++++
If you remove the public role permissions to what it
should have (ZERO), and limit the access users have in the
databases, they won't be able to do anymore with EM than
QA.
+++++++++++++++++++++++
However, from the newsgroup, a lot of people suggest that
we should not remove any user from the Public Role. Is it
OK for me to do so ?
Besides, the user belongs to the db_datareader role only,
is there still any problem ?
Since we are not using Reporting Service, is there any
other way to meet the need ?
Thanks

>--Original Message--
>This is a duplicate post. It's been answered in another
area.
>"Paul" <anonymous@.discussions.microsoft.com> wrote in
message
>news:01d601c528e5$f105d400$a401280a@.phx.gbl...
end[vbcol=seagreen]
to[vbcol=seagreen]
>
>.
>

Install QA only ?

If we want someone to use Query Analyzer only - allow end
user to run query by themselves, is it necessary for us to
install "Client Connectivity" on that machine as well?
ThanksThis is a duplicate post. It's been answered in another area.
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:01d601c528e5$f105d400$a401280a@.phx.gbl...
> If we want someone to use Query Analyzer only - allow end
> user to run query by themselves, is it necessary for us to
> install "Client Connectivity" on that machine as well?
> Thanks
>|||Dear Paul,
You suggest to remove the userid from Public database role
as follow:
+++++++++++++++++++++++
If you remove the public role permissions to what it
should have (ZERO), and limit the access users have in the
databases, they won't be able to do anymore with EM than
QA.
+++++++++++++++++++++++
However, from the newsgroup, a lot of people suggest that
we should not remove any user from the Public Role. Is it
OK for me to do so ?
Besides, the user belongs to the db_datareader role only,
is there still any problem ?
Since we are not using Reporting Service, is there any
other way to meet the need ?
Thanks
>--Original Message--
>This is a duplicate post. It's been answered in another
area.
>"Paul" <anonymous@.discussions.microsoft.com> wrote in
message
>news:01d601c528e5$f105d400$a401280a@.phx.gbl...
>> If we want someone to use Query Analyzer only - allow
end
>> user to run query by themselves, is it necessary for us
to
>> install "Client Connectivity" on that machine as well?
>> Thanks
>
>.
>sql

Install Client Connectivity (SQL Server 2000) Only w/ Less Files?

I have a 500-MB full installation CD for SQL Server 2000. All I need
is to install "Client Connectivity" component (about 272K) on a bunch
of workstations for users across the nation.

How do I reduce the installation file size, by eliminating most of the
unwanted files?

Thanks.(pengfrank@.gmail.com) writes:
> I have a 500-MB full installation CD for SQL Server 2000. All I need
> is to install "Client Connectivity" component (about 272K) on a bunch
> of workstations for users across the nation.
> How do I reduce the installation file size, by eliminating most of the
> unwanted files?

What precisely are you looking for? Client Connectivity is mainly
MDAC 2.6 I believe, even if there are also files needed for DB-Library.

If you are looking for MDAC, keep in mind that computers running
Windows XP and Windows 2003 already have MDAC 2.7 and 2.8 respectively.
For Windows 2000, Windows NT and the toy Windowses you need MDAC 2.6
though. But you can download MDAC 2.6 from www.microsoft.com. Be sure
to also download the latest service pack for the MDAC.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks for your information. I will just download the MDAC which has
only 5 MB.