Accesing data from many applications.

Hi, I have a server running sql server 2000 sp3. In this sql server we
use windows authentication to allow users to use the applications that
were developed in house.

At this moment we have some users that are using excel to get data from
databases but we don´t want they do that, because we can´t control the
data they are getting.

We want to restrict that all users can get data only using the
applications that are developed in house.

Do you know if in sql server I can restrict wich applications can be
connected to sql server and wich not??

I need to continue using windows authentication.

Thanks a lot for your help.


*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Application Security
    ... these Windows Forms applications, ASP.NET applications, Windows services, or ... I assume that your C# clients are not distributed to end users. ... > There is a global SQL Server userid and password. ...
    (microsoft.public.dotnet.security)
  • Re: Quorum Disk or Majority Node?
    ... LOT of 3rd party applications where every issue is always blamed on ... See "Sizing a Majority Node Set Cluster" ... When SQL Server 2005 starts supporting database mirroring there is ... SQL Server does not NATIVELY support MNS clustering. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Need tips on moving from MSAccess to MSSQL
    ... Thanks for sharing the path you're taking to upgrade. ... > -utilize the sql server response as much as it or I am capable... ... >>>Having applications that today work with MSAccess using dbGO. ...
    (borland.public.delphi.database.ado)
  • Re: VS 6 to VS.Net justification
    ... I am concerned, however, that we are using Sql Server 2005. ... Look for info on VSTO (Visual Studio Tools for Office) VS 2005 version. ... Future applications will need RAD, but I have to admit, I am not convinced ... on that issue from what I've seen yet; let alone convince someone else. ...
    (microsoft.public.vsnet.general)
  • Re: Need tips on moving from MSAccess to MSSQL
    ... also some connectivity to as/400 via odbc to retrieve data ... -utilize the sql server response as much as it or I am capable... ... >>Having applications that today work with MSAccess using dbGO. ...
    (borland.public.delphi.database.ado)