How can one Connect (remotely) to SQLExpress which is installed on "Windows XP Home"

Hi all,

I have to deal with a private network of laptops which are all equiped with preinstalled "Windows XP home"

I've installed SQLExpress on one of these, but I cannot connect on it from the rest of the laptops. (I've successfuly done this with "Windows XP profesional" though, and local connections work fine as well).

I've already setup the SQLExpress to accept conections throuigh TCP/IP but I can not think of something else. (Security comes to mind, but I do not know how to resolve it on "Windows XP Home").

Thank you

Ioannis

Allow port 1433 and 1434 for TCP to come though as this should be blocked by the firewall by default. Try this first by disabling the firewall for a moment to see if this is the case.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi Ioannis,

Did opening the firewall solve this issue for you?

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!

|||

Hi,

The firewall was already wide open!

What solved my problem was starting the "Browser" service.

Is this service supposed to be "down" by default?

thank you both for your kind responses

Ioannis

|||That is a question of settings in the setup during the installation, you can check the service to autimatically startup, if you don′t it will put it on Manual.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Yes, this is by design.

SQL Express installs with the minimum external exposure possible. We also have remote connections disabled by default.

Mike