SQL Server over Virtual Private Network

[StyleGuide]

Hi All, A couple of basic questions - can SQL server run over a VPN? If so, can it use Windows Password Verification? Can I use SQL Server Express? (has it network capabilities?). I am moving from an internal networked solution, which has an Access Back end, to a scenario where workers are based around different parts of the country, so I'm thinking SQL Server is the best way forward. I do use SQL Server over an internal network on another project, but any advice work be greatly appreciated. Thanks Jonny

[Luis Alonso Ramos]

StyleGuide wrote:

can SQL server run over a VPN?

For apps, VPN is basically a normal network, so they can hardly tell the difference. So, SQL can run in a network that is accessed by VPN (or even be run in a VPN client and be used by other computers in the network.)

StyleGuide wrote:

Can I use SQL Server Express? (has it network capabilities?).

Yes, but they are not enabled by default. You have to go to the SQL Configuration Manager and enable the SQL Browser Service, and also enable the TCP/IP protocol.

StyleGuide wrote:

If so, can it use Windows Password Verification?

I'm not 100% sure on this one, but you should if you are part of a domain.

Luis Alonso Ramos Intelectix Chihuahua, Mexico

Not much here: My CP Blog!

[StyleGuide]

thanks Luis, thats really helpful. Jonny

[Luis Alonso Ramos]

You are welcome! I am glad I could be of help :)

Luis Alonso Ramos Intelectix Chihuahua, Mexico

Not much here: My CP Blog!