Post reply

Somebody connects to DB from Remote and changes the config values in the system- how to stop???

  • May 4, 2005 at 2:55 am

    #86127

    Friends,

    Contd from the last problem, the machine on which we hv hosted hte sql server 2K can also be seen by remote users - some smart users connect to the system through query analyzer and change the values in some of the configurations - which creates further problem for users.

    I am not able to find out a way out of this - to recognize and stop. I can nt disable the remote access as well.

    Can I trace the person and store this information somewhere??

    Thanks in Advance,

    Shashi

  • May 4, 2005 at 3:35 am

    #556696

    on which os your sql server installed?.

  • May 4, 2005 at 4:03 am

    #556706

    on Win 2k Advanced and win 2k - standard

  • May 4, 2005 at 6:05 am

    #556722

    First of all it is better don't allow remote access to Data server .I don't know what is specific to u to give remote access to users to eneter server.

    You can use event viewer security logs to view user details. Also u can put security policy to restrict users remote access to server.

    in sql u can use sql profiler to trace user and activities. u can put options according to your criteria.

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

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