Apparently not.

When I try to connect to the security tab:

[b]The following message may help in diagnosing the problem: Unable to connect to SQL Server database.[/b]

By default, a SQL Server db is used to store membership data. Check your web.config file for the "membership" and "roleManager" attributes. You should see information about a connection string in each section. You can edit the connection string and try again.

Also, you should be able to test your connection via the "Provider" tab.

Hope this helps,

Paul

Paul is right. In this tutorial creates the empty MVC project. That's why there's no any connection strings and providers for the autorization functionality in web.config file. You must mannualy add connection strings to this file. For example like this:

<connectionStrings>

<add name="MusicStoreEntities" connectionString="Data Source=|DataDirectory|MvcMusicStore.sdf" providerName="System.Data.SqlServerCe.4.0"/>

<add name="ApplicationServices"

connectionString="data source=.\;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"

providerName="System.Data.SqlClient" />

</connectionStrings>

this adds a connection info and creates a database attach file. Note : you must specify the name of your instance of SQL Server.

And this for membership and roles:

<authentication mode="Forms">

<forms loginUrl="~/Account/LogOn" timeout="2880" />

</authentication>

<membership>

<providers>

<clear/>

<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider" connectionStringName="ApplicationServices"

enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false"

maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10"

applicationName="/" />

</providers>

</membership>

<profile>

<providers>

<clear/>

<add name="AspNetSqlProfileProvider" type="System.Web.Profile.SqlProfileProvider" connectionStringName="ApplicationServices" applicationName="/" />

</providers>

</profile>

<roleManager enabled="true">

<providers>

<clear />

<add connectionStringName="ApplicationServices" applicationName="/"

name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider" />

<add applicationName="/" name="AspNetWindowsTokenRoleProvider"

type="System.Web.Security.WindowsTokenRoleProvider" />

</providers>

</roleManager>

Hope this helps!

Does the SQL Server CE database need to have membership tables added to enable security?

<add name="DefaultConnection" connectionString="Data Source=|DataDirectory|MvcMusicStore.sdf" providerName="System.Data.SqlServerCe.4.0" />

And it works well!

First, after copying the code change the namespace and the @model [namespace].models.[class name] to the actual project name. The code in the download is named differently.

Second, create an MVC 3 Internet Project. Copy the parts of the web config that relate to the provider (roles, membership, etc) into the web config of the tutorial project. Basically, these are the lines of code missing from the project web config. Make sure that the roleManager is enabled:

<roleManager enabled="true">

Also, the tutorial assumes that you set the security question parm to true (it is false in auto gen code), so you may want to do that as well.

Next, try in the unaltered internet project to use the ASP.Net configuration tool (as suggested in the tutorial). You may have to set roleManager to true in this project as well. If you can't get it to work (either using the GUI or the aspnet_regsql utility), it is probably because you are not using SQLExpress as presumed by the auto gen code. Change your connection string to work. I use SQL Server 2008 R2 Dev Ed, and this connection string (very simple) worked for me:

<add name="ApplicationServices"

connectionString="data source=(local);Integrated Security=SSPI;database=aspnetdb"

providerName="System.Data.SqlClient" />

Then, making the connection string change in the tutorial as well if needed, try the configuration for the tutorial as it is written up. Mine worked, and you can then proceed with the tutorial. Note: if you do this all without changing the namespace in the copied code, you will get an error.

And thanks to the users for their help within the comment section.

Sincerely

Mohammad

All the above didn't work for me. I just found out that you need the website to be running to get the ASP.NET Configuration website to work.

So start the application first with F5 or the green play button, then click the ASP.NET Configuration icon on the Solution Explorer.

This way I didn't need to change anything.

You do need to change the stuff that is written about in the tutorial.

But I also needed to change the view-scripts for Account to get the login to work.

I changed Mvc3ToolsUpdateWeb_Default (after @model) to MvcMusicStore in

ChangePassword.cshtml

LogOn.cshtml

Register.cshtml

