Access SQL server from Internet

[Greg_S_H]

Our corporate web site is running with an ISP. I've installed SQL server 7.0 and IIS 4.0 for intranet. Is it possible to store some information from internet(web Site) to my corporate SQL server? Corporate SQL server has an IP address.

Thank You

[monte96]

I'm not sure what you are asking, but if you are trying to access a SQL Server from the internet, the server on which it resides must be outside of any corporate firewall.

If that is what your asking, sure it can be done, just set the IP address as the server attribute in your connection string.

[Greg_S_H]

Thank you for your answer. There is no firewall. What is situation with firewall?
What is your meaning of connection string. This is the same in making a connection in ASP.

[monte96]

Have you used ADO? I'm making the assumption that you already know how to make a simple connection to SQL Server via ASP. If this is not the case, let me know so I know what level to help you at.

[Greg_S_H]

Yes, I've used ADO and ASP to make connection with SQL server. I got my question's answer. Do you know how can I implement this with XML and SQL server 2000.

Thank You