Access SQL Server 2005 over internet connection (Best security)
Posted on 2007-11-28
SQL Server 2005/ADO.NET 1.1/VisualStudio 2003 C#
I have an application need to communicate with SQL Server 2005 outside a network. My Customer need to have a Hight Level of security and he could not open SQL Server port. All my others customer, use VPN Connection to manage this problem. But in this situation, my customer doesn't have a VPN and we need to access with Hight Security Level my SQL database. I know that it's possible to build my own server, or access sql with a web service but i don't have time to do this. I need your help to find the best way to resolve this problem and propose solution to our customer : (I forget! We use a mixed mode security in SQL Server)
Web Service ?
Custom Server ?
How to implement your best way with ADO.net ? How to pass in connectstring ?
It's really important to know that we need to keep performance on SQL Access.