You can setup a server to host the database and then if you need your database to avaialble to the users not connected to the same network then provide it a public IP so that it can be accessed over internet. Else if the users connected to the same network then you can provide them access through the local IP too.
Then you need to configure your SQL Server to allow remote access
http://stackoverflow.com/a/11278115/1006297[
^]
You also need to change the connection string accordingly.
Hope, it helps :)