Development Blog by max

Will be used to tell you about wonderful new features in maxphotoblog

IIS User Woes Wednesday, December 21, 2011 9:48:16 AM

If you are using IIS ASP.net 4 EF and just published your site expecting the db to be created, and it isn't.
I'll just leave this here:

sp_grantlogin 'IIS APPPOOL\ASP.NET v4.0'
sp_grantdbaccess 'IIS APPPOOL\ASP.NET v4.0'
sp_addrolemember 'db_owner', 'IIS APPPOOL\ASP.NET v4.0'
SP_ADDSRVROLEMEMBER 'IIS APPPOOL\ASP.NET v4.0', 'sysadmin'

  • Add Comment