title: How to change SQL Server 2005 from Windows Authentication to SQL Authentication?
body: <p>I have installed SQL Server 2005 in Windows Authentication, now I want to change it to SQL Authentication.
  However, I cannot reinstall SQL SERVER and Management again, because it will lose the data in it.
  Also I want to know what changes do I need to make in my Connection class to open connection, as my current is  </p>
  
  <pre><code>public SqlConnection con= new sqlConnection("server=.\\SQLEXPRESS;database=Restaurant;integrated security=sspi");
  </code></pre>
  
  <p>Just need to ask one more thing, I can see my database in WIndows Auth and in SQL auth, so how can i change, so that any other user need to login before it peeps into my database. thanks</p>