urgent problem about SQL Server

Hi,
I have a problem connecting my SQL Server 2005 from a ASP Webpage.

When I trying to connect using the following connection string:
"Provider=SQLOLEDB; Data Source =2xx.xxx.xxx.xxx; Initial Catalog = xxx;
User Id = xxx; Password=xxx"

The browser returns an error:
"Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied."

If I put the ASP page under the same local machine with the SQL Server, it
works fine.
However it failed to connect if I put the ASP page in another client
machine, which then remote connect to the SQL Server machine.

I am sure I have openned the port 1433 and 80, because I can connect by
using SQL Server Management Studio by using the same IP address, and I can
access the IIS thru a client machine.

Is there anything missing in my Win Server 2003 machine that blocked the
connection from Web? or any setting missing in the SQL Server to accept Web
connection?

thanks.
Paul

> I am sure I have openned the port 1433 and 80, because I can connect by
> using SQL Server Management Studio by using the same IP address,
Did you try the SQL Server Mgmt Studio connection from a machine remote to
the SQL Server instance? If you have a SQL Server utility tool such as
osql.exe or sqlcmd.exe on the the IIS machine, you may want to establish that
you connect to the SQL instance from there. If you don't have oslq.exe or
sqlcmd.exe, you can craete an ODBC data source name and run a test with the
data source name.

Linchi

"HK newsgroup" wrote:

> Hi,
> I have a problem connecting my SQL Server 2005 from a ASP Webpage.
>
> When I trying to connect using the following connection string:
> "Provider=SQLOLEDB; Data Source =2xx.xxx.xxx.xxx; Initial Catalog = xxx;
> User Id = xxx; Password=xxx"
>
> The browser returns an error:
> "Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
> denied."
>
> If I put the ASP page under the same local machine with the SQL Server, it
> works fine.
> However it failed to connect if I put the ASP page in another client
> machine, which then remote connect to the SQL Server machine.
>
> I am sure I have openned the port 1433 and 80, because I can connect by
> using SQL Server Management Studio by using the same IP address, and I can
> access the IIS thru a client machine.
>
> Is there anything missing in my Win Server 2003 machine that blocked the
> connection from Web? or any setting missing in the SQL Server to accept Web
> connection?
>
> thanks.
> Paul
>
>
>