When I tried to install Orchard CMS to it's own web site, IIS create a web pool called Orchard. After supplying a connection string of
Data Source=(local);Initial Catalog=Orchard;Integrated Security=True;MultipleActiveResultSets=True
The Orchard setup program gave me an error that
Login failed for user 'IIS APPPOOL\Orchard'
Try as I may, I cannot find or get SQL Server to accept this user name. What am I supposed to do? For now I just installed Orchard with an internal, i.e. SQL CE database.