{"id":123,"date":"2012-05-21T11:00:00","date_gmt":"2012-05-21T10:00:00","guid":{"rendered":"https:\/\/blogfvinhas.wordpress.com\/?p=123"},"modified":"2012-05-21T11:00:00","modified_gmt":"2012-05-21T10:00:00","slug":"configurar-aspnetdb-dentro-de-uma-userdb","status":"publish","type":"post","link":"https:\/\/blog.fvinhas.com\/index.php\/2012\/05\/21\/configurar-aspnetdb-dentro-de-uma-userdb\/","title":{"rendered":"Configurar ASPNETDB dentro de uma USERDB"},"content":{"rendered":"\n<p>1. Inicalmente devemos ter j\u00e1 criada uma base de dados, por exemplo userdb.mdf<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"294\" height=\"355\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-5.png?w=294\" alt=\"\" class=\"wp-image-125\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-5.png 294w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-5-248x300.png 248w\" sizes=\"auto, (max-width: 294px) 100vw, 294px\" \/><\/figure>\n\n\n\n<p>2. Em seguida verificar na seguinte localiza\u00e7\u00e3o a presen\u00e7a da framework 2.0, seja qual for a vers\u00e3o que apare\u00e7a \u00e0 frente.<\/p>\n\n\n\n<p>No meu caso a localiza\u00e7\u00e3o foi a seguinte: C:\\Windows\\Microsoft.NET\\Framework\\v2.0.50727<\/p>\n\n\n\n<p>O nome do execut\u00e1vel \u00e9: aspnet_regsql.exe<\/p>\n\n\n\n<p>Ao executar este execut\u00e1vel ir\u00e1 aparecer a seguinte janela:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"594\" height=\"459\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-6.png?w=594\" alt=\"\" class=\"wp-image-126\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-6.png 594w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-6-300x232.png 300w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><\/figure>\n\n\n\n<p>Seguir os passos, clicando em \u201cNext\u201d<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"597\" height=\"462\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-7.png?w=597\" alt=\"\" class=\"wp-image-127\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-7.png 597w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-7-300x232.png 300w\" sizes=\"auto, (max-width: 597px) 100vw, 597px\" \/><\/figure>\n\n\n\n<p>Nesta op\u00e7\u00e3o indicamos que pretendemos os profiles, roles na base de dados escolhida.<\/p>\n\n\n\n<p>Introduzimos onde indica Server a nossa instancia de SQL, poder\u00e1 ser por exemplo \\SQLEXPRESS, no meu caso \u00e9 \\SQLEXPRESS08, onde s\u00f3 ap\u00f3s essa indica\u00e7\u00e3o \u00e9 que s\u00f5 disponibilizadas as bases de dados que constam nessa instancia. Devr\u00e1 ser indicada a password de autentica\u00e7\u00e3o, caso tenha sido introduzida, na maioria das vezes basta colocar como windows authentication.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"595\" height=\"458\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-8.png?w=595\" alt=\"\" class=\"wp-image-128\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-8.png 595w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-8-300x231.png 300w\" sizes=\"auto, (max-width: 595px) 100vw, 595px\" \/><\/figure>\n\n\n\n<p>Seleccionamos a base de dados onde pretendemos as tabelas correspondentes a ASPNETDB e \u201cNext\u201d<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"593\" height=\"460\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-9.png?w=593\" alt=\"\" class=\"wp-image-130\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-9.png 593w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-9-300x233.png 300w\" sizes=\"auto, (max-width: 593px) 100vw, 593px\" \/><\/figure>\n\n\n\n<p>Correndo tudo bem, j\u00e1 dever\u00e1 estar concluida a opera\u00e7\u00e3o de carregamento das tabelas, e passando a ser a base de dados de gest\u00e3o de utilizadores da sua aplica\u00e7\u00e3o. Clique em \u201cFinish\u201d.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"594\" height=\"464\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-10.png?w=594\" alt=\"\" class=\"wp-image-131\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-10.png 594w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-10-300x234.png 300w\" sizes=\"auto, (max-width: 594px) 100vw, 594px\" \/><\/figure>\n\n\n\n<p>Podem confirmar a cria\u00e7\u00e3o das tabelas, fazendo um refresh a base de dados, onde j\u00e1 constam as tabelas solicitadas:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"354\" height=\"547\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-11.png?w=354\" alt=\"\" class=\"wp-image-132\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-11.png 354w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-11-194x300.png 194w\" sizes=\"auto, (max-width: 354px) 100vw, 354px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. Inicalmente devemos ter j\u00e1 criada uma base de dados, por exemplo userdb.mdf 2. Em seguida verificar na seguinte localiza\u00e7\u00e3o a presen\u00e7a da framework 2.0, seja qual for a vers\u00e3o que apare\u00e7a \u00e0 frente. No meu caso a localiza\u00e7\u00e3o foi a seguinte: C:\\Windows\\Microsoft.NET\\Framework\\v2.0.50727 O nome do execut\u00e1vel \u00e9: aspnet_regsql.exe Ao executar este execut\u00e1vel ir\u00e1 aparecer &#8230; <a title=\"Configurar ASPNETDB dentro de uma USERDB\" class=\"read-more\" href=\"https:\/\/blog.fvinhas.com\/index.php\/2012\/05\/21\/configurar-aspnetdb-dentro-de-uma-userdb\/\" aria-label=\"Read more about Configurar ASPNETDB dentro de uma USERDB\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[13,27,39,56,77,86,92,108],"class_list":["post-123","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-aspnetdb","tag-configurar","tag-excel","tag-microsoft-excel","tag-roteador","tag-sql","tag-userdb","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/posts\/123","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/comments?post=123"}],"version-history":[{"count":0,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/posts\/123\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/media?parent=123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/categories?post=123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/tags?post=123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}