Page view counter

Configuring SQL To Work with Membership Schemas

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: 4 August 2008

Watch the video   |   Download the video   |   Get VB code  or  C# code

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

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

Comments : 8

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

Leave a Comment

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

Microsoft Communities