Before start, it will save lots of time later to read the readme file first at http://www.asp.net/whidbey/readme_pdc.html.
The web based asp.net admin tool could be accessed at http://localhost/myapp/webadmin.axd
To use aspnetsqlprovider, I had to create a database called aspnetdb. Used aspnet_regsql.exe to register it.
I then used the Web Admin tool to select aspnetsqlprovider for my both Membership provider and Role provider. I was able to add users and roles to SQL server successfully.
However, when I tried to log into the web site, I got an error saying that the NT Authority/Network Service account cannot log into SQL server using integrated security. I was under impression that membership should be using ASPNET account but that was not true. I could use standard SQL security, but decided to use aspnetaccessprovider instead for the rest of the experiment with PDC bit. It is painless. The admin tool created aspnetdb.mdb file in my data folder.