Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
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…

791 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