RE: Prevent direct connections

From: Mark Allison (marka_at_no.tinned.meat.mvps.org)
Date: 03/29/04 

Date: Mon, 29 Mar 2004 02:21:08 -0800

If the application resides on an application server then you might want to consider placing a firewall on the SQLServer, or placing SQL Server behind one. Then, you can restrict access to the SQL Server by IP address to only the application server and DBA team.

If this is not possible then you can apply some control by denying direct access to user tables and only allowing it through stored procedures. If you apply the appropriate permissions to the stored procedures, you will have a little more control. 

--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk

Relevant Pages

  • datagrid control & stored procedures - how to use together
    ... I'm using all stored procedures, necessarily, and am having quite a bit of ... The control apparently presumes access directly to tables, ... but my environment requires -all- access to the db to be abstracted through ... vb.net - and using stored procs /TDS to select from and update the db? ...
    (microsoft.public.vb.database)
  • Re: SP Source Control Options
    ... > relies heavily on Stored Procedures on SQL 7. ... > What options are there to implementing Source Control on ... Script them out of SQL Server, ... control system. ...
    (microsoft.public.sqlserver.security)
  • Re: SP Source Control Options
    ... > relies heavily on Stored Procedures on SQL 7. ... > What options are there to implementing Source Control on ... Script them out of SQL Server, ... control system. ...
    (microsoft.public.sqlserver.security)
  • Re: This seems slow...Why???
    ... Is your table bound to a control or controls? ... I've gotta form with the following code in the ... > The DataAdapter is using Stored Procedures and I'm seeing dismal ... performance on my local development machine. ...
    (microsoft.public.dotnet.framework.adonet)