secure sqlserver production box

  • Hi,

    we are going to install a new sqlserver 2005 enterprise edition for production environment.

    please clarify these points

    1) production sql server need to install on local system or domain or active dir on win?

    2) how to restrict the unanimous users access to critical db's

    3) what are the security consideration need to take from installtion to creating logins, users , assigning roles etc...

    Thanks in advance

  • No body responded till

    Please reply

  • After reading your post i have impression that you are not a DBA. then my suggestion would be hire a professional , dont play with security section directly on production above of all your question is not specific to one point ,you need to know/understand complete IN or OUt of securites

    please refer following links

    SQL Server Security Part 1 [/url]

    SQL Server Security Part 2 [/url]

    SQL Server Security Part 3 [/url]

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • Thanks for the replys

    I will go throw this thoroughly.

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

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