We're planning to move a large portion of our database to our web host's SQL server. The SQL server is only accessible through SQL logins. Is there any way to set something up locally that would recognize users' windows credentials and automatically provide them access to the remote database?
This would make it easier on the users since they wouldn't have to come up with yet another set of login credentials, and it would be easier on me since I wouldn't have to maintain them separately.
The simplest solution I imagined would be to store the login credentials in some shared location only accessible by people who should be allowed to access the database. However, this strikes me as an extremely naive solution, and possibly full of security holes.
Another option that crossed my mind would be to use a web interface hosted on our main server. Then only that site would need the login credentials. However, this wouldn't really work as well if we wanted to do something more advanced (say a windows forms app or Access-based reports).
Ideally I'd like some sort of SQL proxy, but google isn't being much help in that regard.
Any thoughts?