We've discussed this many times. I have a summary of the connection issues
on my blog (search for "connecting"). Remember, SQL Server 2005 no longer
broadcasts its presence on the network so you also need to run the SQL
Browser service on the host server to make is visible. I think for your
situation a VPN is (by far) the most reasonable approach. See Chapter 9 of
my book for more details. I focus quite a bit on Windows Forms applications
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) http://betav.com/blog/billva http://betav.com
<russ.green@xxxxxx> wrote in message
> I've developed an app for our company using VB.NET (winforms) and SQL
> server express running on our SBS server.
> The app works really well within our LAN but I often work remotely and
> quite often would benefit from using my custom app. I've tried the VPN
> but for some reason my app just won't connect to the database.
> What I'd like is some advise about how I can allow remote clients to
> access a SQL database that lives inside our LAN. I've never done any work
> with web services but I thought I might be able to do something there. Or
> maybe it's a simple matter of a firewall port and a clever connection
> Any advice on the best strategies to adopt for this problem would be
> hugely appreciated.