Connecting to a Network Server - a simple question !!

Hi

My question should be relatively simple.

I have a server machine (Windows XP + SQL SERVER 2005 EXPRESS) : IP (192.168.1.1)

2 client machines:

Client 1 (Windows XP + SQL SERVER 2005 EXPRESS) : IP (192.168.1.100)

Client 2 (Windows XP + SQL SERVER 2005 EXPRESS) : IP (192.168.1.101)

I want to connect the 2 clients to the server database in a simple client\server arch.

what should I do ?!!!

Thank you in advance.

By default SQL EXPRESS does not allow remote connections and is meant to be used as a Client database only.

You can enable the Remote Connections with configuration tools, but there are limitations.

I am not sure what you mean in a Client Server architecture, as you are using all Client OS versions, and connecting SQL - SQL would not necessarily be a Client Server arch.

More info would help as to what you are trying to accomplish in setting up 3 instances of SQL Server to talk to each other (other than replication, etc).

Ben Miller

|||

developer00x wrote:

Hi

My question should be relatively simple.

I have a server machine (Windows XP + SQL SERVER 2005 EXPRESS) : IP (192.168.1.1)

2 client machines:

Client 1 (Windows XP + SQL SERVER 2005 EXPRESS) : IP (192.168.1.100)

Client 2 (Windows XP + SQL SERVER 2005 EXPRESS) : IP (192.168.1.101)

I want to connect the 2 clients to the server database in a simple client\server arch.

what should I do ?!!!

Thank you in advance.

Hi Developer00x,

You will need a minimum install of sql server 2005 standard edition to achieve what you are attempting to do...
Barry Andrew|||I am not sure, why he should need a Std. Edition for the scenario described as he did not mention anything about replication or something else. If he just wants to connect to the server from the clients, he will just need to have any SNAC / OLEDB / MDAC (which is shipped with Windows XP) and enable remote connections like Ben suggested.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||Problem solved ..
Thank you,