Disable or prevent Trusted Connection (-E) logins [DDL triggers]

[topub]

Guys,

Is it possible to disable or prevent Trusted Connection logins to Sql Server Express 2005 installed on a laptop for non-admin accounts using DDL triggers?

Also, could I restrict any login attempts, either Windows Authentication or Sql Server authentication, to only admin and webserver accounts.

Any sample code or link to an article would help a lot.

thanks,
_t

 

[mrdenny]

Yes, you could do this via a DDL trigger. Why not simply not grant those users logins to the SQL Server. If they don't have a login to the SQL Server then they won't be able to logon to the instance.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog