DB Config Tips and Hints

From Cubex Wiki
Jump to: navigation, search

So this works.

In Internet Information Services (IIS) Manager, select the Application Pools > DefaultAppPool and then click the “Advanced Settings…” on the right.

IISAppPool.jpg


Make sure the Identity is set as “ApplicationPoolIdentity”.

AppPoolIdentity.jpg


Go to SQL Server Management Studio and make sure you are connected with your Windows Authentication. Open up the Security node under your server and right click on the Logins node, then select “New Login…”. Enter in “IIS APPPOOL\DefaultAppPool” for the Login name.

DefaultAppPool.jpg


Then select the “User Mapping” node and check the “PersistenceModel” database and then check the “db_owner” “Database role membership…” below. Then click OK.

DBOwner.jpg


You’ll probably need to restart IIS for it to pick everything up, but then you should have access via the debugger, Postman, etc…



Example.jpg