Daniel
Mon May 21 04:16:05 CDT 2007
Hi Scott,
do you still have the problem?
Please let me know if you need further assistance!
/Daniel Bugday
"Scott Townsend" <scooter133@community.nospam> wrote in message
news:AEA20E78-89B6-48C0-B896-6571D6749AE5@microsoft.com...
> Hey Daniel, Thank you for your reply.
>
> Yes, I'm usiong SQL and have the aspnetdb on the SQL Server and have
> VS.Net2005 and am abel to add and manage users and groups.
>
> From the WSS Site I can lookup users with no problems, so the Permissions
> and Connection string to the DB should be fine.
>
> I'm thinking it might be something in my <roleManager enabled="true"
> defaultProvider="AspNetSqlRoleProvider"> section of the Web.Config.
> Thanks!
>
> I have the following in my Web.Config files:
> [...snip...]
> <PeoplePickerWildcards>
> <clear />
> <add key="AspNetSqlMembershipProvider" value="%" />
> <add key="AspNetSqlRoleProvider" value="%" />
> </PeoplePickerWildcards>
> </SharePoint>
> <connectionStrings>
> <remove name="LocalSqlServer" />
> <add name="LocalSqlServer"
> connectionString="Server=SVR-SQL;Database=aspnetdb;uid=FAAdmin;pwd=faapw;"
> providerName="System.Data.SqlClient" />
> <remove name="AspNetSqlProvider" />
> <add name="AspNetSqlProvider"
> connectionString="Server=SVR-SQL5;Database=aspnetdb;uid=FAAdmin;pwd=faapw;"
> providerName="System.Data.SqlClient" />
> </connectionStrings>
> <system.web>
> <membership defaultProvider="AspNetSqlMembershipProvider">
> <providers>
> <remove name="AspNetSqlMembershipProvider" />
> <add connectionStringName="AspNetSqlProvider"
> passwordAttemptWindow="10" enablePasswordRetrieval="false"
> enablePasswordReset="true" requiresQuestionAndAnswer="true"
> applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed"
> description="Stores and retrieves membership data from the Microsoft SQL
> Server database" name="AspNetSqlMembershipProvider"
> type="System.Web.Security.SqlMembershipProvider, System.Web,
> Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
> </providers>
> </membership>
> <roleManager enabled="true" defaultProvider="AspNetSqlRoleProvider">
> <providers>
> <remove name="AspNetSqlRoleProvider" />
> <add connectionStringName="AspNetSqlProvider" applicationName="/"
> description="Stores and retrieves roles data from the local Microsoft SQL
> Server database" name="AspNetSqlRoleProvider"
> type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.3600.0,
> Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
> </providers>
> </roleManager>
> [...snip...]
>
> "Daniel Bugday" <itkonsult@gmail.com> wrote in message
> news:760CAF45-EA56-4634-9EC2-09F93031603B@microsoft.com...
>> Hi Scott,
>>
>> first of all:
>>
>> Users and Roles are created in the aspnetdb on the SQL server. Users
>> refers to SQL Users and Roles refers to SQL Roles (like groups but in
>> SQL).
>> -Users and Roles are found under security in the aspnetdb.
>>
>> Has your application pool account permission (db_datareader and
>> db_datawriter) in the aspnet DB in SQL?
>>
>> If you hav Visual Studio installed and have you web FORM ASP.net
>> application in it you can connect to the ASP.net Web Site Administration
>> Tool
>> -This tool is just to create and manage users and roles for the
>> MemberShip table and aspnet_Users table in the aspnetdb in SQL Server.
>>
>> Is the web.config file below the one under c:\inetpub\wwwroot or the
>> machine.config file under microsoft.net folder?
>>
>> It seems to me that your web.config file doesn't recognice the
>> connectionstring? Is you SQL server named AspNetSqlRoleProvider?
>>
>> Hope this answers your question!
>>
>> /Daniel Bugday
>>
>>
>> "Scott Townsend" <scooter133@community.nospam> wrote in message
>> news:2E31632E-07B6-454F-939F-DF4C093593A7@microsoft.com...
>>> So after Following:
>>>
http://blogs.msdn.com/sharepoint/archive/2006/08/16/configuring-multiple-authentication-providers-for-sharepoint-2007.aspx
>>> and
>>>
http://weblog.vb-tech.com/nick/archive/2006/06/14/1617.aspx
>>>
>>> I have Forms Based Authenticatiuon mostly working on a seperate AAM URL
>>> for my WSS Site.
>>>
>>> I'd like to be able to use Roles. It does not seem to work for me, or
>>> I'm not understanding what Roles are.
>>>
>>> I've created my Users and Added them to Roles. I go into the WSS site
>>> and I can see the User Names in search, though I cannot see any of the
>>> roles that I entered.
>>>
>>> I've added the Following to the WebConfig:
>>> <roleManager enabled="true" defaultProvider="AspNetSqlRoleProvider">
>>> <providers>
>>> <remove name="AspNetSqlRoleProvider" />
>>> <add connectionStringName="AspNetSqlProvider" applicationName="/"
>>> description="Stores and retrieves roles data from the local Microsoft
>>> SQL Server database" name="AspNetSqlRoleProvider"
>>> type="System.Web.Security.SqlRoleProvider, System.Web,
>>> Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
>>> </providers>
>>> </roleManager>
>>>
>>> I've gone into the ASP.Net Configuration Settings in IIS Manager and
>>> made sure that the Roles is enabled and that AspNetSqlRoleProvider is
>>> selected.
>>>
>>> When I enter in the Roll name for the user, it says it cant find any
>>> matches.
>>>
>>> Scott<-
>>>
>>>
>>
>