{"id":441,"date":"2020-02-13T04:52:33","date_gmt":"2020-02-13T04:52:33","guid":{"rendered":"http:\/\/hawktech.us\/site\/?p=441"},"modified":"2020-02-13T04:52:35","modified_gmt":"2020-02-13T04:52:35","slug":"preparing-your-ms-sql-database-for-use-with-asp-net-membership-provider","status":"publish","type":"post","link":"https:\/\/hawktech.us\/site\/preparing-your-ms-sql-database-for-use-with-asp-net-membership-provider\/","title":{"rendered":"Preparing your MS SQL database for use with ASP.NET Membership Provider"},"content":{"rendered":"\n<p>The ASP.NET Membership provider by default, will use a SQL Express database. &nbsp;But if you want to use a database on an external SQL Database, you must prepare it.<\/p>\n\n\n\n<p>This method uses Visual Studio 2008 (.NET 3.5) but will also&nbsp;work with ASP.NET 2.0. &nbsp;It assumes you have already created a database(empty) and user name.<\/p>\n\n\n\n<p>1)Go to Start Menu&gt;Programs&gt;Microsoft Visual Studio 2008&gt;Visual Studio Tools&gt;Visual Studio 2008 Command Prompt<\/p>\n\n\n\n<p>2)You will enter the following command(with the appropriate values)<\/p>\n\n\n\n<p><strong>aspnet_regsql.exe -U U<\/strong><em><strong>serName<\/strong><\/em><strong> -S <\/strong><em><strong>ServerNameOrIp<\/strong><\/em><strong> -d <\/strong><em><strong>DatabaseName<\/strong><\/em><strong> -A m<\/strong><\/p>\n\n\n\n<p>3)Doing this creates all necessary tables and objects in your database to support the asp.net membership provider. &nbsp;<\/p>\n\n\n\n<p>4)After preparing the database, you are ready to add the connection string to you web.config.<\/p>\n\n\n\n<p>For more information on using the ASP.NET Membership Provider, see the MSDN article <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms998347.aspx\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a>. &nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The ASP.NET Membership provider by default, will use a SQL Express database. &nbsp;But if you want to use a database on an external SQL Database, you must prepare it. This method uses Visual Studio 2008 (.NET 3.5) but will also&nbsp;work with ASP.NET 2.0. &nbsp;It assumes you have already created a database(empty) and user name. 1)Go&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[95],"tags":[],"class_list":["post-441","post","type-post","status-publish","format-standard","hentry","category-web-development"],"_links":{"self":[{"href":"https:\/\/hawktech.us\/site\/wp-json\/wp\/v2\/posts\/441","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hawktech.us\/site\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hawktech.us\/site\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hawktech.us\/site\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hawktech.us\/site\/wp-json\/wp\/v2\/comments?post=441"}],"version-history":[{"count":0,"href":"https:\/\/hawktech.us\/site\/wp-json\/wp\/v2\/posts\/441\/revisions"}],"wp:attachment":[{"href":"https:\/\/hawktech.us\/site\/wp-json\/wp\/v2\/media?parent=441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hawktech.us\/site\/wp-json\/wp\/v2\/categories?post=441"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hawktech.us\/site\/wp-json\/wp\/v2\/tags?post=441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}