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.

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.

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

Thank you Joe for the video

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

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.

If you have not yet created the SQL Server database, exit the " What can be wrong? my sql server status is started, i am using windows 7 pro.

p.s sorry, my english is`nt good

Did you find the solution? I'm stuck just like you. I'm using Sql Server management studio 2008 and I built my DB under my MACHINE NAME\SQLEXPRESS server. So under data source below should be .\SQLEXPRESS instead of .\ just like in Joe's video

<add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;DataBase=AspNetServicesDB;Uid=AspNetServicesUser;Pwd=password"/>

Why am I getting this error..:(

Could not establish a connection to the database.

Thx

Even I got the same error message but changed the connection string as

<connectionStrings>

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="data source=Hari-pc\Learning;Integrated Security=SSPI;Initial Catalog=AspNetServicesDB" providerName="System.Data.SqlClient"/>

</connectionStrings>

in Web.Config. Here by DataBase is AspNetServicesDB. Now it is working fine)-:

I following the tutorial and I am having issue with my user login. the admin tool find the database but is unable to login using the user. I created the user according to the video and add the user to the DB with owner setting. I there another setting in the DB to handle to allow the AspnetServicesUser to login?

here is my errroe message: Login failed for user 'AspNetServicesUser'

Can anyone help?

thanks

I was just porting my web application on to another machine and was pulling my hair out with the "Login failed for user 'AspNetServicesUser'" error.

I then realised something that Joe hasn't mentioned in his video.

When you install it, by default the system is set ONLY to accept Windows Authentication for its logins.

You MUST allow BOTH SQL server AND Windows authentication to get this to work.

One way to achieve this is to open the database in SSMS and then right-click on the server (".\SQLEXPRESS" in my case - it's the root in the tree-view on the left hand side).

Next look it its properties - a new popup will open.

On this popup select "Security", and then click on the radio button marked "SQL Server and Windows Authentication mode".

You have to restart the SQL service. Again, one way of doing this is right-click on the server and select "Restart".

HTH

Kelsey Thornton

Whenever i am running ASP.Net config tool i am getting this error: If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.