Iis Application Pool Identity Sql Server

However external vendors like us are not joined to their domain and the domains are not trusted so i cannot use organization abcs provided domain credentials as my application pool identity. Some of these applications access a sql server 2008 r2 filestream on a remote machine on the same domain. On iis 75 weve configured an application pool for the website.
iis application pool identity sql server

When developing with visual studio.

The application pool runs with applicationpoolidentity identity and everything works fine.

Iis application pool identity sql server. If we change the identity to be under a specific account created for accessing the database the database access works. Configuring iis application pool identities. I have an iis 75 server with a number of applications in a single application pool. Parts of the site will have database access but not require a logged in user.

For every application pool you create the identity property of the new application pool is set to applicationpoolidentity by default. In iis if we let the dashboard server application run under the local system account the server is not able to access the remote sql server database or ssas cube. The identity set for that app pool eg. We use localsystem as the identity to in iis to run as built in account by default.

The organizations own engineers are able to configure their local iis application pool identities to use domain credentials for accessing the sql servers using integrated security. In the anonymous access situation that was mentioned above the site says to always use the application pool identity for anonymous users. If you are running iis 75 on windows server 2008 r2 or a later version of iis you dont have to do anything to use the new identity. This article described an issue with sql express and the new iis 75 application pool identity.

While sql server can add any normal user account the iis apppoolmyapppool virtual account cannot be added to the valid logons sql server says that the account cannot be found. So is there no way to allow the application pool identity to authenticate to the sql server. Because the application pool identity feature is the default in iis 75 users might see the problem described above when using sql express in a development environment ie. Iis apppoolsite001 is used in some situations on disk.

I dont have a problem using a domain account to authenticate the web application to the sql server i was just hoping to use the new app pool identities. Currently a sql server login connection string allows the net app to connect to sql server but we want to upgrade the connection string to be a windows sql server login to be more secure. Under application pool advanced setting built in account have tried using both. Id like to give this service account iis apppoolmyapppool permissions to connect to my sql server 2008 express running in mixed auth.

If this localsystem account does not have access to the sql server database that you have chosen in the startup of the dashboard server then you will need to change this application pool setting in iis to set the account which has access to the database.