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







#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.