title: Sharing SQL Server Between Multiple System
body: <p>I have three computer in a office and I have installed my C#-2005 Project on all three</p>
  
  <p>computers. But Problem is that Boss wants Sql-server-2000 on One PC out of three and other</p>
  
  <p>would share the same.</p>
  
  <p>I don’t know how to share Sql-server-2000 between three PC?. How to do?.</p>
  
  <h2>Confusion:-</h2>
  
  <p>Thanks for your co-operation but here I have a confusion on majority people said to check </p>
  
  <p><strong>TCP/IP</strong> address and consider the Connection string as per main server from client PC.</p>
  
  <p>Suppose I have financial project and there would be thousand of connection string in a </p>
  
  <p>project. As per above I have to change thousand of connection string as per main pc. </p>
  
  <p>Now think it is a one customer's  need If I have ten cutomer having same offer than think How much time I have to waste on it?. I have to modify thousand of connection string ten time more?. </p>
  
  <p>If it is true than it will take lots of time on installation to each customer.</p>
  
  <p><strong>I don’t know if it is only way?.</strong></p>
  
  <p>The Connection string I have utilized on my each winform is as below:</p>
  
  <pre><code>string connstr = "server=.;initial catalog=maa;uid=mah;pwd=mah";
  SqlConnection conn = new SqlConnection(connstr);
  conn.Open();
  </code></pre>
  
  <p>Here suggested about Config File and same I don't know if some body give me idea about how to consider it with my C#2005 project than it will save my lots time.</p>