title: Difficulty Connect to SQL Server Express on LAN
body: <p>I'm having trouble connecting to a SQL Server on a machine in our LAN.</p>
  
  <p>i have done the following :</p>
  
  <p>1.) Made the IP of the machine running the Server 10.0.0.7 and made the IP of the other machines on the LAN IP 10.0.0.X . There is no internet on the LAN(and it will stay that way), changeing IP is permitted.</p>
  
  <p>2.)Enabled remote connection by doing <a href="http://support.webecs.com/kb/a868/how-do-i-configure-sql-server-express-to-allow-remote.aspx" rel="nofollow">This</a></p>
  
  <p>3.)Used the appropriate connection string.</p>
  
  <p>Now my only Question that remains is regards to the connection string of those who wish to connect on the server, here is the current Con-string:</p>
  
  <pre><code>string sConnection = @"Server=10.0.0.7\MARNUS-PC\MARNUS_HOME; User ID=MARNUS-PC\MARNUS_HOME; Password=somepassword; Initial Catalog=TestDB;";
  </code></pre>
  
  <p>My questions are :</p>
  
  <p>1.)What do i put the Server portion? here is my Server name and instance name acording to
     the management studio - Server name : MARNUS-PC\MARNUS_HOME , Instance name : MARNUS_HOME.</p>
  
  <p>2.)What do i use as user ID? I wish to use Windows authentication instead of sql server authentication(i have enabled both on server), so how should the connection string change and how to do i allow a user from the server's side on the management studio(if needed)?</p>
  
  <p>3.)I asume if I use Windows authentication i do not need the password part of the Con-String?</p>
  
  <p>I apologize for all the questions,but i was taught  MS Access and is now making the switch to SQL Server by myself.  </p>