Re: deny a computer from connecting using sql authentication

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

  • Next message: Hugh Mungo: "Windows Authentication and global.asa" 
    Date: Wed, 21 Sep 2005 09:23:48 +0200

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

  • Next message: Hugh Mungo: "Windows Authentication and global.asa"

    Relevant Pages

    • Re: provider: Named Pipes Provider, error: 40 - Could not open a c
      ... I have tried connecting to Sql Management Studio and it worked pretty much ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ... I have a sql server install / database on the web server. ...
      (microsoft.public.sqlserver.connect)
    • Re: Connecting to SQL w/ADO
      ... Again, I suggest picking up ... I would not use the ODBC provider to access SQL Server. ... but the SQL connection is new territory for me. ...
      (microsoft.public.vb.database)
    • Re: Login failed for user . The user is not associated with a trusted SQL Server connection.
      ... run under a domain account with access the sqlserver. ... want to connect to an SQL 2005 server running on Windows 2003. ... My SQL server is set ... server with that, it reports that the test connection is successful, ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Whats My Password?
      ... If 2 then you have to make sure your sql express is configured to allow sql authentication. ... Specifically, the database connection stuff. ... I finally managed to create a database and enter some data within the VS IDE. ... When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Concurrent database access in SQL 2005 Mobile
      ... Please stick to having an "dummy" connection in Open State. ... SQL CE/Mobile has a background thread that flushes the changes ... they run for long hours and we have not seen memory leaks so far. ... then opens his work forms and it's in ...
      (microsoft.public.sqlserver.ce)