Skip to content

Instantly share code, notes, and snippets.

@tompazourek

tompazourek/AppPoolUser.sql

Created September 4, 2015 16:55
Show Gist options
  • Save tompazourek/fb87b6f0c2d3d55ee370 to your computer and use it in GitHub Desktop.
Save tompazourek/fb87b6f0c2d3d55ee370 to your computer and use it in GitHub Desktop.
Download ZIP
Add IIS App Pool User to SQL Server.
Raw
AppPoolUser.sql
-- http://stackoverflow.com/a/16310139/108374
CREATE LOGIN [IIS APPPOOL\MyAppPool] FROM WINDOWS;
CREATE USER MyAppPoolUser FOR LOGIN [IIS APPPOOL\MyAppPool];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment