MVC Membership - How to save my users and roles to Sql Server 2008

I'm finishing up the "ASP.NET Web API, Part 6: Authorization" comment tutorial at http://www.asp.net/web-api/videos/getting-started/authorization, however I would NOT like to connect to SqlExpress when saving the membership data.

I'd like to implement Authorization at some point in a real website project, however saving all the membership data down to a Sql Server 2008 DB.

I noticed that in Web.Config we have the following connection string by default :

So if I want to move these membership tables to Sql 2k8, I simply tried to change my data source to my local machine; however I have no luck.

I don't understand how the MVC4 "Comments" project initially created the aspnet-Comments-201221782844 DB in Sql Express, so I think I need to figure that out first.

Any ideas for me ?

Much appreciated.

Bob

Re: MVC Membership - How to save my users and roles to Sql Server 2008

This has nothing to do with MVC 4. Google "SQL Server" membership roles Aspnet_regsql.exe

There are lots of blogs/tutorials/etc on using full SQL Server in lieu of SQL Express. that's the question.

Re: MVC Membership - How to save my users and roles to Sql Server 2008

Yes, in lieu of Sql Express is the core of my question as you can see. It just happened to be in the context of an MVC 4 Tutorial, so I wasn't sure if there was any MVC4-specific features in regards to the Authorization.

Perhaps I should repost in a different topic.

Thank you for your response.

Bob

Re: MVC Membership - How to save my users and roles to Sql Server 2008

the Aspnet_regsql.exe tip was helpful, thanks.

I just continued working on my web.config to be sure stringConnections were configured properly.

Got it working now in the context of the new ASP.NET Web API tutorials, and was able to save the membership users/roles down to a Sql 2008 DB (vs. Sql Express).