Getting right account IIS (8) and server2012

Erik Severiens · June 29th, 2013, 04:37 AM

I have worked all the way though chapter19, jippee! I booked a server and installed all goodies. This server is 2012 and after IIS is up and running pages without dbase acces work fine.

However the dbase access is problematic and all seems to be down to the fact I can't find the IIS (8) Application Pool identity (it is not listed when changing file system security).

I hooked up the SQL server to the dBase (ok), and then I need to match SQL authentication to IIS authentication. However I can'd find the IIS authentication.

How do I find this identity when it is not listed?

Thanks

Erik

Imar · June 29th, 2013, 08:05 AM

Hi there,

The account is not listed but it's named after the application pool, prefixed with IIS AppPool\ E.g.:

IIS AppPool\NameOfAppPool

You can find the name of the application pool on the Advanced settings of the site in IIS.

Hope this helps,

Imar

S.Mccabe · July 5th, 2013, 08:22 AM

Hi Imar,

I am on chapter 19 of your book Beginning Asp. Net 4
and I got stuck on this problem (Cannot open database "aspnetdb" requested by the login. The login failed.
Login failed for user 'IIS APPPOOL\ASP.NET v4.0'.). Could you please tell me what I am doing wrong.

Thanks
Shane

P.S.
Loved the Book

Imar · July 5th, 2013, 01:11 PM

Hi there,

Can you provide (a lot) more information? Where did you get stuck in the chapter? Which version of Windows are you using? How are you installing the site? Did you configure the application account? Which version of SQL Server are you using? How did you configure SQL Server (which account did you add and which permissions did you give it)? How do your connection strings look?

Without that information, it's pretty much impossible to suggest something useful.

Cheers,

Imar

Erik Severiens · July 7th, 2013, 11:25 AM

After much try and error I fixed it somehow.

After assigning the SQL dbase to the .NET 4.5 application pool (taking it out the default apppool) suddenly there was an account iis apppool/.net 4.5 and all worked!

However maybe it was there before........ This is how it is, after you fix it you get on with the next challenge,

Erik

Imar · July 7th, 2013, 01:42 PM

The account should have been there, as it's implicitly associated with the application pool which gets created when you install IIS.

Anyway. glad it's working.

Cheers,

Imar

S.Mccabe · July 9th, 2013, 05:44 PM

Hi Imar
Thanks for answering my post.
The Version of windows is 7, with SQL2008, my connection strings are ( <connectionStrings>
<clear />
<add name="ContactConnectionString" connectionString="Data Source=.\SQLEXPRESS\Shane-PC\Shane; Initial Catalog=Contact; Trusted_Connection=True" providerName="System.Data.SqlClient" />
<add name="ContactEntities1" connectionString="metadata=res://*/App_Code.job.csdl|res://*/App_Code.job.ssdl|res://*/App_Code.job.msl;provider=System.Data.SqlClient;pr ovider connection string="data source=.\SQLEXPRESS\Shane-PC\Shane;Intial Catalog=Contact Trusted_Connection=True;multipleActiveResultSets=T rue"" providerName="System.Data.EntityClient" />
<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS\Shane-PC\Shane;AttachDbFilename=|DataDirectory|\Contact. mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
<add name="LocalSqlServer" connectionString="Data Source=.\SQLEXPRESS\Shane-PC\Shane; Initial Catalog=ASPNETDB;Trusted_Connection=True" providerName="System.Data.SqlClient" />
</connectionStrings>). The permissions are as you said in the book. I have my site up and running on my computer but cant connect to the database. it all works fine in Visual Web Dev.
Thanks again
Shane

Imar · July 10th, 2013, 04:00 AM

Hi Shane,

Your server name is incorrect. You have this:

.\SQLEXPRESS\Shane-PC\Shane

which is invalid. You either need .\SQLEXPRESS or Shane-PC\Shane but not both at the same time. Which one you need depends on the name of your SQL Server instance.

Hope this helps,

Imar