{"id":11121,"date":"2024-02-09T10:56:16","date_gmt":"2024-02-09T16:56:16","guid":{"rendered":"https:\/\/www.bhinfo.com.mx\/cursos\/?p=11121"},"modified":"2024-02-09T10:57:25","modified_gmt":"2024-02-09T16:57:25","slug":"sql-data-access","status":"publish","type":"post","link":"https:\/\/www.bhinfo.com.mx\/cursos\/2024\/02\/09\/sql-data-access\/","title":{"rendered":"SQL, Data Access"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11122\" src=\"https:\/\/www.bhinfo.com.mx\/cursos\/wp-content\/uploads\/2024\/02\/WhatsApp-Image-2024-02-09-at-10.39.21-AM-e1707497609304.jpeg\" alt=\"\" width=\"845\" height=\"288\" srcset=\"https:\/\/www.bhinfo.com.mx\/cursos\/wp-content\/uploads\/2024\/02\/WhatsApp-Image-2024-02-09-at-10.39.21-AM-e1707497609304.jpeg 845w, https:\/\/www.bhinfo.com.mx\/cursos\/wp-content\/uploads\/2024\/02\/WhatsApp-Image-2024-02-09-at-10.39.21-AM-e1707497609304-300x102.jpeg 300w, https:\/\/www.bhinfo.com.mx\/cursos\/wp-content\/uploads\/2024\/02\/WhatsApp-Image-2024-02-09-at-10.39.21-AM-e1707497609304-768x262.jpeg 768w, https:\/\/www.bhinfo.com.mx\/cursos\/wp-content\/uploads\/2024\/02\/WhatsApp-Image-2024-02-09-at-10.39.21-AM-e1707497609304-788x269.jpeg 788w\" sizes=\"auto, (max-width: 845px) 100vw, 845px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Antes de habilitar la opcion de \u00abData Access\u00bb en el servidor de SQL, hay que revisar como esta el parametro a comfigurar<\/p>\n<pre>SELECT \r\n  name,\r\n  is_data_access_enabled \r\nFROM sys.servers;\r\n\r\nY a contimuacion habilitar la opcion\r\n\r\nEXEC sp_serveroption\r\n  @server = 'sqlserver007',\r\n  @optname = 'DATA ACCESS',\r\n  @optvalue = 'TRUE';<\/pre>\n<p>&nbsp;<\/p>\n<p>Referencia: https:\/\/database.guide\/how-to-enable-disable-data-access-in-sql-server-t-sql-examples\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Antes de habilitar la opcion de \u00abData Access\u00bb en el servidor de SQL, hay que revisar como esta el parametro a comfigurar SELECT name, is_data_access_enabled FROM sys.servers; Y a contimuacion habilitar la opcion EXEC sp_serveroption @server = &#8216;sqlserver007&#8217;, @optname = &#8216;DATA ACCESS&#8217;, @optvalue = &#8216;TRUE&#8217;; &nbsp; Referencia: https:\/\/database.guide\/how-to-enable-disable-data-access-in-sql-server-t-sql-examples\/<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-11121","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/posts\/11121","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/comments?post=11121"}],"version-history":[{"count":2,"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/posts\/11121\/revisions"}],"predecessor-version":[{"id":11124,"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/posts\/11121\/revisions\/11124"}],"wp:attachment":[{"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/media?parent=11121"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/categories?post=11121"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bhinfo.com.mx\/cursos\/wp-json\/wp\/v2\/tags?post=11121"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}