I double checked my connection string:

it works on
<add name="LocalSqlServer" connectionString="Data
Source=myComputerName;database=myDB;uid=**;pwd=**;"
providerName="System.Data.SqlClient"/>
or
<add name="LocalSqlServer"
connectionString="Server=(local);database=sunodeuo;uid=sa;pwd=purvis;"
providerName="System.Data.SqlClient"/>

I forgot the "( )" around "local".

Now using LocalSqlServer works, as Scootgu's blog, we can simplly
change the LocalSqlServer to point to the sql2k or sql2k5, but I still
want to try MSSql2k connectionString and mySqlMembershipProvider, as
following.

-------------------------------------------------------------------------------
<roleManager enabled="true"  defaultProvider="myRoleProvider">
     <providers>
       <clear/>
       <add connectionStringName="MSSql2k"
            applicationName="myAppl"
            name="myRoleProvider"
            type="System.Web.Security.SqlRoleProvider, System.Web,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
     </providers>
   </roleManager>
   <membership defaultProvider="mySqlMembershipProvider">
     <providers>
       <clear/>
       <add connectionStringName="MSSql2k"
enablePasswordRetrieval="false"
         enablePasswordReset="true" requiresQuestionAndAnswer="true"
         applicationName="myAppl" requiresUniqueEmail="true"
passwordFormat="Hashed"
         maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7"
         minRequiredNonalphanumericCharacters="1"
passwordAttemptWindow="10"
         passwordStrengthRegularExpression=""
name="AspNetSqlMembershipProvider"
         type="System.Web.Security.SqlMembershipProvider, System.Web,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

<add connectionStringName="MSSql2k" applicationName="myAppl"
         enablePasswordRetrieval="true" enablePasswordReset="true"
requiresQuestionAndAnswer="true"
         requiresUniqueEmail="true" passwordFormat="Encrypted"
maxInvalidPasswordAttempts="5"
         passwordAttemptWindow="10" minRequiredPasswordLength="7"
minRequiredNonalphanumericCharacters="0"
         name="mySqlMembershipProvider"
type="System.Web.Security.SqlMembershipProvider, System.Web,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
     </providers>
   </membership>

------------------

But when I choose Select a different provider for each feature
(advanced)

Use this page to select a provider for each feature.

Membership Provider
AspNetSqlMembershipProvider     Test
mySqlMembershipProvider     Test

Role Provider
myRoleProvider       (HERE IT DOES NOT HAVE Test hyperlink)

is the roleProvider working even though there is no test hyperlink
since the Membership Provider is working.?
Again thanks

On Mar 8, 8:03 pm, Peter Bromberg [C# MVP]
<pbromb...@yahoo.NoSpamMaam.com> wrote: