title: Using connection string login and not Application Pool Identity
body: <p><strong>The Question:</strong> </p>
  
  <p>How do I get my Web Application to use my connection string login and not the Application Pool Identity? </p>
  
  <p><strong>The Background:</strong></p>
  
  <p>I have started up a .net mvc project and currently use Arvixe for hosting. I made a simple page using a form to communicate with the SQL database. <a href="http://photosbyjoeforyou.com/" rel="nofollow">Here is the site.</a></p>
  
  <p>Just type anything into the text boxes and hit the button. If the communication is successful, it should just return a message.</p>
  
  <p>The error:</p>
  
  <pre><code>Cannot open database "jfphotography" requested by the login. The login failed.
  Login failed for user 'SEAWEED\photosbyjoefor_web6'.
  </code></pre>
  
  <p>My database user is jfphoto_dbadmin. I have tried making it photosbyjoefor_web6, but with no luck. No where in my code do I use, or set anything to, photosbyjoefor_web6. I have tried using photosbyjoefor_web6 in my connection string. </p>
  
  <p>My connection string is correct, and I have been chatting with support for a week now. We believe that the application is using the Application Pool identity, and, using basic services, I am not allowed/Arvixe will not make any custom Application Pool Identities (which makes sense for shared hosting). Unfortunately, I do not want to be paying 40 bucks a month for their private hosting to be able to edit the Application Pools.</p>
  
  <p>My project is using a Code-First approach, data service layers, context layer, all the fun stuff. I have never encountered this type of error before, and I am unsure of how to approach it. I really do not want to re-build my project in a different manner, but if I have to so-be-it. </p>
  
  <p>Connection string: </p>
  
  <p>add name="PhotographyContext" connectionString="Data Source=seaweed.arvixe.com;Initial Catalog=jfphotography;Integrated Security=True;user id=jfphoto_dbadmin;password=<strong><em>*</em>*</strong>" providerName="System.Data.SqlClient"</p>