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: SQL Resets
      ... If it were SQL that was falling short, ... The default backlog for SQL Server is 5. ... System.InvalidOperationException: Internal connection fatal error. ... From time to time, under heavy loads, we are getting resets at ...
      (microsoft.public.sqlserver.connect)
    • 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)
    • .Net framework error
      ... Unfortunately the information is very limited and usually the report just ... The application is a front end for a SQL Server 2005 Express database, ... connection string in the app config file. ...
      (microsoft.public.dotnet.languages.vb)
    • Re: connect to named instance w/ non-default port
      ... SQL Native Client Configuration. ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ...
      (microsoft.public.sqlserver.connect)
    • 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)