IIS and sql server... cant open databse RRS feed

  • Question

  • User1414647419 posted

     I get this error when i try to access my site from IIS (so friends on network can see) "Cannot open database "aspnetdb" requested by the login. The login failed.
    Login failed for user 'IIS APPPOOL\Defualt'". Here is my connection string in my web config...     <add name="MyDB" connectionString="Data Source=Josh-PC\SQLEXPRESS;Initial Catalog=aspnetdb;Integrated Security=SSPI;"/>

    Im using Windows 7 x86-64 and IIS 7.5 (or what ever ships with it). Any help would be super awsome.

    Also im using Windows Authentication on my Sql Server (at least for management studio). 

    Friday, February 12, 2010 11:41 PM