asp.net - Bruger har ikke tilladelse til at udføre denne handling. ? hvad var problemet

Indlæg af Hanne Mølgaard Plasc

Problem



Når jeg uploade mit websted i aspspider.com så viser det følgende meddelelse .. Hvad var problemet i det ... jeg er helt forvirret ..


Jeg bruger standard dataase af asp.net nemlig ASPNETDB.MDF


Server Error in '/dobriyal' Application.

User does not have permission to perform this action.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: User does not have permission to perform this action.

Source Error: 


Line 7:          Dim cmdSelect As New System.Data.SqlClient.SqlCommand("SELECT Password FROM a1\_admins WHERE EmployeeId =" & TextBox1.Text & " And Email = '" & TextBox2.Text & "'", SQLData)
Line 8:  
Line 9:          SQLData.Open()
Line 10:         Dim dtrReader As System.Data.SqlClient.SqlDataReader = cmdSelect.ExecuteReader()
Line 11:         If dtrReader.HasRows Then

Source File: C:MemberSitesMemberSites\_AspSpider\_Orgdobriyalwebrootadminforgot\_password.aspx.vb    Line: 9 

Stack Trace: 


[SqlException (0x80131904): User does not have permission to perform this action.]
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +1019
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +108
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
   System.Data.SqlClient.SqlConnection.Open() +125
   admin\_forgot\_password.Button1\_Click(Object sender, EventArgs e) in C:MemberSitesMemberSites\_AspSpider\_Orgdobriyalwebrootadminforgot\_password.aspx.vb:9
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1

Bedste reference


Det ser ud til, hvilken bruger du bruger til at oprette forbindelse til databasen, og har ikke valgt tilladelser på den tabel.


Brug stipend til at fastsætte det. [2]

Andre referencer 1


Det er din database, der ikke har tilladt brugerens tilladelse. I din forbindelsestreng, hvilken bruger er den? Brug 'Grant' for at give denne SQL-bruger den nødvendige adgang. Det er sandsynligvis nødvendigt at kunne vælge fra de nødvendige tabeller. [3]