title: ASP.NET - Adding SQL State Server + manipulating it
body: <p>I'm building app for intranet. It is designed so that at one end someone provides data in a custom made form (at run time) or choosing one from template (either provided by me or saved custom-made). At the other end someone can query the data provided. At some point data provided will not be modifiable by the user that provides it.</p>
  
  <p>What I'm doing is basicly trying to store session data:</p>
  
  <ul>
  <li>that allows user to come back to filling form (as when he had to end it abruptly and then come back to it)</li>
  <li>bring back his custom made form that he designed</li>
  </ul>
  
  <p>What my problem is:</p>
  
  <ul>
  <li>don't know how to set up the SQL state server correctly</li>
  <li>how to manipulate it (meaning how to change what data is stored, either by storing less data or making custom session data-set that is saved)</li>
  <li>how to manipulate SQL state server  </li>
  </ul>
  
  <p>I'm willing to store data in a few tables - for ex. BEFORE(stores forms being filled) and SENT(not modifiable anymore, they will be analized), also FORMDESIGNS(that stores user form templates). I don't know how to wrap my head around it.</p>
  
  <p>What I've read:</p>
  
  <ul>
  <li><p><a href="http://www.codeproject.com/Articles/32545/Exploring-Session-in-ASP-Net" rel="nofollow noreferrer">http://www.codeproject.com/Articles/32545/Exploring-Session-in-ASP-Net</a></p></li>
  <li><p><a href="https://stackoverflow.com/questions/36725920/add-sql-server-profile">Add SQL Server Profile</a></p></li>
  <li><p><a href="https://dba.stackexchange.com/questions/49677/no-sa-password-no-sql-server-management-studio-no-os-authentication">https://dba.stackexchange.com/questions/49677/no-sa-password-no-sql-server-management-studio-no-os-authentication</a></p></li>
  </ul>
  
  <p>If you had any step-by-step guide or any other source of information that could help I'd be grateful. </p>
  
  <p>I'm not very experienced in storing session data and databases itself. If you think something might make it easier from what you alr know - don't hold back.</p>
  
  <p>Thanks!</p>