Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

bind-address mysql multiple, sanibleone xxxx, ftp://192.168.100.100/, www.xxxcon, which comes first ob_start or session, wwwxxx/58/2010, xxxxdup, xxxxdup, mailx informatii, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?

Links

XODOX
Impressum

#1: Urgent problem about SQL Server

Posted on 2008-01-22 20:52:04 by HK newsgroup

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

Report this message

#2: Re: Urgent problem about SQL Server

Posted on 2008-01-22 21:10:03 by reb01501

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?
>
Try replacing SQLOLEDB with SQLNCLI
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Report this message