Deny login from certain hosts if logging in with specific sql credentials
Posted
by Dave
on Server Fault
See other posts from Server Fault
or by Dave
Published on 2010-05-26T15:06:44Z
Indexed on
2010/05/26
15:12 UTC
Read the original article
Hit count: 265
sql-server
|sql-server-2008
I want to stop some of our developers from connecting to the production sql server using a specific sql account. They have rights to connect through windows authentication with lower rights. They claim that changing the password will affect too many other processes running on our processing machine. So I want to deny access if they're connecting from there dev machines for now.
Another way this would work is if I could just allow connections from one specific host.
© Server Fault or respective owner