How to lock the database...

• susant-920558

  SSC Rookie

  Points: 26

  More actions

  December 25, 2008 at 11:35 pm

  #199396

  hi all

  Problem

  ----------------

  There are number of databases in my SQLExpress-2005.. like..

  1: Master

  2: Pubs

  3: Inventory..

  My application related database is Inventory...

  Requirement..

  -----------------

  1: No can open that database..

  sug..

  -------

  I can do it by adding users... but the problem is like whenever user is giving windows authentication then any1 can see.. so how to lock my database...in windows authentication mode also..

  Susant
  9967487567

• ps.

  One Orange Chip

  Points: 29422

  More actions

  December 25, 2008 at 11:45 pm

  #917693

  hi all

  Problem

  ----------------

  There are number of databases in my SQLExpress-2005.. like..

  1: Master

  2: Pubs

  3: Inventory..

  My application related database is Inventory...

  Requirement..

  -----------------

  1: No can open that database..

  sug..

  -------

  I can do it by adding users... but the problem is like whenever user is giving windows authentication then any1 can see.. so how to lock my database...in windows authentication mode also..

  If you're allowing domain1\user1 to login to the database, only he can connect to the server (unless u've password sharing or all users are using same id password which is bad)...

  in fact windows authentication is far more secure than sql server authentication as ur passwords need not travel over the network for authentication.

  Can you provide more details on what exactly is happening and your requirement?

  ---

  
  Pradeep Singh

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736212

  More actions

  December 26, 2008 at 9:03 am

  #917818

  Remove rights from the database (permanent)

  Set to single user mode and grab a connection

• Vee

  Hall of Fame

  Points: 3028

  More actions

  December 28, 2008 at 12:39 pm

  #918185

  It looks like your sql server security logins has a login Built\Administrators. Just remove that. But before removing ensure that you know sa password and add the service account exclusivly to your security logins. You may then need to add exclusively individual windows accounts to sql server logins. you can create a windows ad groups and then add these individual accounts to their respective group and add the groups to sql server logins.