I have added Site.Master file to Account directory and now when trying to run /StoreManager it gives me mistakes:

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[HttpException (0x80004005): Cannot find ContentPlaceHolder 'MainContent' in the master page '/Views/Shared/Site.Master', verify content control's ContentPlaceHolderID attribute in the content page.]

System.Web.UI.MasterPage.CreateMaster(TemplateControl owner, HttpContext context, VirtualPath masterPageFile, IDictionary contentTemplateCollection) +8959036

System.Web.UI.Page.get_Master() +54

System.Web.UI.Page.ApplyMasterPage() +15

System.Web.UI.Page.PerformPreInit() +45

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +328

can some one give some advice

Many thanks

There doesn't seem to be a way to have the "aspnetdb" that the aspnet_regsql.exe wants to create... able to be created in SQL Server Compact 4.0???

Apparently the SQL Server Compact 4.0 isn't seen as the instancename of 'SQLEXPRESS'?

Only thing I was able to successfully enter in the aspnet_regsql.exe was my machine name of GHART-DEV which ended-up creating the aspnetdb as a database within my full-blown SQL Server 2008 R2 also running on this machine.

I tried tweaking the web.config entries related to these two so that perhaps one could just sit on my 2008 R2 server and the other the MvcMusicStore.sdf could remain as it is. This didn't want to work. Whenever I would try to invoke the ASP.NET Web Config. Tool site and select 'Security'... it would invariably come back with 'Unable to access SQL Server'.

I tried some Googled suggestion of perhaps using NuGet to grab for a cetain package which might allow ASP.NET Web Site Config tool to maybe be able to work with SqlServerCE 4.0 but this proved to make things worse.

So I carefully performed manual "surgery" in the Solution Explorer to remove the packages I installed and the BS from the demo dealing with implementing Authentication and Roles.

Got myself back to the running state it was at just before this tutorial began.

On a hunch I tried the following:

changed the connectionString setups in web.config so that the MvcMusicStore and the aspnetdb would now both be saved into/read from my SQL Server 2008 R2 server.

<connectionStrings>

<add name="ApplicationServices"

connectionString="Data Source=GHART-DEV;Initial Catalog=aspnetdb;Integrated Security=SSPI;"

providerName="System.Data.SqlClient" />

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer"

connectionString="Data Source=GHART-DEV;Initial Catalog=aspnetdb;Integrated Security=SSPI"

providerName="System.Data.SqlClient"/>

<add name="MusicStoreEntities"

connectionString="Data Source=GHART-DEV;Initial Catalog=MvcMusicStore;Integrated Security=SSPI"

providerName="System.Data.SqlClient" />

</connectionStrings>

One thing I learned here was that I had to remove the "User Instance=True" part of the connection string otherwise ASP.NET Web Config. Tool would get an error when I attempted to invoke 'Security' now that I had things "transferred over" to my SQL 2008 R2 server.

"The user instance login flag is not supported on this version of SQL Server. The connection will be closed."

Removing that part of the connection string got me in. Hella-freakin-lujah!

There are now some interesting Problems I'm having with StoreManagerController... (continued on next comment post)

In the StoreManager...

When an attempt is made to "Edit" an item... somehow when the form is getting HttpPost'd back for the Edit, the value contained in the @Html.HiddenFor(model => model.AlbumId) seems to NOT be getting passed-back! This AlbumID keeps coming back as 0 even though in debugging I could clearly see the album Entity had a value of 1 debugging the Find( ) that occurs during the HTTPGET of the Edit method. This 0 AlbumID would cause an exception that would abort the save of the edit. Desiring to move-on and learn about the Authentication and Roles tutorial I just dealt with changing that value back to a 1 in Debug in the IDE so it could continue and save back to DB.

in the Index View... the current coding seems to not be properly displaying (cutting-off) the decimal portion of the Album Price value displayed. Instead of @Html.DisplayFor(modelItem => item.Price) I tried using @Html.DisplayTextFor(modelItem => item.Price) with no improvement. What would be the right way to display the price so that it doesn't keep chopping-off the cents values?

And why did this change to having both connectionString's now use SQL server 2008 R2 seem to all of a sudden make that @Html.HiddenFor(model => model.AlbumId) start coming back as 0?

But interestingly enough... the other problem of the Album.Price field having the decimal portion of the price amount getting chopped-off apparently has something to do with SQL Server 2008 R2 itself? Or most likely something related to how I'm using it?

To test this problem I went into SSMS and made a new database and a new trimmed-down version of the Albums table which containing just Price and Title.

The 1st time I made the table I made the Price field be a decimal data type to emulate what I was dealing with in the tutorial. Right there, raw, in Query Analyzer I did an INSERT with a price value containing a decimal portion to the number (3.33).

I opened another Query Analyzer window in SSMS and then did a SELECT query to pull this record back and it only shows the whole number value of the inserted value! (3)

For sh!ts and giggles I made another table and chose the money datatype for the price field and that version seemed to accept and retain the decimal portion of the INSERT'd number just fine. Oddly enough though... I can't seem to find a C# data type that directly correlates with this "money" datatype available to me in SQL Server 2008 R2.

Can anyone shed some light as to what I might be doing wrong with this decimal data type on the SQL Server side of things?

NOTE: The MvcMusicStore database which right now exists in my SQL Server was automatically generated by the Drop and Create coding in the Initializer code in SampleData.cs so it's not even like I did anything myself to mess something up with that field definition myself.