Re: Setting up ASP.NET Configuration in Visual Studio 2005

On Jul 9, 5:08 am, Jibey Jacob <JibeyJa...@xxxxxxxxxxxxxxxxxxxxxxxxx>
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

.

Relevant Pages

  • Re: FTI, Searching and other Filters
    ... No matter what I specify for a search condition, ... "SQL SERVER DBA"') ... Remove the FTI from the table. ... Add an OfficeID column to the table and populate it. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: ORDER BY in VIEW not working
    ... Only the queries issued against a view can ... typing an ORDER BY clause. ... State what version of SQL Server you are using and specify the content ...
    (comp.databases.ms-sqlserver)
  • Re: SQL Server 2005 - CLR Integration problem
    ... CREATE ASSEMBLY does not create the assembly, it adds an existing assembly from a dll (or you can specify the actual bits!). ... You said we need to create assembly i tried it from SQL Server Management ... Server to run CLR sp, fn, trigger, aggregate. ... > already configured SQL Server Surface Area Configuration. ...
    (microsoft.public.cert.mcdba)
  • Re: Inserting into partion view - values were not supplied for all columns
    ... Wayne Snyder, MCDBA, SQL Server MVP ... "Glyn Walters" wrote in message ... > When I try to insert into a partition view with specified ... If I specify all the columns ...
    (microsoft.public.sqlserver.server)
  • Re: using Integrated Security SSPI with User ID
    ... So to specify an alternate, you need to use the RunAs utility to ... > I'm trying to use integrated security with a User Id and password to ... The SQL Server administrators insist that I ... > use the intergrated security option in the connection string, ...
    (microsoft.public.dotnet.framework.adonet)