Re: Cannot connect to SQL Express on 2003 Machine from XP machine

Tech-Archive recommends: Fix windows errors by optimizing your registry

you need to get the real tools and 'enable connections''

it's called 'surface area configuration'
start, programs, microsoft sql server, configuration tools, 'surface
area configuration'

by default it doesn't listen to network calls; you just have to enable
network communications for that SqlExpress instance

-Susie




Harry wrote:
Ok - Probaly should have checked this before, but having just done a
netstat -a command, it seems that the 2003 server is not listening on
port 1433.

Any idea on what I can do to get it 'listening'?!

Thanks
H



Harry wrote:
Hi,

Can someone help me with a connection problem!


I am trying to connect from an XP SP2 machine remotely to a SQL Express

database on a 2003 server.


Everytime I try to connect via Visual Web Developer, i get the
following error:


"An error has occurred while establishing connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: Named Pipes Provider, error: 40 - Could not
open a connection to SQL Server)"


I have tried:
- In Surface Area Configuration for Services. . . Enabled "Local and
Remote connections", Checked "Using Both TCP/IP and Names Pipes"
- In SQL Server configuration manager, under 'Protocols for SQL
Express', gone to properties of TCP/IP and then IP Addresses. Here i
have put a 0 for TCP Dynamic Ports and 1433 for TCP Port.
- Enabled Remote Admin Connections, 1 in SQLExpress.


The connection string I am trying to use is: xx.xxx.xx.xx/SQLEXPRESS


All this and still no joy!
Can anyone help or provide more ideas on what I could try!!!


Thanks
H

.

Relevant Pages

  • 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: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OpenDataSource SQL Server xpress problem
    ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Exception trying to import data from Excel .
    ... An attempt to install Microsoft SQL Server 2005 this week has not gone ... The connection type "EXCEL" specified for connection manager ... to create a connection manager for an unknown connection type. ...
    (microsoft.public.sqlserver.tools)