1) Install SQL Server on Window Server 2003/2008 on Network (Select Network option when installing SQL Server)
2) Configure Windows Server as a domain controller. (Install DHCP )
3) Add Windows XP node to domain. (System Properties - >Computer Name -> Change->Add the name of the domain (Ex. MyTestServer@abcd.com and put he Windows Server Login Password)
3) Configure connection properties of your app.config or web.config file as follows
<add name="CWBConnectionString" connectionString="Data
Source=CWBServer;pwd=cwb@123;Initial Catalog=CWB;Integrated
Security=True" providerName="System.Data.SqlClient" />
#Set the Datasource of your connection string as Name of the SQL Server
#Password use to logon to Windows Server
Now you can access the SQL Server database from your applications on Windows XP nodes.
