Sql server and intranet question

[eranfox]

Hello ,
I would like to know how can i use sql server (ver7.0) with intranet.
What i want to do is to be able to let remote user to use my
data base that is on an sql server and the server is in some office in some bulding and users from other cities will be able to connect to it.
I know this is too much to ask but any help will be fine.
Thanks
ERAN

[monte96]

If you have a firewall, the database server must be outside of it. Other than that, your Web server should do the connecting to the database server on behalf of the users.

[eranfox]

Thank you Monte96 for your reply,
Firewall is a heavy application,
The database i'm using is not a top secret so i dont want to use firewall.
I just want to let the outside users to be able to add new records etc... to the database to update and etc...
What do you mean when you say Web server?
Thanks
ERAN

[monte96]

Are you trying to allow them to connect directly to the SQL Server? Or connect through a web application that limits what damage can be done?

[The Brain]

We had the same problem and brought the SQL 7 server in some kind of a special area within our network (Sorry, I only know the german expression - Zwischennetz)
That workes fine with very less modification to our Firewall.
And it is accessible by people from outside (incl. Server logon).

I ask out network admin for more information when I get him

[eranfox]

Hello and thank you for your reply,
Do i have to use firewall??
is this the only way??
Thanks again,
ERAN