Problem with ASP.NET Membership Provider

Question

I've just deployed an ASP.NET web site to my hosting provider, but I keep getting the following error when I try and log in:

SQLExpress database file auto-creation error: The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory.

I have already set up a DB with the required schema on the host, and I can even log in through the host DB from my dev machine, but not on the hosted site itself. My provider configuration is as follows:

<connectionStrings>
  <add name="Membership" connectionString="data source=localhost;initial catalog=bkelly_aspnetdb;user id=withheld; password=withheld;" />
</connectionStrings>
<system.web>
  <membership defaultProvider="SqlMembershipProvider">
    <providers>
      <clear/>
      <add name="SqlMembershipProvider" 
           type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" 
           connectionStringName="Membership" 
...

I find nothing at site level that suggests using the App_Data DB, but surely the directive should sort out any machine level provider config?

@s_ruchit, I have updated the connection string somewhat, but if you can show me where people post their exact connection strings on the web, I'll give you some of the money I make. ;-) — ProfK
– ProfK, Commented Jun 20, 2009 at 20:42
Are you also using a roleManager, and if so, does it have the right connection string name specified? — Jacob
– Jacob, Commented Jun 20, 2009 at 21:01

mxmissile · Accepted Answer · 2009-09-23 00:05:57Z

1

Not 100% on this, but try adding

<clear/>

...before you add your connectionStrings section:

<connectionStrings>
  <clear/>
  <add name="Membership" connectionString="data source=localhost;initial catalog=bkelly_aspnetdb;user id=withheld; password=withheld;" />
</connectionStrings>

answered Sep 23, 2009 at 0:05

mxmissile

11.7k6 gold badges57 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Stuart · Accepted Answer · 2009-06-20 18:54:26Z

0

Might the problem be the disk that the file is on is compressed. This would produce the error you experienced

edited Jun 20, 2009 at 18:54

answered Jun 20, 2009 at 18:46

Stuart

12.4k6 gold badges36 silver badges32 bronze badges

2 Comments

ProfK Over a year ago

@Stuart, what file? I'm trying to connect to a SQL Server database, so the fact that any file is involved is actually the root of my problem.

Stuart Over a year ago

I'm not certain that compression is the problem, just wanted to point you in the direction, so you can investigate. But sql server, the databases contained within are files. For instance in sql express the database file is .mdf, the log file is..ldf

SztupY · Accepted Answer · 2009-06-20 20:57:55Z

0

Under mono you have to replace the "SqlMembershipProvider" text to something else (doesn't matter unless it's something else) in your config. I don't think your host is using mono, but worth a try.

answered Jun 20, 2009 at 20:57

SztupY

10.6k9 gold badges68 silver badges91 bronze badges

Collectives™ on Stack Overflow

Problem with ASP.NET Membership Provider

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related