wrote:
> There's just this one other thing that bothers me about this: how does the
> ASP.NET Configuration Wizard know which host and sql server instance name to
> look for?
>
> Thanks.
>
>
>
> "Jibey Jacob" wrote:
> > Hi:
>
> > I'm having trouble setting this up. I placed the following information in
> > web.config:
>
> > <membership userIsOnlineTimeWindow="20">
> > <providers>
> > <add connectionStringName="SqlServices"
> > enablePasswordRetrieval="false"
> > enablePasswordReset="true" requiresQuestionAndAnswer="true"
> > passwordFormat="Hashed" applicationName="jibey.jacob"
> > name="SqlProvider"
> > type="System.Web.Security.SqlMembershipProvider" />
> > </providers>
> > </membership>
>
> > When I launch the ASP.NET Configuration wizard from Visual Studio, and flip
> > to the Security tab, I can see one provider listed (I selected single
> > provider for all site management), which is AspNetSqlProvider. The
> > connnection string "SqlServices" exists in web.config. The problem is the
> > wizard always comes back with an error that says "unable to establish a
> > connection to the database".
>
> > Before I placed all this information in web.config, I had started with a
> > bare-bones web.config that VS2005 had created. And I created the membership
> > database in SQL Server using aspnet_regsql.
>
> > What am I doing wrong?
>
> > Thanks.- Hide quoted text -
>
> - Show quoted text -

"Alexey Smirnov" wrote:

> On Jul 9, 5:08 am, Jibey Jacob <JibeyJa...@discussions.microsoft.com>
> wrote:
> > There's just this one other thing that bothers me about this: how does the
> > ASP.NET Configuration Wizard know which host and sql server instance name to
> > look for?
> >
> > Thanks.
> >
> >
> >
> > "Jibey Jacob" wrote:
> > > Hi:
> >
> > > I'm having trouble setting this up. I placed the following information in
> > > web.config:
> >
> > > <membership userIsOnlineTimeWindow="20">
> > > <providers>
> > > <add connectionStringName="SqlServices"
> > > enablePasswordRetrieval="false"
> > > enablePasswordReset="true" requiresQuestionAndAnswer="true"
> > > passwordFormat="Hashed" applicationName="jibey.jacob"
> > > name="SqlProvider"
> > > type="System.Web.Security.SqlMembershipProvider" />
> > > </providers>
> > > </membership>
> >
> > > When I launch the ASP.NET Configuration wizard from Visual Studio, and flip
> > > to the Security tab, I can see one provider listed (I selected single
> > > provider for all site management), which is AspNetSqlProvider. The
> > > connnection string "SqlServices" exists in web.config. The problem is the
> > > wizard always comes back with an error that says "unable to establish a
> > > connection to the database".
> >
> > > Before I placed all this information in web.config, I had started with a
> > > bare-bones web.config that VS2005 had created. And I created the membership
> > > database in SQL Server using aspnet_regsql.
> >
> > > What am I doing wrong?
> >
> > > Thanks.- Hide quoted text -
> >
> > - Show quoted text -
>
> Jubey,
>
> I think your problem is in the defaultProvider property which is not
> specified.
>
> Quote: When specifying the membership Element (ASP.NET Settings
> Schema) section, you must specify the defaultProvider attribute. If
> you do not specify a membership Element (ASP.NET Settings Schema)
> section in your Web.config, the values from the machine configuration
> are used and the SqlMembershipProvider instance named
> AspNetSqlProvider is established as the defaultProvider.
>
> http://msdn2.microsoft.com/en-us/library/system.web.security.membership.providers.aspx
>
> Hope this helps
>