{"id":1989,"date":"2023-12-21T12:06:50","date_gmt":"2023-12-21T12:06:50","guid":{"rendered":"https:\/\/www.mainmind.com\/blog\/?p=1989"},"modified":"2023-12-21T12:19:25","modified_gmt":"2023-12-21T12:19:25","slug":"sql-server-management-studio-0x54b-error","status":"publish","type":"post","link":"https:\/\/www.mainmind.com\/blog\/sql-server-management-studio-0x54b-error\/","title":{"rendered":"TIP: SQL\u00a0Server\u00a0Management Studio\u00a00x54b error"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Al restaurar o copiar bases de datos entre diferentes versiones de SQL Server, aparece un error que no permite crear diagramas de bases de datos desde Management Studio:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nNo se pudo obtener informaci\u00f3n acerca del grupo o usuario de Windows NT\n&#039;AzureAD\\...&#039;; c\u00f3digo de error 0x54b. (Microsoft SQL Server, Error: 15404)\n<\/pre><\/div>\n\n\n<!--more-->\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"607\" height=\"131\" src=\"https:\/\/www.mainmind.com\/blog\/wp-content\/uploads\/2023\/SSMS_diagrama\/01_diagram_0x54b.jpg\" alt=\"\" class=\"wp-image-1994\" srcset=\"https:\/\/www.mainmind.com\/blog\/wp-content\/uploads\/2023\/SSMS_diagrama\/01_diagram_0x54b.jpg 607w, https:\/\/www.mainmind.com\/blog\/wp-content\/uploads\/2023\/SSMS_diagrama\/01_diagram_0x54b-300x65.jpg 300w\" sizes=\"auto, (max-width: 607px) 100vw, 607px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Debemos revisar el propietario de la base de datos, dentro de las opciones de archivos (Files):<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"698\" height=\"660\" src=\"https:\/\/www.mainmind.com\/blog\/wp-content\/uploads\/2023\/SSMS_diagrama\/02_ddbb_prop.jpg\" alt=\"\" class=\"wp-image-1991\" srcset=\"https:\/\/www.mainmind.com\/blog\/wp-content\/uploads\/2023\/SSMS_diagrama\/02_ddbb_prop.jpg 698w, https:\/\/www.mainmind.com\/blog\/wp-content\/uploads\/2023\/SSMS_diagrama\/02_ddbb_prop-300x284.jpg 300w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Cambiamos el propietario por el usuario [sa]:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"698\" height=\"660\" src=\"https:\/\/www.mainmind.com\/blog\/wp-content\/uploads\/2023\/SSMS_diagrama\/03_ddbb_prop_sa.jpg\" alt=\"\" class=\"wp-image-1992\" style=\"width:696px;height:auto\" srcset=\"https:\/\/www.mainmind.com\/blog\/wp-content\/uploads\/2023\/SSMS_diagrama\/03_ddbb_prop_sa.jpg 698w, https:\/\/www.mainmind.com\/blog\/wp-content\/uploads\/2023\/SSMS_diagrama\/03_ddbb_prop_sa-300x284.jpg 300w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">Guardamos los cambios y volvemos a crear un nuevo diagrama desde Management Studio, ya sin el error:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"607\" height=\"131\" src=\"https:\/\/www.mainmind.com\/blog\/wp-content\/uploads\/2023\/SSMS_diagrama\/04_diagram_ok.jpg\" alt=\"\" class=\"wp-image-1993\" srcset=\"https:\/\/www.mainmind.com\/blog\/wp-content\/uploads\/2023\/SSMS_diagrama\/04_diagram_ok.jpg 607w, https:\/\/www.mainmind.com\/blog\/wp-content\/uploads\/2023\/SSMS_diagrama\/04_diagram_ok-300x65.jpg 300w\" sizes=\"auto, (max-width: 607px) 100vw, 607px\" \/><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Al restaurar o copiar bases de datos entre diferentes versiones de SQL Server, aparece un error que no permite crear diagramas de bases de datos desde Management Studio:<\/p>\n","protected":false},"author":1,"featured_media":1997,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[947,178,948],"class_list":["post-1989","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bases-de-datos","tag-0x54b","tag-sql-server","tag-ssms"],"_links":{"self":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/posts\/1989","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/comments?post=1989"}],"version-history":[{"count":0,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/posts\/1989\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/media\/1997"}],"wp:attachment":[{"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/media?parent=1989"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/categories?post=1989"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.mainmind.com\/blog\/wp-json\/wp\/v2\/tags?post=1989"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}