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 11:05:07 -0400

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: 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)
  • 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)