Post reply

Windows Authentication over VPN

  • June 2, 2007 at 9:07 am

    #179098

    I am very new to SQL server having mostly used Access before. I want to build an application using VB.NET & SQL Server.

    Many of my users are remote and connect to my Windows Server using VPN connections. IE they log on to windows locally and then connect to the server via VPN.

    What I need to know is... can I use Windows Authentication for these users? Can their Database log on be derived from their account on the Windows Server (given in the VPN connection) or must it come from their actual windows log on (local)?

    I would really prefer to use Windows authentication as giving my users another password for the database is likely to cause endless problems.

    Any help appreciated. Thanks.

  • June 8, 2007 at 9:45 pm

    #711827

    Technically if your users are connecting through VPN using their network account (as they should) they should be able to connect to SQL Server as usual.

    Windows Authentication should work seemlessly.

    If you have firewalls in place make sure they are configured to allow the TDS protocol to go through.

    Regards

    Herve Roggero
    hroggero@pynlogic.com
    MCDBA, MCSE, MCSD
    SQL Server Database Proxy/Firewall and Auditing

  • June 9, 2007 at 2:18 am

    #711833

    Thank you very much for your reply. Thats made me happy!

    I thought that it might work but didn't want to waste time developing something that definately would not work.

    Regards

    Ian

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply