Connecting to local Sql Server from a Web Server using ASP

I am trying to connect to the Mssql server 2000 database of my

office p.c from an Asp page hosted in our webserver.But it is not

working.The error is something like this

***************
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied.

***************
Do I need to change any settings in the mssqlserver in our office

p.c.I am using the following code for connection

****************
con.ConnectionString= "Provider=SQLOLEDB.1;Persist Security

Info=true;User ID=sa; Initial Catalog=db1;Data

Source=xx.xxx.xxx.xx,pppp ; "

***************
The i.p used for Data Source is the dyanamic i.p provided by the isp since we are using a dialup connection here(I got it by using the command 'ipconfig' in the command prompt).The port is the default one '1433'.There is no problem with the i.p as i am able to obtain the static html pages in my office p.c using this i.p(IIS is there in my office p.c)
I don't think there is any problem with the code used for connection as I am to connect to our other sql server databases hosted in the web servers using the same code.
So i think that there should be some settings/configurations to be
made in SQL Server/IIS for accessing the databsae thru internet and I don't know what it is

Try it with localhost or the private lan ipaddress first and see what you can come up with.

Hey chandy - just letting you know for future reference: it's generally not a good idea to post IP address with login details on the web. (just replace your IP with xxx's)

stumpy.

In fact i am not answering the question but merely asking a basic question. I am trying to connect to a local SQL server from Crystal report thru internet as its not in our intranet. I guess you will be able to guide me how exactly i can do it.... Will appreciate yr help in this, Regards, Zuka.

How are you connecting to the DB - via DSN? If so, simply enter in the name or IP of the machine you want to connect to. If the DB is inside a LAN (and does not have a real world IP) then you won't be able to do it unless you're on a VPN.