Databases
StackOverflow2013
Postsdbo
POEntity Framework Code First ignoring connection string, using IIS instead
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POEntity Framework Code First ignoring connection string, using IIS instead
    primarykey
    data
    text
    <p>I have a web app that I've created using Entity Framework Code First. In setting it up I have managed to match my DB connection string to my DBContext by specifying the full namespace and class of the DBContext as the name of the connection string.</p> <pre><code>&lt;add name="MyClassProject.EfDbContext" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=MyDatabase;Integrated Security=true;User Id=MyUsername;Password=MyPassword;" providerName="System.Data.SqlClient"/&gt; </code></pre> <p>Initially when I set up the project, I just had it created in c:\inetpub\wwwroot, and just ran it through Visual Studio. Everything worked fine.</p> <p>Now I'm trying to have the code build to a separate website folder, and have the website run as it's own website and app pool in IIS. I've set up the website, and my hosts file but when I went to run it I received the following error.</p> <blockquote> <p>Cannot open database "MyDatabase" requested by the login. The login failed.</p> <p>Login failed for user 'IIS APPPOOL\MyAppPool'.</p> </blockquote> <p>I'm wondering why this is happening, as I seem to be specifying the security username and password to use for the DB in my connection string....so why is it trying to connect as the app pool that my website is running in?</p> <p>Also, how can I fix this, without having to give MyAppPool (or Network Service if I changed it to that) DB permissions in SQL Server?</p> <p><strong>Update:</strong> I should've mentioned that I initialise my DBContext class using:</p> <pre><code>namespace MyClassProject { public class EfDbContext : DbContext { public EfDbContext() : base ("MyDatabase") { } } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSean Holmesby
    1. USSean Holmesby
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POEntity Framework Code First ignoring connection string, using IIS instead
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POEntity Framework Code First ignoring connection string, using IIS instead
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POEntity Framework Code First ignoring connection string, using IIS instead
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload