Re: deny a computer from connecting using sql authentication

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

  • Next message: Meenal Dhody: "Re: Database roles" 
    Date: Mon, 19 Sep 2005 21:14:54 -0600

    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!!
    >
    >

  • Next message: Meenal Dhody: "Re: Database roles"

    Relevant Pages

    • Re: Suddenly Unable to connect to other machines on local network
      ... I don't know what the SSPI error means offhand but the KB article below may ... Users and Computers and on the domain computers if your account is supposed ... > SQL Server 2005 instance on a Windows 2003 Server on my domain. ... > It seems highly improbable that installing an up grade would cause ...
      (microsoft.public.windows.server.security)
    • Re: Microsoft installed software?
      ... concerned with is SQL server and Microsoft visual J#.net. ... running stand alone with dial up connection. ... the old PIII. ... computers can access the internet, ...
      (microsoft.public.windowsxp.general)
    • Re: Visual Basic 6.0 problem!
      ... This assumes that the SQL Server has an account setup for the Windows user or the group in which they are a member. ... it only works on SOME of the computers I install it on. ... Sub Main ... For some computers, this code works just fine and the program runs ...
      (microsoft.public.vb.database.ado)
    • Connect via workgroup
      ... I am trying to connect to an SQL Server using a vb.net program. ... I do not know why it is using Guest instead of the User ID that I specified. ... I also activated the Guest account in XP for both machines. ... I turned off the Windows firewall on both computers. ...
      (microsoft.public.sqlserver.connect)
    • RE: WSUS 3.0 Errors
      ... Thanks for your suggestion, however it did not seem to solve the problem for ... The unexpected error is still occuring whenever I try to browse computers ... - download and install MS SQL Server 2005 Command Line Query Utility ...
      (microsoft.public.windowsupdate)