Re: Urgent problem about SQL Server

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.


.

Relevant Pages

  • RE: Web.config update to allow remote connection to sql server 2005
    ... The issue is basically a SQL Server connection issue. ... please continue this issue in the right newsgroup, so that you can get most ... Microsoft Online Community Support ...
    (microsoft.public.vsnet.general)
  • RE: Urgent problem about SQL Server
    ... Most of the problems I've had with ASP have been because of this. ... I have a problem connecting my SQL Server 2005 from a ASP Webpage. ... When I trying to connect using the following connection string: ... or any setting missing in the SQL Server to accept Web ...
    (microsoft.public.sqlserver.security)
  • RE: Accessing SQL Server Accross Domain
    ... Thank you for using MSDN Newsgroup! ... To access the SQL Server across domain is possible. ... make sure the connection between this two computers is OK. ... Port 1433 is the default port number for SQL Server. ...
    (microsoft.public.sqlserver.security)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: WSS 3.0 Sites DOWN ( again by Microsoft update??)
    ... Please only post one particular question to ONE newsgroup to avoid ... database 'WSS_AdminContent' is full. ... Wanna to manage the DB thru Microsoft SQL server mamagement stuio. ... An error has occurred while establishing a connection to the server. ...
    (microsoft.public.sharepoint.windowsservices)
Loading