Limited access to the DB for certain services.

• bet-597538

  Old Hand

  Points: 342

  More actions

  May 15, 2009 at 4:27 am

  #204945

  Hello, I wonder is it possible to give some services limited access to the some of DBs on SQL Server. I mean, some service will have access to certain DB, but not to the others on the same server.

  Can you give me some advice? I'm checking MS documentation too.

• Samuel Vella

  SSCrazy Eights

  Points: 8055

  More actions

  May 15, 2009 at 5:05 am

  #995195

  create a windows login for the service to run under

  add this windows user as a database user and then only give it rights to the specific databases you want it to access.