Trusted Connections

[m_e_wade]

All,

Have a client:
Win 2000 Enterprise Server
SQL Server 2000
Xe, SP17

Client is trying to lock down security. Did all the usual, i.e. JDE account, SA on database, etc. Looking good so far.

He noticed that if a user links a database to MS Access on his local fat client the user can just select "Use Trusted Connection" on the ODBC connection and gets right in.

How do we lock this down. Doesn't seem like we are doing much good locking down everything on the front end and any user on the NT Domain can come in from the back and connect to databases/tables.

Any Suggestions?

-MEW

Mike Wade
cd|group
5550 Triangle Parkway
Suite 200
Norcross, GA 30092
email: [email protected]

 

[jdecnc]

Mike,

Check the Logins under Security on your SQL server. Sounds like either the individual users or a group (possibly everyone or Domain users) on your NT Domain has been setup with a login and that will allow them to use the Trusted Connection.

Robby

XE U3 SP17 Windows2000 SQL2000