RE: Urgent problem about SQL Server
- From: Sean McCown <SeanMcCown@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 23 Jan 2008 07:04:03 -0800
Couple things to try:
1. Make sure your username/password are correct. That's an excellent place
to start. Most of the problems I've had with ASP have been because of this.
Also, make sure the machine name is correct. Connect through another tool
using the exact same info you're using in your ASP.
2. Make sure your SQL box is setup accept external connections. You can do
that from Surface Area Configuration.
Since you're connecting with SQL auth none of the other IIS settings should
be a factor.
"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
- Follow-Ups:
- RE: Urgent problem about SQL Server
- From: Erland Sommarskog
- RE: Urgent problem about SQL Server
- Prev by Date: Re: Default permissions on new database
- Next by Date: RE: Integrated Security in the DMZ
- Previous by thread: Re: Urgent problem about SQL Server
- Next by thread: RE: Urgent problem about SQL Server
- Index(es):
Relevant Pages
|
|
