Solved

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

Posted on 2010-08-19
2
404 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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.
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

762 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now