Re: Connectivity Issues - Bizzare

Sounds like firewall to me.
As a quick test to see if firewall is blocking port, try this from command
prompt on client machine ->

telnet mysqlmachine 1433

If you can't telnet to 1433, then you have firewall issue.

Matt Neerincx [MSFT]

This posting is provided "AS IS", with no warranties, and confers no rights.

Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Andy Furnival" <AndyFurnival@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:40AC00C0-0402-452B-AAC8-F25D97E94ACD@xxxxxxxxxxxxxxxx
>I am trying to connect to a default instance of SQL Server 2000 Enterprise
>on
> a remote network server using ADO.NET objects through ASP.NET Web
> Application.
>
> The SQL SERVER is on a Windows XP machine (no firewall enabled) with
> TCP/IP
> and Named Pipes enabled
>
> For the test purposes, I created a new Web Form, created a new
> SqlConnection
> in the Server Explorer to the remote database. I test the connection is VS
> IDE and everything is fine. I create a SqlDataAdapter on the web form,
> generate a dataset, test the dataset and the results are valid. I bind the
> SqlDataAdapter to a datagrid and run the webform. I now get the following
> error.
>
> System.Data.SqlClient.SqlException: SQL Server does not exist or access
> denied.
> at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean&
> isInTransaction)
> at
> System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString
> options, Boolean& isInTransaction)
> at System.Data.SqlClient.SqlConnection.Open()
> at DBConnTest.WebForm1.Page_Load(Object sender, EventArgs e) in
> c:\inetpub\wwwroot\dbconntest\webform1.aspx.cs:line 39
>
> Hmph! I take the same connection string from the web app, create a win
> app.
> Place a datagrid on the form, do the binding and load the app. Hey Presto!
> it
> works.
>
> I used TCPView (systeminternals.com) and I can see aspnet_wp trying to
> create a connection, but its at though SQL Server is rejecting the
> connection, although I see no failures in SQL Server.
>
> Any thoughts would be much appreciated.
>
> Andy


.

Relevant Pages

  • Save DB connection and query within spreadsheet
    ... I created a web form that dumps the data into a SQL server database. ... the spreadsheet, and go back in, I need to reestablish my connection each ... Is there a way around this so that the query and DB connection are ...
    (microsoft.public.excel)
  • Re: Connect to SQL Server over the internet
    ... connection dialog window that you will find on the main menu: ... which is the port used by SQL-Server in its basic configuration. ... I can remove the firewall. ... Computer A is where is installed SQL server 2000 and the BE. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Named pipe error 53
    ... Did you try disabling the firewall on the Windows XP machine to see if it is dedicted to the settings of the firewall? ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ... (provider: Named Pipes Provider, error: 40 - Could not open a connection to ...
    (microsoft.public.sqlserver.connect)
  • Re: connecting to SQL Server 2000 from a VB.net app using ADO.net
    ... In terms of connectivity issues over the Internet, firewall ... TCP Ports Needed for Communication to SQL Server ... I can't create a remote connection in Enterprise Manager. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server over the Web, what are my options?
    ... SSL encryption is perfectly fine. ... attackers then have a secure link back to your SQL server. ... > 2) On the firewall at B, forwarding traffic from A to SQL server. ... > SSL encryption for the DB connection but still not sure this is secure ...
    (microsoft.public.security)