Accessing SQL Server over Network .NET Application

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.