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
MKozlowski
Member
500 Points
573 Posts
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>mishra.bhupe...
Participant
1594 Points
376 Posts
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.
Chen Yu - MS...
All-Star
21569 Points
2493 Posts
Microsoft
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.
Feedback to us
Develop and promote your apps in Windows Store
christiandev
Star
8597 Points
1841 Posts
Re: User does not have permission to perform this action
May 09, 2012 08:15 AM|LINK
What action are you trying to perform? where are you running the web app?
Regards, Christiandev (@chrisdev80), MCPD Web (2 & 4) & MCTS Windows (www.ScoreDonkey.com)