Re: Urgent problem about SQL Server
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 22 Jan 2008 14:36:45 -0800
HK newsgroup (paul@xxxxxxxxxxxxxxx) writes:
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 that the same machine from which you try to run the ASP page?
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?
SQL Server does not even know that it is a web connection.
I suspect that this may be an IIS/ASP issue, an area of which I am
largely ignorant. I would check that IIS is not running as LocalSystem,
as that could preclude network access.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: Record level security?
- Next by Date: Re: Record level security?
- Previous by thread: SQL 2005: non SA user create a job
- Next by thread: RE: Urgent problem about SQL Server
- Index(es):
Relevant Pages
|
|
