Re: deny a computer from connecting using sql authentication

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/22/05 

Date: Wed, 21 Sep 2005 19:34:51 -0600

I can't think of any way to do something like that. Only odd
way I can think of is if it's an application and you used
application security and build in a machinename check into
the application - so that it can't connect from that one
computer.

-Sue

On Wed, 21 Sep 2005 09:23:48 +0200, "z f" <dont@send.mails>
wrote:

>this way i dany any connection from this computer, even windows
>authenticated.
>i want just to deny the sql authentication connection to not be from this
>computer.
>maybe it's just not possible...
>
>thanks.
>
>
>"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
>news:vivui1dguhq8hu0dj1u74jho9fatboebbo@4ax.com...
>> You could use IPSec policies to enforce what computers can
>> connect to the server that is running SQL Server.
>>
>> -Sue
>>
>> On Mon, 19 Sep 2005 17:31:36 +0200, "z f" <dont@send.mails>
>> wrote:
>>
>>>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!!
>>>
>>>
>>
>