title: ASP.NET: Can't connect to SQL Server database after uploading to server
body: <p>I'm trying to upload my asp.net site to my HostGator windows server. I'm having a problem connecting to the SQL Server database in my <code>App_Data</code> folder. It's giving me the error: </p>
  
  <blockquote>
    <p>Login failed for user 'PSS004\IWPD_353([UserName])'.</p>
  </blockquote>
  
  <p>I use Windows Authentication in Visual Studio 2010 to access the database and view the site just fine locally. Is that causing a problem? If so how do I set up a user/pass to use when accessing the database file once it's on my hosting server?</p>
  
  <p>If any further information is needed that I left out just let me know.</p>
  
  <p>Thanks!</p>