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

is your firewall on on the 2003 machine?

you need to:

enable network communication
make sure that the port isn't blocked
make sure that you have security



Harry wrote:
Have already done that. . . but it still doesnt work!
Any other ideas anyone?



susiedba@xxxxxxxxxxx wrote:
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: SQL2005: Cannot connect error 11001
    ... I believe the complete Windows auth user access is too complicate, ... which trusted connection is meant? ... it would still be listening on the old port. ... Microsoft, SQL Server Books Online ...
    (microsoft.public.sqlserver.connect)
  • Re: Installing Sql Server Express on Vista Home Premium
    ... It seems that your SQL Server instances are Named Instances, ... Default Instances uses 1433 TCP port by default as a Static Port but not the ... If you change your Connection String as following, ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 Connection Problems
    ... - it is't completely clear what the SQL Server Browser is for. ... connection reqest was being rejected. ... I think the problem is still likely the the port is blocked by some ... firewall between the server and that client. ...
    (microsoft.public.sqlserver.setup)
  • Re: Cannot connect to SQL express database ????
    ... However, yes, you are correct that if SQL Server Express Edition is using dynamic ports, then the port could change to one that is blocked by the firewall. ... This connection string using sytax ... >>> I can manage without any problem my database from the VIsta ...
    (microsoft.public.sqlserver.connect)
  • Re: Correction
    ... Normally to physically disconnect is just a matter of reaching for the ... >> I have an ADSL connection which polls my computer from time to time, ... > disallow each and every port with Windows Firewall? ...
    (microsoft.public.windowsxp.messenger)