Archive for July 16th, 2009

ASP.Net Role & Membership Providers (Under IIS7) – DOESN’T Work!

Ok well, it does, but I’ve had a very stressful afternoon at it’s merciless hands!  Just trying to get the ASP.Net roles & membership working on asp.net 3.5, using IIS7.  I created the project and clicked “ASP.Net Confguration” from the project menu, but no working providers existed.

I defined some custom providers and nothing would get picked up.

It turns out, under IIS you need to define a connection string with a specific name to make this work–

 <connectionStrings>
    <clear/>
    <add name="LocalSqlServer" connectionString="your real connection string goes here!" />
  </connectionStrings>

So we’re clearing out the default inherited connection strings then overriding the default LocalSqlServer connection to have the correct connection to our real database, as this appears to be the connection string it defaults to.

Save the web.config file, the fire up the “ASP.net configuration” site again and you should be away!

Thanks to Mr Ledger for channelling the awesome power of google through himself to yield that nugget of joy and relief!

No Comments

Collation issues setting up ASP.Net membership tables

Setup failed.

Exception:
An error occurred during the execution of the SQL file ‘InstallRoles.sql’. The SQL error number is 446 and the SqlException message is: Cannot resolve collation conflict for equal to operation.
Cannot resolve collation conflict for equal to operation.

I recently had this problem while trying to setup the roles & memberships gubbins on a database using the aspnet_regsql tool on the v2 .net framework.

This turned out to be because this was a SQL 2005 database which we had imported from a third party, produced on SQL2005.  The SQL2005 database had a collaction of SQL_Latin1_General_CP1_CI_AS while our sql 2000 box’s default collection was Latin1_General_CI_AS.

The fix was simple; having backed up our database (!) simply run this command;

Alter Database testdatabase Collate Latin1_General_CI_AS

This converted the database to the same Latin1_General_CI_AS collation as the server’s default, and allowed the aspnet_regsql to do it’s job unhindered!

remove_modeNOTE: If you’ve ran aspnet_regsql once already before correcting your collation (which i would imagine you probably did!), make sure you run it again in remove mode before running a final time in install mode, as the first time it runs it will bomb out after creating some of the tables already leaving you with tables in your database still using the old collation!

No Comments

I absolutely love these. They came at the lace wigs are good quality, and very soft. Absolutely love these extensions. I just love this hair. Hair came on time, I waited until after hair extensions uk very full, no shedding and it is been installed for 3 weeks now and yes I jus ordered 3 more bundles. Lol. I definitely recommend this company for your bundles ladies. They are soft, hair bundles on the head for human hair wigs and I would continue to recommend them. I have thinner hair so they cover and blend nicely.