Post reply

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

  • July 17, 2009 at 2:58 pm

    #202593

    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,

    _UB

    SqlTimes Blog on Sql Server

  • July 17, 2009 at 3:14 pm

    #1026458

    The simplest way would be to ensure that no windows accounts (including Builtin\administrators) are granted logon to the server. Either disable, revoke connect or drop them completely.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 22, 2009 at 9:17 am

    #1028400

    Thanks a lot for your suggestion.

    I am not sure if that's possible, but I'll try it as soon as I get access.... sometimes things happen slow here.

    SqlTimes Blog on Sql Server

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply