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
*****************************************************************************
1
2 <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
3 <connectionStrings>
4 <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" />
5 </connectionStrings>
6 <system.web>
7 <pages styleSheetTheme="Black"/>
8 <customErrors mode="RemoteOnly"/>
9 <compilation debug="true"/>
10 <authentication mode="Forms">
11 <forms loginUrl="Default.aspx" protection="Validation" timeout="300"/>
12 </authentication>
13 <authorization>
14 <allow users="*"/>
15 </authorization>
16 <globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
17 <!--<roleManager enabled="true"/>-->
18 <membership>
19 <providers>
20 <remove name="AspNetSqlMembershipProvider" />
21 <add name="AspNetSqlMembershipProvider"
22 type="System.Web.Security.SqlMembershipProvider,System.Web, Version=2.0.0.0, Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a"
23 connectionStringName="Personal"
24 enablePasswordRetrieval="false"
25 enablePasswordReset="true"
26 requiresQuestionAndAnswer="true"
27 applicationName="/"
28 requiresUniqueEmail="false"
29 passwordFormat="Hashed"
30 maxInvalidPasswordAttempts="5"
31 minRequiredPasswordLength="7"
32 minRequiredNonalphanumericCharacters="1"
33 passwordAttemptWindow="10"
34 passwordStrengthRegularExpression="" />
35 </providers>
36 </membership>
37 <profile>
38 <providers>
39 <remove name="AspNetSqlProfileProvider" />
40 <add name="AspNetSqlProfileProvider"
41 connectionStringName="Personal"
42 applicationName="/"
43 type="System.Web.Profile.SqlProfileProvider,System.Web, Version=2.0.0.0, Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" />
44 </providers>
45 </profile>
46 <!--<roleManager enabled="true">
47 <providers>
48 <remove name="AspNetSqlRoleProvider" />
49 <add name="AspNetSqlRoleProvider"
50 connectionStringName="Personal"
51 applicationName="/"
52 type="System.Web.Security.SqlRoleProvider,System.Web, Version=2.0.0.0, Culture=neutral,PublicKeyToken=b03f5f7f11d50a3a" />
53 </providers>
54 </roleManager>-->
55 <siteMap defaultProvider="XmlSiteMapProvider" enabled="true">
56 <providers>
57 <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"/>
58 </providers>
59 </siteMap>
60 </system.web>
61 <location path="Admin">
62 <system.web>
63 <authorization>
64 <allow roles="Administrators"/>
65 <deny users="*"/>
66 </authorization>
67 </system.web>
68 </location>
69 </configuration>
70