I have a requirement to ensure that our service accounts (that connect to SQL) are not used by anyone but the by the APPLICATION itself (also excluding access via SSMS)
I have a requirement to ensure that our service accounts (that connect to SQL) are not used by anyone but the by the APPLICATION itself (also excluding access via SSMS)
Hi John. I want to guarantee my SQL connections are only allowed from one source, in this case, from the application server. All other connections must be refused.
I think that I'd do this at the network level as it'll probably be easy to manage. Secondly you could use windows Firewall to block any connections other than certain IP's. However, with that said, you're going to want to allow 1433 for any DBA's so that they can administer the instance.
20 People are following this question.