I want to reference these links because they highlight my issue
Create SQL Server Login for IIS APPPOOL - IIS and SQL Server on different machines
and
Configuring ASP.NET MVC app's IIS 7.5 Application Pool identity as login on SQL Server 2008 R2.
To summarize the posts, I have ServerA
with IIS
and my app pool and ServerB
with SQL Server
. ServerA
SQL recognizes my app pool as a login since that is where IIS
resides, but now I need my app pool to access SQL
on ServerB
.
I have tried to create a SQL login on ServerB
for my app pool as Domain\ComputerName$\IIS APPPOOL\AppPoolName
, but it does not recognize that. It recognized Domain\ComputerName$
, but my application still does not work.
Am I on the right track, if so what user name do I specify? My DBA skills are not as sharp as they should be. Thank you.
I don't think you can use AppPool for remote SQL Server. Give machine account Domain\ComputerName$, access to SQL, or you can run AppPpool with domain user account (domain\username) and give this user access to SQL.
Domain\MachineName$ is more secure and maintainable as you do not have keep updating password for user every n months, and restricts to only one machine. If you have multiple IIS server then you have to go with domain\username method, and set AppPool to use this user account (Windows Auth).
I think You can also create group Domain group and add all (IIS) machine name on this group and give this group permission to SQL.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With