windows authentication question

From: Keith G Hicks (krh_at_comcast.net)
Date: 08/31/05 

Date: Wed, 31 Aug 2005 10:29:47 -0400

I'm setting up an app to access a SQL 2000 db and have been reading that
it's more secure and easier to manage by using windows authentication rather
than SQL authentication. So far this makes sense as my client app won't have
to pass a user name or password to the SQL db.

However, what do I have to do to prevent most users from being able to get
into the backend through something like enterprise manager? How do I limit
this access?

This is not a web app, it's just a win32 exe that will run on several
workstations on a LAN where the SQL server might be running on either a
separate server box or might be running on one of the workstations in a P2P
network.

Thanks,

Keith

Relevant Pages

  • Re: ODBC Timeout problems but very hard to pin down
    ... APP 1: Access 2000 database ... I ran SQL Profiler to capture the ... validated by SQL Server. ... As it happens, the default display contains ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Openrowset Jet OLEDB
    ... Front end app means the app we wrote and wich the users use to modify the ... This works fine in our development enviroment where the sql service is ... And what do you mean by "speedily import an mdb into the ... > Microsoft Access Developer's Guide to SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Login failed for ServerGuest
    ... SQL Server clients are authenticated as guests if Simple ... >| I have noticed that when I try to log in using Windows Authentication ... >|> You can enable the guest account but that's a security risk ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL 2000 NT AUTHORITYSYSTEM Permission Problem
    ... Not associated with a trusted SQL Server connection. ... However, if you deal with the Domain controller, most of the controls there ... > Forms app and a VB6 app. ...
    (microsoft.public.sqlserver.security)
  • Re: integrated security over vpn
    ... SQL 2000 is using Windows Authentication, and I can access tables, Stored ... > Are you using Windows authentication with SQL Server or SQL Server ... > easy to do on a home machine scenario as I would expect the home machine ...
    (microsoft.public.dotnet.security)