Restricted Trusted Connections

Is is possible to set security on MS SQL, so that the database will only
accept requests from known IP address or hostnames such as a Web Server ?

I have set up Kerebros authentication via SPNs, so domain users accessing a
Web Application can use trusted connections to access the database. But I
want to prevent them launching osql sessions, and connecting directly with
the database.

thanks, Brian




.

Relevant Pages

  • Re: Security
    ... I don't have the SAMS book, so I don't know what they have had you do. ... MS has a Security FAQ that should answer most of your questions. ... Access Database Samples: www.rogersaccesslibrary.com Want answers to your Access questions in your Email? ... I am worried that he may try> to copy it and threfore want to set security. ...
    (microsoft.public.access.gettingstarted)
  • All databases including new ones require password!
    ... I have been practicing Access 2000 with the Northwind database and ... attempting to set security. ... not using it I came back to make a new database and found I could not open ... username/password say security is not set. ...
    (microsoft.public.access.security)
  • Re: Write-mode password protection
    ... In order for anyone to just open the database the database and folder it ... invoke user-level security on your database. ... However, before you attempt to set security, ... > already modifying the data file, then i want this user to know he can only ...
    (microsoft.public.access.security)
  • Re: Password Protecting Program?
    ... >I looked at your instructions to set security on a database. ... > have to go through this process everytime you have a different database ... database files affiliated to a single workgroup. ...
    (microsoft.public.access.gettingstarted)
  • Re: Is it possible to protect SQL2000 db so that the admin does not access
    ... access and not even ADMin is able to access with trusted connections ... SQL Server sysadmin role members have full permissions in all databases. ... You will need to limit sysadmin role membership so that only desired users have sysadmin role membership. ... This will prevent Windows Administrators from accessing the database using Windows authentication. ...
    (microsoft.public.sqlserver.programming)
Quantcast