Post reply

physical access to the SQL Server

  • August 14, 2002 at 4:44 pm

    #78717

    Hi folks. As part of my security procedure,

    I'm trying to restrict physical access to the SQL Server. Can anyone tell me how I would accomplish that?

    thx

  • August 14, 2002 at 5:58 pm

    #434590

    Put it in a room and lock the door?

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • August 15, 2002 at 10:43 am

    #434642

    As Andy says, put it in a room and lock the door with you being the only person with the combo or key.

    We have our server hardware in two racks and they are locked.

    -SQLBill

  • August 15, 2002 at 10:51 am

    #434644

    Thanks guys. I wish I could have that luxury.

    There is a critical SQL Server installed on the computer that I use here at work.

    I don't know who did it this way, but it's pathetic.

  • August 15, 2002 at 11:04 am

    #434647

    What type of computer? Do you need easy access to it? One option is a Raritan KVM module. You take your computer, put it where it can't be accessed easily (locked closet, whatever), attach one part of the KVM to the computer, run a CAT 5 cable to your monitor where you put the other part of the KVM. This solution lets you use your monitor while the computer is in a different location.

    -SQLBill

  • August 15, 2002 at 8:25 pm

    #434675

    You didn't say what OS you are using. You can control who has rights to log on locally.

    If you are using Windows NT 4.0, bring up User Manager and point it that particular server (Domain is \\ServerName). On one of the menus (I can't remember and don't have an NT 4 box where I'm at), there is the option to modify user rights. You can set who can log on locally.

    Under Windows 2000, this is under the local security policy. You'll find it at Start | Programs | Administrative Tools | Local Security Policy or Start | Settings | Control Panel | Administrative Tools | Local Security Policy. Under Local Policies | User Rights Assignment you'll find a policy for Log On Locally.

    This controls what user accounts can log in. It is not effective if the person knows the user name and password to a user account that has been granted the ability to log on. So it will not address all your physical security concerns.

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.truthsolutions.com/

    K. Brian Kelley
    @kbriankelley

  • August 16, 2002 at 12:02 pm

    #434727

    Thanks, bkelley. This is exactly what I was looking for.

    Thanks for all your help...

Viewing 7 posts - 1 through 6 (of 6 total)

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