{"id":20746,"date":"2025-09-05T09:34:38","date_gmt":"2025-09-05T15:34:38","guid":{"rendered":"https:\/\/sada.services\/?p=20746"},"modified":"2025-09-05T09:34:38","modified_gmt":"2025-09-05T15:34:38","slug":"sql-sever-crear-usuario-aranda","status":"publish","type":"post","link":"https:\/\/sada.services\/?p=20746","title":{"rendered":"SQL Sever: crear usuario Aranda"},"content":{"rendered":"\n<ul class=\"wp-block-list\">\n<li>Para crear un usuario ingresamos a BI-SQL-SERVER-2022-PROD<\/li>\n\n\n\n<li>con los datos<\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>Server type: Database Engine\nServer name: 10.0.3.96\\SQLBI\nAuthentication: Windows Authentication\nUser name: BI_SQL-SERVER\/Administrador<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"524\" height=\"339\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2025\/09\/Seleccion_1176.png\" alt=\"\" class=\"wp-image-20747\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2025\/09\/Seleccion_1176.png 524w, https:\/\/sada.services\/wp-content\/uploads\/2025\/09\/Seleccion_1176-300x194.png 300w\" sizes=\"(max-width: 524px) 100vw, 524px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Luego vamos a Security -> Logins-> Clic Derecho -> New Login<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"436\" height=\"263\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2025\/09\/Seleccion_1177.png\" alt=\"\" class=\"wp-image-20748\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2025\/09\/Seleccion_1177.png 436w, https:\/\/sada.services\/wp-content\/uploads\/2025\/09\/Seleccion_1177-300x181.png 300w\" sizes=\"(max-width: 436px) 100vw, 436px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>En General\n<ul class=\"wp-block-list\">\n<li>Ponemos el nombre<\/li>\n\n\n\n<li>Contrase\u00f1a<\/li>\n\n\n\n<li>Y la BD defualt<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"722\" height=\"671\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2025\/09\/Seleccion_1178.png\" alt=\"\" class=\"wp-image-20749\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2025\/09\/Seleccion_1178.png 722w, https:\/\/sada.services\/wp-content\/uploads\/2025\/09\/Seleccion_1178-300x279.png 300w\" sizes=\"(max-width: 722px) 100vw, 722px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>En server roles\n<ul class=\"wp-block-list\">\n<li>marcar public<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"704\" height=\"670\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2025\/09\/Seleccion_1179.png\" alt=\"\" class=\"wp-image-20750\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2025\/09\/Seleccion_1179.png 704w, https:\/\/sada.services\/wp-content\/uploads\/2025\/09\/Seleccion_1179-300x286.png 300w\" sizes=\"(max-width: 704px) 100vw, 704px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>En user Mapping\n<ul class=\"wp-block-list\">\n<li>Marcamos la BD<\/li>\n\n\n\n<li>y abajo le ponemos \n<ul class=\"wp-block-list\">\n<li>db_datareader: para consulta<\/li>\n\n\n\n<li>db_data_writer: edici\u00f3n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"693\" height=\"663\" src=\"https:\/\/sada.services\/wp-content\/uploads\/2025\/09\/Seleccion_1180.png\" alt=\"\" class=\"wp-image-20751\" srcset=\"https:\/\/sada.services\/wp-content\/uploads\/2025\/09\/Seleccion_1180.png 693w, https:\/\/sada.services\/wp-content\/uploads\/2025\/09\/Seleccion_1180-300x287.png 300w\" sizes=\"(max-width: 693px) 100vw, 693px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-20746","post","type-post","status-publish","format-standard","hentry","category-sin-categoria"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/20746","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20746"}],"version-history":[{"count":1,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/20746\/revisions"}],"predecessor-version":[{"id":20752,"href":"https:\/\/sada.services\/index.php?rest_route=\/wp\/v2\/posts\/20746\/revisions\/20752"}],"wp:attachment":[{"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20746"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20746"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sada.services\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}