Re: Allowing only certain clients access to SQL Server 2K

From: Kresimir Radosevic (kresimir.radosevic@zg.tel.hr)
Date: 01/21/03 

From: "Kresimir Radosevic" <kresimir.radosevic@zg.tel.hr>
Date: Tue, 21 Jan 2003 16:42:06 +0100

select net_address from sysprocesses where spid = @spid

-- will give you the address, maybe this can help you
-- QUERYING SYSTEM TABLES DIRECTLY IS NOT RECOMMENDED

Kresimir Radosevic, SQL MVP

I support the Professional Association for SQL Server and its user community
of dedicated professionals.
www.sqlpass.org

"Raj Bhaskar" <r.bhaskar@compserv.gla.ac.ukNOPSAMFOO> wrote in message
news:O6vOxyTwCHA.2868@TK2MSFTNGP12...
> Hi folks,
> I want to increase security on my SQL Server database by restricting
> access to a small group of machines (based on IP address on our
> intranet). I can't find any way of doing this. Eg, so that I can set it
> to only accept connections from localhost, or the IP range 192.168.5.xx.
>
> Thanks,
> Raj.
>

Relevant Pages

  • Re: Allowing only certain clients access to SQL Server 2K
    ... I support the Professional Association for SQL Server and its user community ... "Raj Bhaskar" wrote in message ... it said "Must declare variable @spid". ...
    (microsoft.public.sqlserver.security)
  • Re: Can you use osql in DTS?
    ... Dim pkg, task, spid ... Columnist, SQL Server Professional ... the variable I need to pass into a stored procedure and have it function ... >> osql. ...
    (microsoft.public.sqlserver.dts)
  • Re: Can you use osql in DTS?
    ... Dim pkg, task, spid ... Columnist, SQL Server Professional ... the variable I need to pass into a stored procedure and have it function ... >> osql. ...
    (microsoft.public.sqlserver.programming)
  • Re: Can SELECT block UPDATE?
    ... a select can block an update depending on the isolation level. ... Here is a link to the SQL Server 2000 BOL topic: ... Selecting in the READ UNCOMMITTED isolatino level, or using the NOLOCK hint, is the least restrictive locking, but as the notes explain, it has its downsides as well. ... I tried to find spid that was causing the block, ...
    (microsoft.public.sqlserver.server)
  • Re: Whats the deal with PAGEIOLATCH_SH?
    ... I checked the spids from Enterprise Manager and there is ... >blocking. ... Have you checked sp_lock to see if the spid is blocked by another ... >> I'm seeing some strange performance problems with my SQL server (8.0 ...
    (microsoft.public.sqlserver.programming)