Re: SQL Membership Provider Problem

Sloan:
If you are interested in the solution I found (with your help) please see my
response to Seven on this thread.
Thanks for the help
Gary

"sloan" <sloan@xxxxxxxxx> wrote in message
news:O4CemiC5HHA.5844@xxxxxxxxxxxxxxxxxxxxxxx
Ahh.
Yeah. You have to "override" the defaults for both the Membership and
Roles provider.

.........

Also check the "integrated security" issue, with the mdf.

Source=DEVSERVER2003;Initial Catalog=PTPSecurity;Integrated Security=True"


And make sure you know which account the webpage is running under, aka, if
that account has privs on that particuliar database.


Gary, did you get your issue resolved?




"Steven Cheng[MSFT]" <stcheng@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:4TMKe8t4HHA.4200@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi Sloan,

From Gary's initial message, it seems he has registered a new membership
provider entry and use its own connectionstring, therefore, I don't think
the problem is caused by the default "LocalSqlServer" connection string.
How do you think?

Hi Gary,

At the end of your last message, you said that the problem just occur
when
you try accessing roles (in both code or the admin site page), I think
the
problem is likely caused by the "Role manager" provider setting. For
ASP.NET 2.0 membership &role manager service, they use separate provider,
one for membership(user accounts) and another for role manager(for
roles).
In your message, I think what you've changed is the default provider for
the membership service, you may still need to override the "role manager"
setting so as to make it also use your new SQL server standard instance
and
database.

Here are some web articles mentioned the configuration for Rolemanager
provider, you can try customize your role provider setting acorrding to
it:

#providers Element for roleManager (ASP.NET Settings Schema)
http://msdn2.microsoft.com/en-us/library/ms164661.aspx

#Membership and Role Providers in ASP.NET 2.0 Part II
http://www.odetocode.com/Articles/428.aspx

#How To: Use Role Manager in ASP.NET 2.0
http://msdn2.microsoft.com/en-us/library/ms998314.aspx

Hope this helps.

Sincerely,

Steven Cheng

Microsoft MSDN Online Support Lead



==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.



Note: The MSDN Managed Newsgroup support offering is for non-urgent
issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each
follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.

==================================================


This posting is provided "AS IS" with no warranties, and confers no
rights.



















.

Relevant Pages

  • Re: Defining Groups with AD users
    ... For ASP.NET authentication and role based authorization, ... you can configure the membership to use AD ... membership provider and Rolemanager to use SQL server provider. ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • RE: Different password policies for different roles
    ... As you have found, by default, each ASP.NET membership provider has a set ... password related policy to the loosest level. ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Defining Groups with AD users
    ... For ASP.NET authentication and role based authorization, ... you can configure the membership to use AD ... membership provider and Rolemanager to use SQL server provider. ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: SQL Membership Provider Problem
    ... problem is likely caused by the "Role manager" provider setting. ... ASP.NET 2.0 membership &role manager service, they use separate provider, ... Microsoft MSDN Online Support Lead ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: MembershipProvider and ADAM
    ... membership provider has choosed to use SSL connection to access AD server. ... following article which has mentioned the AD connectionstring and provider ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.aspnet.security)