Solved

SQL Server rookie...  How does .NET and SQL Server interact

Posted on 2010-08-19
2
424 Views
Last Modified: 2012-05-10
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
Comment
Question by:JT_SIRO
2 Comments
 

Author Comment

by:JT_SIRO
ID: 33477989
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
 
LVL 52

Accepted Solution

by:
Carl Tawn earned 500 total points
ID: 33478835
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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Modal Popup Extender control 1 22
Server Rebuild after 2 drive in raid crashed 16 46
insert value of checklistbox checked 4 27
Cleaning up a desktop after leaving a domain 3 27
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question