JT_SIRO
asked on
SQL Server rookie... How does .NET and SQL Server interact
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_FullAcc ess', 'Network Service'
or
sp_addrolemember 'aspnet_Membership_FullAcc ess', '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
The EXECUTE permission was denied on the object 'aspnet_CheckSchemaVersion
Everything online says to run this:
sp_addrolemember 'aspnet_Membership_FullAcc
or
sp_addrolemember 'aspnet_Membership_FullAcc
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
When I try to grant permissions with this:
sp_addrolemember 'aspnet_Membership_FullAcc
I get this error message:
Msg 15014, Level 16, State 1, Procedure sp_addrolemember, Line 36
The role 'aspnet_Membership_FullAcc
OK, so I decided that I'll remove and re-install aspnet_sqlreg.exe to get it back. When I run the installer, I get this error, saying that it can't install because aspnet_Membership_FullAcce
sshot.JPG