Post reply

Stop user to Register Production SQL Server2000

  • October 10, 2006 at 12:12 am

    #115123

    Dear all,

    I want to stop user registering Production SQL Server2000.

    As they know sa password and i cant change the sa password for some reason.

    I need to ask how can i stop user registering the production sql sever.

     

    Regards

    Killer

  • October 11, 2006 at 3:33 am

    #665170

    Threaten them with disciplinary action if they persist in connecting to the server?

     

    Chris

  • October 11, 2006 at 6:28 am

    #665191

    There really isn't any way to stop the user from registering the server.

    You could run a job that KILLs spids by host name (the machine name), but EM automatically reconnects, so that's no good.

    If you don't use SQL Logins, you could change the server's authentication mode to Windows Only.

    Why can't you change the sa password? That's probably the only way to achieve your goal.

  • October 12, 2006 at 7:48 pm

    #665625

    Dear Chris,

    !!! I Liked ur answer.

    I will try to do that but i am afraid they  wont stop !!!!!!!!!

     

    Regards

    Killer

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

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