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

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/20/05 

Date: Thu, 21 Jul 2005 00:51:08 +0530

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

  • Connectivity to SQL Server 2000 in Different Domain using SQL Login Failing
    ... I'm trying to connect to a remote office's SQL Server 2000 database. ... I've had someone at the local office create a SQL Login as a SysAdmin ... SQL Server is running on the correct port, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Login Problem
    ... Can you catch native SQL Server error? ... Are you using a SQL login and have ... Windows authentication only enabled? ...
    (microsoft.public.sqlserver.setup)
  • Re: sa login
    ... automatically makes you a member of the SYSADMIN role in SQL Server 2000. ... > instance is set to Windows autentication only. ... > connect using the SQL login - it works. ...
    (microsoft.public.sqlserver.security)
  • Re: Connection to a MS SQL Server Table (newbie)
    ... > home machines with IIS and MS SQL Server. ... you would create a sql login with limited permissions in your ... > It is basically a departmental personnel database tailored to our ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Restricting domains from which a user can login using SQL Server login
    ... Is it possible to configure the Windows box on which SQL Server runs to only ... allow connections from machines in a specific domain/domains? ... Only way to restirct is to remove / Deny their ... >> specified domains to be able to login with this SQL login. ...
    (microsoft.public.sqlserver.security)