Access security

We have a database on the server that we hav set up security on. However the security is only valid on the machine it was set up on. We would like for the security to follow the database. In other words we would like the user to have to log on to the database to access it fromanywhere on the network. how can this be done?