I have multiple databases created in sql2000 and my server is on a network where client machines also has their own sql server instances with databases and we all are using a standard username of "sa" and password :microsoft"
This allows all the users over the network to register each one's sql server on their own local machines and access all databases
Now I want to block certian users from accessing certain databases on my server, kindly anybody help me doing this?
Stop using Sa and implement Windows authentication using Windows Groups or windows accounts. By using groups and group membership there will be less SQL login /user administration.
Change the sa password on the server. Then give the developers access only to what they need via a different identity. Either a trusted connection via domain security or a different sql user.