{"id":228,"date":"2010-08-30T23:16:20","date_gmt":"2010-08-30T13:16:20","guid":{"rendered":"http:\/\/jcrawfor74.wordpress.com\/?p=228"},"modified":"2010-08-30T23:16:20","modified_gmt":"2010-08-30T13:16:20","slug":"asp-net-membership-provider-install-database","status":"publish","type":"post","link":"https:\/\/ntsblog.homedev.com.au\/index.php\/2010\/08\/30\/asp-net-membership-provider-install-database\/","title":{"rendered":"ASP.Net Membership Provider &#8211; Install Database"},"content":{"rendered":"<div id=\"ntsbl-2369283914\" class=\"ntsbl-before-content ntsbl-entity-placement\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-6288941070289539\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:inline-block;width:728px;height:90px;\" \ndata-ad-client=\"ca-pub-6288941070289539\" \ndata-ad-slot=\"9356781486\"><\/ins> \n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div><p>In asp.net the membership provider model is a cool way of easily getting a security datamodel with role access. <\/p>\n<p>The database can be installed on your own specific database in the following way.<\/p>\n<p>Some architecture based sugestions:<br \/>\n1. The membership provider model is actually keyed by application. So you can provide user lists for multiple applications from a single database. This means that instead of creating the model inside you application database you can store this in a central applicaiton security database and provide a single database that manages users for all of your applications. <\/p>\n<p><strong>Pre-Requisites<\/strong><br \/>\n1. Ensure you have SQL server installed on your system. This could be SQL Server Express.<\/p>\n<p><strong>Installation<\/strong><br \/>\n1. Open a command window.<br \/>\n2. cd to the following directory  [drive:]%windir%Microsoft.NETFrameworkversion<br \/>\n3. run aspnet_regsql.exe ( by default this will run in the Wizard Mode)<\/p>\n<p>In the wizard:<br \/>\n1. Click Next<br \/>\n2. Choose &#8220;Configure sql server for application services&#8221; and click next<br \/>\n3. <strong>Select the Server and Database<\/strong> set your database connection details (note change to sqlExpress named instance)<br \/>\n4. Choose Next Next Finish<\/p>\n<p>Your database has now been created and is ready to be used.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In asp.net the membership provider model is a cool way of easily getting a security datamodel with role access. The database can be installed on [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-228","post","type-post","status-publish","format-standard","hentry","category-asp-net"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/posts\/228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/comments?post=228"}],"version-history":[{"count":0,"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/posts\/228\/revisions"}],"wp:attachment":[{"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/media?parent=228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/categories?post=228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ntsblog.homedev.com.au\/index.php\/wp-json\/wp\/v2\/tags?post=228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}