how to give proper permission for asp.net in sql server express

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Chen Xiyang (settinghead_at_hotmil.com)
Date: 03/01/05 

Date: Tue, 01 Mar 2005 22:50:46 +0800

hi,

i have a problem which bothered me for a long time. i tried to connect
my asp.net page with sql server express 2005 and always got some error
msg telling that the current nt account doen't have enough permission.

i know this happens because i havn't given proper permission to the
internet guest account. i tried the following sql statements in visual
studio, but no one worked:

sp_grantlogin 'machine_name\ASPNET'
sp_grantlogin 'IUSR_MACHINE_NAME'
sp_grantdbaccess 'machine_name\ASPNET', 'Common User'
sp_grantdbaccess 'machine_name\ASPNET', 'DBO'
sp_grantdbaccess 'IUSR_MACHINE_NAME', 'Common User'
sp_grantdbaccess 'IUSR_MACHINE_NAME', 'DBO'
......

besides the problem, now i begin to be messed up with those sql server
permission stuff. anyone can help to figure it out? or is there any
article that can help me have a better understanding of that?

thanks.

Relevant Pages

  • Re: Column Level Permissions Security Issue
    ... role is granted SELECT rights as in "GRANT SELECT TO RWE", then a DENY ... When working with security in SQL Server it's imperative to understand ... discusses ownership chaining: http://www.sommarskog.se/dynamic_sql.html. ... there are users who have permission to access this ...
    (microsoft.public.sqlserver.security)
  • Re: SQL CLR Sproc isnt running right
    ... did you grant rights using the SQL Server 2005 Surface Area Config tool? ... and I got a permissions error back saying DBO doesn't have permission to insert records into the table... ... but the assemblie's stored procedures do all have execute permissions set for the role that the executing user is in... ... "William Vaughn" wrote in message ...
    (microsoft.public.dotnet.framework.adonet)
  • System.Security.SecurityException with .NET 2005 Only
    ... Crystal Report from a SQL Server 2000 table. ... Friend WithEvents scnSQLConnection As _ ... The dialog box suggests clicking on "Add Permission to the Project." ... Restart the debugging session, same problem again. ...
    (microsoft.public.dotnet.languages.vb)
  • After 2003 to 2005 Upgrade Wizard, Getting System.Security.SecurityException
    ... Crystal Report from a SQL Server 2000 table. ... Friend WithEvents scnSQLConnection As _ ... The dialog box suggests clicking on "Add Permission to the Project." ... Restart the debugging session, same problem again. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Error !!! SQL XML Bulkload Please help
    ... Irwin Dolobowsky ... > The schedule job gets run by SQL server Agent and the SQL server agent is ... > which has also got the administrator permission. ... Is the scheduled job running as a different user? ...
    (microsoft.public.sqlserver.xml)