Application Role

Hi,
We have many applications in our organisation and the backend we are
using is sql server 2000 with SP4. some Application using window
Authentication and some using sql Authentication.
but i do not want user or other person can use the same login details
and access the same through sql server client.can anyone please
explain the steps for the same
ThanksI suggest you read up on "application roles".
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Abhi" <bawejaji@.gmail.com> wrote in message
news:1176442814.552866.165150@.d57g2000hsg.googlegroups.com...
> Hi,
> We have many applications in our organisation and the backend we are
> using is sql server 2000 with SP4. some Application using window
> Authentication and some using sql Authentication.
> but i do not want user or other person can use the same login details
> and access the same through sql server client.can anyone please
> explain the steps for the same
> Thanks
>