I think what you are looking for is simply SQL server security. You need to establish security logins to the database(s) you wish to secure. Provide the appropriate access to whomever needs it. Of course, if someone can access the sql server computer directly (sit down at a terminal or login thru remote desktop) then it's likely that they can just launch the management tools from the terminal with administrative access. I'm not sure what you can do about that.
-
Peter