User does not have permission to perform this action : The Official Microsoft ASP.NET Forums

Reply

User does not have permission to perform this action

May 04, 2012 07:00 PM|LINK

Hi , I am getting a very strange error on my web app.

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

Anyone seen this?

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
  
  <connectionStrings>
    <remove name="LocalSqlServer"/>
    <add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true"/>
    <add name="aspnet_staterKits_TimeTracker" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true"/>
    <add name="TimeTrackerConnectionString" connectionString="Data Source=Server\SQLEXPRESS;Initial Catalog=TimeTracker;Integrated Security=True" providerName="System.Data.SqlClient"/>
  </connectionStrings>
  <system.web>
    <siteMap defaultProvider="AspNetXmlSiteMapProvider" enabled="true">
      <providers>
        <clear/>
        <add name="AspNetXmlSiteMapProvider" type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" siteMapFile="web.sitemap" securityTrimmingEnabled="true"/>
      </providers>
    </siteMap>
    <authentication mode="Windows"/>
    <identity impersonate="true"/>
 
    <compilation debug="true" targetFramework="4.0">
      <assemblies>
        <add assembly="System.DirectoryServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>
        <add assembly="System.DirectoryServices.AccountManagement, Version=4.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
      </assemblies>
    </compilation>
    <machineKey decryptionKey="AutoGenerate,IsolateApps"/>
    <roleManager enabled="true"/>
    <pages controlRenderingCompatibilityVersion="3.5" clientIDMode="AutoID"/>
  </system.web>
  <appSettings>
    <add key="LDAPsvcAcct" value="Username"/>
    <add key="LDAPsvcPass" value="Password"/>
  </appSettings>
  <system.webServer>
    <validation validateIntegratedModeConfiguration="false"/>
  </system.webServer>
</configuration>

Edited by MKozlowski on May 04, 2012 07:59 PM
Edited by MKozlowski on May 04, 2012 08:00 PM

Reply

Re: User does not have permission to perform this action

May 05, 2012 05:52 AM|LINK

Login into your Windows system via Administrator account and run your application. I think you will not get this error.

Reply

Re: User does not have permission to perform this action

May 09, 2012 03:07 AM|LINK

Hi MKozowski,

Please check your user whether it has enough permission to execute SQL query. If the problem still here, please show us your whole error message, it will provide us more information about your problem.

Thanks.

Please mark the replies as answers if they help or unmark if not.
Feedback to us

Develop and promote your apps in Windows Store