Hello,
What different methods exist when trying to set up a sql server box to
be accessible to an app that needs to connect to it through DSN.
The app is running in a different city than the sql server box.
Would I need to do this through a VPN, IIS?

You'll need to establish some form of network connectivity between your
offices. This could be anything from a VPN connection over the internet, to
dedicated lines (an expensive but potentially more reliable option). You
may want to post this question to microsoft.public.windows.server.networking
group for other ideas and advice.

--
--Brian
(Please reply to the newsgroups only.)


"Developer in Need of Information"
[quoted text, click to view]

Hi d.i.n.o.i :)

I would have thought that the DSN will allow ODBC style traffic over a
TCP/IP connection. So IIS as I understand things is effectively a
web/ftp server - so I cant imagine where that's going to help you much
unless theres something magic about IIS that I don't know about (don't
really use it much).

So - I would have thought that whatever it takes to get a valid TCP/IP
connection between you and the remote server is what you want. Since
these are likely to be on 2 separate lans, I would imagine its fairly
safe to assume the SQL server is not directly accessible from the the
internet (in which case you wouldn't need a vpn - youd just need to make
sure the TCP/IP port for dsn & SQL connectivity isnt firewalled) - so
you would need a vpn to get onto the remote lan in order to make a valid
connection to the SQL server to allow the dsn to connect to the
database.

-s


-----Original Message-----
From: Developer in Need of Information
[mailto:DeveloperinNeedofInformation@discussions.microsoft.com]
Posted At: Aug31 2005 2127
Posted To: connect
Conversation: local app to access sql server box in a different office
Subject: local app to access sql server box in a different office


Hello,
What different methods exist when trying to set up a sql server box to
be accessible to an app that needs to connect to it through DSN.
The app is running in a different city than the sql server box.
Would I need to do this through a VPN, IIS?
Any suggestions much appreciated.