{"id":140,"date":"2012-08-04T08:52:00","date_gmt":"2012-08-04T07:52:00","guid":{"rendered":"https:\/\/blogfvinhas.wordpress.com\/?p=140"},"modified":"2012-08-04T08:52:00","modified_gmt":"2012-08-04T07:52:00","slug":"configurar-asp-net-configuration-userdb","status":"publish","type":"post","link":"https:\/\/blog.fvinhas.com\/index.php\/2012\/08\/04\/configurar-asp-net-configuration-userdb\/","title":{"rendered":"Configurar ASP.NET Configuration\u2013UserDB"},"content":{"rendered":"\n<p>Ora bem no passado dia 21 Maio coloquei um post onde dava indica\u00e7\u00f5es como se colocava a base de dados dos ASP.NET dentro de uma base de dados feita por n\u00f3s, no entanto n\u00e3o conclui a configura\u00e7\u00e3o no lado do Visual Studio.<\/p>\n\n\n\n<p>Quando vamos para o visual studio, o mesmo n\u00e3o sabe que dever\u00e1 iniciar com uma base de dados nossa e poder\u00e1 criar uma nova aspnetdb na vossa solu\u00e7\u00e3o.<\/p>\n\n\n\n<p>Se verificarem no vosso IIS o \u201cLocalSqlServer\u201d est\u00e1 a apontar para algum lado certo?<\/p>\n\n\n\n<p>Na nossa solu\u00e7\u00e3o podemos alterar esse LocalSqlServer no arranque da nossa aplica\u00e7\u00e3o, para isso dever\u00e1 ser colocado dentro do nosso ficheiro web config o seguinte c\u00f3digo<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>&lt;remove name=\u201dLocalSqlServer\u201d\/&gt;<\/p>\n\n\n\n<p>&lt;add name=\u201dLocalSqlServer\u201d connectionString=\u201dData Souce= .\\Nome_Instancia_Sql; Integrated Security=True; Initial Catalog= NomeUserDB; User Id= LoginSqlServer; Password= PassLoginSql; Trusted_Connection=False\u201d\/&gt;<\/p>\n<\/blockquote>\n\n\n\n<p>Imagem Exemplo:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"105\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-13.png?w=1024\" alt=\"\" class=\"wp-image-141\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-13.png 1024w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-13-300x31.png 300w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-13-768x79.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Quando iniciamos o Asp.net Configuration Tool<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"369\" height=\"305\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-14.png?w=369\" alt=\"\" class=\"wp-image-143\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-14.png 369w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-14-300x248.png 300w\" sizes=\"auto, (max-width: 369px) 100vw, 369px\" \/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Se existirem Utilizadores j\u00e1 criados nessa base de dados (podemos estar a importar para outro pc as configura\u00e7\u00f5es) temos que indicar o tipo de autentica\u00e7\u00e3o se localmente ou na internet. (O quadro \u00e9 ligeiramente diferente deste, pois nao aparecem nenhuns utilizadores ou roles ainda.<\/p>\n<\/blockquote>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"739\" height=\"605\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-15.png?w=739\" alt=\"\" class=\"wp-image-144\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-15.png 739w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-15-300x246.png 300w\" sizes=\"auto, (max-width: 739px) 100vw, 739px\" \/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>Selecionamos o tipo de autentica\u00e7\u00e3o, no meu caso internet e \u201cDone\u201d.<\/p>\n<\/blockquote>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"539\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-16.png?w=1024\" alt=\"\" class=\"wp-image-145\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-16.png 1024w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-16-300x158.png 300w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-16-768x404.png 768w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Logo ap\u00f3s guardar defini\u00e7\u00f5es ficam dispon\u00edveis os utilizadores e tudo que estaria criado.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"962\" height=\"730\" src=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-17.png?w=962\" alt=\"\" class=\"wp-image-146\" srcset=\"https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-17.png 962w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-17-300x228.png 300w, https:\/\/blog.fvinhas.com\/wp-content\/uploads\/2024\/12\/image-17-768x583.png 768w\" sizes=\"auto, (max-width: 962px) 100vw, 962px\" \/><\/figure>\n\n\n\n<p>Qualquer duvida poder\u00e3o sempre enviar um email.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ora bem no passado dia 21 Maio coloquei um post onde dava indica\u00e7\u00f5es como se colocava a base de dados dos ASP.NET dentro de uma base de dados feita por n\u00f3s, no entanto n\u00e3o conclui a configura\u00e7\u00e3o no lado do Visual Studio. Quando vamos para o visual studio, o mesmo n\u00e3o sabe que dever\u00e1 iniciar &#8230; <a title=\"Configurar ASP.NET Configuration\u2013UserDB\" class=\"read-more\" href=\"https:\/\/blog.fvinhas.com\/index.php\/2012\/08\/04\/configurar-asp-net-configuration-userdb\/\" aria-label=\"Read more about Configurar ASP.NET Configuration\u2013UserDB\">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":[12,15,18,27,32,53,66,92,97],"class_list":["post-140","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-asp-net","tag-autoconhecimento","tag-bem-estar","tag-configurar","tag-desenvolvimento-pessoal","tag-localsqlserver","tag-portugues","tag-userdb","tag-viagem"],"_links":{"self":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/posts\/140","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=140"}],"version-history":[{"count":0,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/posts\/140\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/media?parent=140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/categories?post=140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.fvinhas.com\/index.php\/wp-json\/wp\/v2\/tags?post=140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}