deny a computer from connecting using sql authentication

From: z f (dont_at_send.mails)
Date: 09/19/05 

Date: Mon, 19 Sep 2005 17:31:36 +0200

Hi,

i'm using SQL server in my application, and connecting to it using SQL
authentication - providing user name and password.

i want (for validation purposes) to prevent a single computer from
connecting to SQL server even if providing the correct user/pwd.

is this possible?

TIA!!

Relevant Pages

  • Re: Connecting to MS SQL Express from other PC
    ... "Mixed mode" authentication enables SQL Server authentication AND SSPI (Windows domain) authentication. ... I also have a long whitepaper on connecting on my blog. ...
    (microsoft.public.sqlserver.connect)
  • Re: How to connect a workstation to SQL Server 2005 thru ODBC?
    ... and open the port in the Windows XP ... Welcome to the Getting Started with the Database Engine tutorial. ... Connecting to the Database Engine ... Either SQL Server Management Studio or Management Studio Express. ...
    (microsoft.public.sqlserver.connect)
  • RE: Connecting to SQL Server
    ... We are connecting to SQL Server via a SQL Server ODBC ... >Are you seeing any other types of authentication issues ... >Thank you for using Microsoft Partner Support. ...
    (microsoft.public.windowsxp.security_admin)
  • Use Single Sign on to connect to sql server
    ... connection in an excel file that connects using an odc file connecting using ... The logon account information that you configure here must match the logon ... Name: SQL Server ... If I'm connecting using a sql username, do i need to use the domain piece ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Using Widows Authentication and accesssing SQL with SQL Authentication
    ... See my blog post on connecting. ... SQL Server authentication. ... I am using windows authentication for my web application authentication ... I hope some one might have come accross the same problem ahd looking ...
    (microsoft.public.dotnet.framework.adonet)