EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database '695746_default', schema 'dbo' RSS

• • Reply
  

  przemeklach

  Member

  227 Points

  119 Posts

  EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database '695746_default', schem...

  Jun 26, 2006 01:36 AM|LINK

  Hi,
  I have followed Sue's tutorial on how to upload and configure my website. I am still having an issue when I try to configure permissions/roles using the ASP. Net configuration tool.
  I am able to start it but when I click Security I get the error below. Also below is my web.conf file. I am hosting with gate.com, incase someone is with them as well and has had a similar experience.
  If someone has maybe they can explain to me what some of those xml values mean. I can follow a tutorial but I am poor at troubleshooting because I don't know what all those valuse mean; provider, rolemanager etc.. Thank you.
  ERROR:
  ***************************************************************************
  There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
  
  The following message may help in diagnosing the problem: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database '695746_default', schema 'dbo'.
  *****************************************************************************
  WEB.CONFIG
  *****************************************************************************
  
   

  <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
    <connectionStrings>
      <add name="Personal" connectionString="Data Source=sql002.whp.server-hosting.com;Initial Catalog=695746_default;Persist Security Info=True;UID=****;PWD=****" providerName="System.Data.SqlClient" />
    </connectionStrings>
    <system.web>
      <pages styleSheetTheme="Black"/>
  		<customErrors mode="RemoteOnly"/>
  		<compilation debug="true"/>
  		<authentication mode="Forms">
  			<forms loginUrl="Default.aspx" protection="Validation" timeout="300"/>
  		</authentication>
  		<authorization>
  			<allow users="*"/>
  		</authorization>
  		<globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
  		<!--<roleManager enabled="true"/>-->
      <membership>
        <providers>
          <remove name="AspNetSqlMembershipProvider" />
          <add name="AspNetSqlMembershipProvider"
          type="System.Web.Security.SqlMembershipProvider,System.Web, Version=2.0.0.0, Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a"
          connectionStringName="Personal"
          enablePasswordRetrieval="false"
          enablePasswordReset="true"
          requiresQuestionAndAnswer="true"
          applicationName="/"
          requiresUniqueEmail="false"
          passwordFormat="Hashed"
          maxInvalidPasswordAttempts="5"
          minRequiredPasswordLength="7"
          minRequiredNonalphanumericCharacters="1"
          passwordAttemptWindow="10"
          passwordStrengthRegularExpression="" />
        </providers>
      </membership>
      <profile>
        <providers>
          <remove name="AspNetSqlProfileProvider" />
          <add name="AspNetSqlProfileProvider"
          connectionStringName="Personal"
          applicationName="/"
          type="System.Web.Profile.SqlProfileProvider,System.Web, Version=2.0.0.0, Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" />
        </providers>
      </profile>
      <!--<roleManager enabled="true">
        <providers>
          <remove name="AspNetSqlRoleProvider" />
          <add name="AspNetSqlRoleProvider"
          connectionStringName="Personal"
          applicationName="/"
          type="System.Web.Security.SqlRoleProvider,System.Web, Version=2.0.0.0, Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" />
        </providers>
      </roleManager>-->
  		<siteMap defaultProvider="XmlSiteMapProvider" enabled="true">
  			<providers>
  				<add name="XmlSiteMapProvider" description="SiteMap provider which reads in .sitemap XML files." type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" siteMapFile="web.sitemap" securityTrimmingEnabled="true"/>
  			</providers>
  		</siteMap>
  	</system.web>
  	<location path="Admin">
  		<system.web>
  			<authorization>
  				<allow roles="Administrators"/>
  				<deny users="*"/>
  			</authorization>
  		</system.web>
  	</location>
  </configuration>

   
• • Reply
  

  przemeklach

  Member

  227 Points

  119 Posts

  Re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database '695746_default', s...

  Jun 26, 2006 04:29 AM|LINK

  Got it fixed, kind of
  I went into the database on the server and gave explicity permissions for each of the stored procedures, including the one above, for the user I was trying to login with the ASP configuration.
  I hope this was the right way. Maybe this is something that I was supposed to configure in the web.config file.
  If someone knows, can they let me know if I did this correctly.
  Thanks.
  
• • Reply
  

  przemeklach

  Member

  227 Points

  119 Posts

  Re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database '695746_default', s...

  Jun 26, 2006 05:17 AM|LINK

  So it appears to be working. I've been trying to setup the permissions/roles and I'm a little confused. Is it possible to set permissions on individual files: for example if I only want certain users to access resume.aspx how do I set it?
  Secondly, for some reason Allow for all user/roles is enabled and I cannot delete it. How do I disable this so that no one except for the users I specify have access?
  Thanks.
  
