Page view counter

Configuring SQL To Work with Membership Schemas

Please install Silverlight or click download to watch video locally.

In this video Joe Stagner demonstrates how to configure a SQL instance to work with a specific ASP Services Membership Profile; as well as configure the application to specifically use this SQL instance and not the default settings in the machine.cgf file. For additional information about this video, read the Creating the Membership Schema in SQL Server security tutorial.

Presented by Joe Stagner

Duration: 18 minutes, 56 seconds

Date: 04 August 2008

Watch    Video   |   Download    Video   |   VB Code    C# Code

Video downloads: WMV  |  Zune  |  iPod  |  PSP  |  MPEG-4  |  3GP

Audio downloads: AAC  |  WMA  |  MPEG-4  |  MPEG-3  |  MPEG-2

Comments : 14

Leave a Comment

FelixRMelendez : On August 05, 2008 12:24 AM said:

Excellent video! :-)

cv_vikram : On August 14, 2008 7:02 AM said:

Really a good video..

pthalacker : On August 14, 2008 3:18 PM said:

Excellent video.  A really clear explanation of where the pieces need to be.

One caveat!!  I have VS2008 on my local machine and develop on another server running IIS.  We have two dedicated SQL Server boxes so SQL Server is not running on either machine.  So "LocalSQLServer" is not valid in either location. Removing the "LocalSQlServer" connection string doesn't help.  When the Web Application Administration Tool can't find what it assumes to still be the default data store, the Provider and Security tabs display errors.

If the default provider is not available it is necessary to add a defaultProvider attribute to your membership, profile and roleManager elements in the web site web.config file or the Web Application Administration Tool has no idea what to do.

pthalacker : On August 14, 2008 3:39 PM said:

And now that I have the Application Tool running without error, I am still having problems. If I put a <clear /> tags at the beginning of my providers elements, I get no providers in the tool.  If I remove the <clear/> tag, the only provider available in the tool is still AspNetSqlProvider.

Where is the tool getting the default reference from and how do I get Visual Studio to recognize my custom data provider?

I am now going back to watch the video for the 3rd time to see what I missed.

pthalacker : On August 14, 2008 5:09 PM said:

What I missed is that if the LocalSqlServer connection is not valid, you cannot just remove it. You must replace it with something that is valid so that it is available.  Also, you cannot remove the default membership and role providers unless you are going to replace them.  It appears that all the defaults must exist and have valid connections to data for the Configuration Tool security sections to function.  Even if you never use any of them.

cv_vikram : On August 15, 2008 5:31 PM said:

thanks,,,

asater : On August 29, 2008 11:50 AM said:

Hello pthalacker,

you better off posting your question on the Forums, you get a fast answer to your problem.

Thank you Joe for the video

aguslangsar : On November 17, 2008 4:40 AM said:

indonesian...

saya sangat berterima kasih banyak atas adanya video tutrial ini. sebab dengan adanya video tutorial ini dapat lebih memudahkan saya dalam mempelajari asp.net

terima kasih buat asp.net

salam

Agus Susanto

rami_nassar : On November 30, 2008 3:30 PM said:

great helpful video

Djibril_Chimere_DIAW : On March 14, 2009 4:23 PM said:

Thanks! Jërëjëf!

cheburek : On April 01, 2009 11:13 AM said:

That is I was looked for. Thank you!

Earl123 : On April 27, 2009 6:50 PM said:

Website>ASP Configuration>Create New User (Fails on all examples for me.)

Hi - I can follow along in the tutorials, but haven't been able to ever get the Create User function via to built in configuration to work. I can create Roles, but no users. (Authentication set to internet type.)

When I download the examples, everything seems to run as expected with the exception of I can't run a Create User for any of the example source codes (or when doing from scratch which creates a ASPNETDB.mdf based upon the machine.config.default).

I can only seem to be able to add users using the SQL Server Mgt Express utility.

My default user is PC Login which is listed as a Database Owner in the Master table of the SQLExpress server.

Thanks to the one who can probably guess what I'm missing.

(Thanks for the video's - I find I use both the video's and the written when trying to go deep.)

PS - MS making the Express versions available was a smart move for however should get credit for initiating.

haithemara : On May 21, 2009 11:42 PM said:

great video . Thank you.

feelingsheepish : On June 24, 2009 8:49 AM said:

excelled yourself again Joe

Leave a Comment

You must be logged in to leave a comment. Click here to log in.

Microsoft Communities