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

Yep - Running Zone Alarm, so even switched it off completely to test.
But I have another 2000 server that I can connect to fine, so it's
definitely a problem on the 2003 server.
No matter what I do, it doesn't seem to want to open the port!

Any ideas anyone else?

Thanks
H


Arnie Rowland wrote:
Have you checked the Windows XP Firewall to see if port 1433 (MSSQL) is
blocked?

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


<harrys@xxxxxxxxx> wrote in message
news:1162418209.991142.71240@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: Problem with Web based client
    ... Seems like you are having problems accessing the web server on the PC you ... > My remote desktop connection works fine when I connect with a Remote ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: Remote Access and ISA Server in SBS 2003?
    ... I am glad to hear the Remote Access Wizard is working fine now. ... there is no difference in VPN between SBS 4.5 and SBS ... Error Message: VPN Connection Error 800: Unable to Establish Connection ... the external NIC of the SBS Server. ...
    (microsoft.public.windows.server.sbs)
  • RE: Remote Office Configuration Suggestions?
    ... Welcome to SBS newsgroup. ... I understand that you want to keep the remote office continue working even ... after the main internet connection on the main office is not available. ... If you want to join the remote server to a SBS domain and become a member ...
    (microsoft.public.windows.server.sbs)
  • RE: Another Remote Connection Manager Problem
    ... > internal and 192.168.1.3 for the internet connection. ... > via the SBS server to all clients. ... > With this configuration OWA and Remote Workplace are operational. ... > Connection Manager to connect to the VPN server and gain access to a shared ...
    (microsoft.public.windows.server.sbs)
  • Re: Another Remote Connection Manager Problem
    ... > internal and 192.168.1.3 for the internet connection. ... > via the SBS server to all clients. ... > With this configuration OWA and Remote Workplace are operational. ...
    (microsoft.public.windows.server.sbs)