sql server web edition 2014
I have a production and qa database on a server with an iis app running on the same box. Both db's can be accessed from my remote development machine but now I would like to allow remote access only to the qa db, and since iis is local to the production environment I would like only local access (windows integrated security?) to the production db.
I believe I already have a firewall rule in place that only allows my remote ip address to have remote access, which since in place has stopped the brute force attacks on the sa account (which I have disabled), but I'd like to add this additional layer of security, while still allowing remote access to my qa db.
Everything I've found on the subject seems to work on the entire sql server, not individual db's, is this possible to do?