Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 466
  • Last Modified:

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_FullAccess', 'Network Service'
or
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


0
JT_SIRO
Asked:
JT_SIRO
1 Solution
 
JT_SIROAuthor Commented:
Here's some more info on the problem I'm having.  It's getting worse as I try to remedy the issues.

When I try to grant permissions with this:
sp_addrolemember 'aspnet_Membership_FullAccess', 'Network Service'

I get this error message:
Msg 15014, Level 16, State 1, Procedure sp_addrolemember, Line 36
The role 'aspnet_Membership_FullAccess' does not exist in the current database.

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_FullAccess already exists.   WTH?!?!?!?!


sshot.JPG
0
 
Carl TawnSystems and Integration DeveloperCommented:
Which account you need will depend on which account is accessing the site. It should be the ASPNET account (if you are allowing anonymous users and using Forms authentication and you have Integrated Security in your connection string), otherwise it will be the Windows user account who is accessing the site.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now