Re: Restricting domains from which a user can login using SQL Server login

From: Joubert Nel (j_at_j.j)
Date: 07/20/05 

Date: Wed, 20 Jul 2005 15:34:39 -0400

Hi Hari,

Is it possible to configure the Windows box on which SQL Server runs to only
allow connections from machines in a specific domain/domains?

Thanks
Joubert

"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:uLVGxAWjFHA.3656@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> You can not restrict the access if the users from other domain have access
> to the SQL Server. Only way to restirct is to remove / Deny their
> logins from SQL Server. See the system stored procedure sp_denylogin to
deny
> a group or user.
>
> Thanks
> Hari
> SQL Server MVP
>
> "Joubert Nel" <j@j.j> wrote in message
> news:OC2g7RUjFHA.3784@tk2msftngp13.phx.gbl...
> > Hi all,
> >
> > We are using mixed mode authentication (users connect to SQL Server
using
> > a
> > SQL login for historical reasons).
> >
> > We want to setup SQL Server / Windows Server to only allow users from
> > specified domains to be able to login with this SQL login.
> >
> > How can we configure this?
> >
> > Regards
> > Joubert
> >
> >
>
>

Relevant Pages

  • Re: Restricting domains from which a user can login using SQL Server login
    ... Only way to restirct is to remove / Deny their ... logins from SQL Server. ... See the system stored procedure sp_denylogin to deny ... > specified domains to be able to login with this SQL login. ...
    (microsoft.public.sqlserver.security)
  • Re: Column Level Permissions Security Issue
    ... role is granted SELECT rights as in "GRANT SELECT TO RWE", then a DENY ... When working with security in SQL Server it's imperative to understand ... discusses ownership chaining: http://www.sommarskog.se/dynamic_sql.html. ... there are users who have permission to access this ...
    (microsoft.public.sqlserver.security)
  • Re: Groups VS Users
    ... > The short question is why does SQL Server seems to deny access to a user ... Each group as slightly different permissions. ... access denied ACE will override all access allowed ACEs for the same ...
    (microsoft.public.sqlserver.security)
  • Re: Parameterized query problem
    ... Did you use SSMS to configure your SQL Server to use mixed ... Did you then create a SQL Login? ... You might consider using stored procedures ... ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: How do I find I am administrator?
    ... Procedure" and "Create View" for your SQL server user using the ... DENY statement; ... In this case even if you are db_owner for a database you will not able to do ...
    (microsoft.public.sqlserver.connect)