• • Reply
  

  John Murphy

  Member

  62 Points

  13 Posts

  Re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database '695746_default', s...

  Jun 28, 2006 12:54 PM|LINK

  If you put the resume.aspx in the admin folder or in a seperate folder you can then control who has access through their role in the configuration tool

  On the seocnd part, do you mean access to the site or to an individual page?

  JM
  http://www.avandale.org
• • Reply
  

  ViniciusCama...

  Member

  12 Points

  1 Post

  Re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database '695746_default', s...

  Oct 16, 2007 07:43 PM|LINK

  Please check your database user roles.
  It's necessary the database user to be owner.
  Only it.

  • Marked as answer by przemeklach on Oct 30, 2007 07:35 AM
• • Reply
  

  switter65

  Member

  43 Points

  56 Posts

  Re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database '695746_default', s...

  Jul 10, 2008 09:42 PM|LINK

  I fixed this by adding the following role memberships to the users:

  aspnet_Membership_BasicAccess

  aspnet_Membership_FullAccess

  aspnet_Membership_ReportingAccess

• • Reply
  

  BNDIT

  Member

  85 Points

  94 Posts

  Re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database '695746_default', s...

  Aug 12, 2008 11:37 PM|LINK

  Please kindly advise detailed steps of what you have done. Thanks.

• • Reply
  

  umbyersw

  Member

  220 Points

  41 Posts

  Re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database '695746_default', s...

  Aug 25, 2008 09:54 PM|LINK

   

  ViniciusCamara

  Please check your database user roles.
  It's necessary the database user to be owner.
  Only it.

  Assigning db_owner to your user will give them more access than they need.

  What you should instead do, is grant the user the following Roles:

  • <div mce_keep="true">aspnet_Membership_FullAccess</div>
  • <div mce_keep="true"> <div mce_keep="true">aspnet_Roles_FullAccess</div></div>
  • <div mce_keep="true"> <div mce_keep="true">etc. depending on what features you have enabled/installed into this database</div></div>

  <div mce_keep="true">Do this by using Microsoft SQL Server Management Studio or Microsoft SQL Server Management Studio Express</div>

  1. <div mce_keep="true">Connect to the database you are working with</div>
  2. <div mce_keep="true">Open Databases</div>
  3. <div mce_keep="true">Open the database you are working with</div>
  4. <div mce_keep="true">Open Security</div>
  5. <div mce_keep="true">Open Users</div>
  6. <div mce_keep="true">Double-click the user who is accessing the database</div>
  7. <div mce_keep="true">In the list of Owned Schemas, check off the roles indicated above</div>
  Wes
  www.umbyersw.com
  • Edited by umbyersw on Aug 25, 2008 09:58 PM
  • Marked as answer by TATWORTH on Nov 08, 2009 11:54 AM
• • Reply
  

  raghav_khung...

  All-Star

  32835 Points

  5563 Posts

  MVP

  Re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database '695746_default', s...

  Nov 26, 2008 06:31 PM|LINK

  Hi,

  I was Also Facing Same Problem

  I got the solution

  By executing this queries in Query Analyzer

   

  GRANT EXECUTE ON dbo.aspnet_CheckSchemaVersion TO "myUserName"

  GRANT EXECUTE ON dbo.aspnet_Membership_CreateUser TO "myUserName"

  GRANT EXECUTE ON dbo.aspnet_Membership_GetPasswordWithFormat TO "myUserName"

   

   

   Thanks

  Raghav|My Articles|My Blog
  
• • Reply
  

  raghav_khung...

  All-Star

  32835 Points

  5563 Posts

  MVP

  Re: EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database '695746_default', s...

  Nov 26, 2008 06:33 PM|LINK

  Hi,

  I was Also Facing Same Problem

  I got the solution

  By executing this queries in Query Analyzer

   

  GRANT EXECUTE ON dbo.aspnet_CheckSchemaVersion TO "myUserName"

  GRANT EXECUTE ON dbo.aspnet_Membership_CreateUser TO "myUserName"

  GRANT EXECUTE ON dbo.aspnet_Membership_GetPasswordWithFormat TO "myUserName"

   

   

   Thanks

  Raghav|My Articles|My Blog