SQL Server rookie... How does .NET and SQL Server interact
Posted on 2010-08-19
I've got a .NET app and have just attempted to set up the .NET Membership tables on my SQL Server. I ran aspnet_regsql.exe on my server and it went fine. But when I try to access it via my web app I keep getting SQL Server permissions issues, like:
The EXECUTE permission was denied on the object 'aspnet_CheckSchemaVersion', database 'SmashHaus', schema 'dbo'.
Everything online says to run this:
sp_addrolemember 'aspnet_Membership_FullAccess', 'Network Service'
sp_addrolemember 'aspnet_Membership_FullAccess', 'dbo'
I can't! There is no Network Service user for my DB. And when I try it with dbo, it won't allow it. So I ran the sp with the my Default app pool. That worked for some of the errors I was getting. Now I'm stuck.
My big question is, what user is .NET hitting these stored procs with? dbo? Network Service? My app pool name? Sys?
Oh and I'm running Windows Server 2008 R2