Cannot connect to SQL Express on 2003 Machine from XP machine

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: provider: Named Pipes Provider, error: 40 - Could not open a c
    ... I have tried connecting to Sql Management Studio and it worked pretty much ... An error has occurred while establishing a connection to the server. ... under the default settings SQL Server does not allow remote connections. ... I have a sql server install / database on the web server. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Server uses Windows authentication
    ... > With Windows Authentication you do not put any credentials in the ... The connection uses the credentials of whatever ... >> 1 remote web server to connect to an SQL db on a completely different ...
    (microsoft.public.inetserver.asp.db)
  • Re: What is the best way to connect to a server not on the network?
    ... That 192 IP address is most likely not a remote one. ... but doesn't object to migrating the data to SQL server. ... I tried using ADO within Access to create a connection string to the remote ...
    (microsoft.public.access.modulesdaovba)
  • Re: Connecting to SQL w/ADO
    ... Again, I suggest picking up ... I would not use the ODBC provider to access SQL Server. ... but the SQL connection is new territory for me. ...
    (microsoft.public.vb.database)
  • Re: Login failed for user . The user is not associated with a trusted SQL Server connection.
    ... run under a domain account with access the sqlserver. ... want to connect to an SQL 2005 server running on Windows 2003. ... My SQL server is set ... server with that, it reports that the test connection is successful, ...
    (microsoft.public.dotnet.framework.aspnet)