{"id":7,"date":"2014-07-18T11:51:44","date_gmt":"2014-07-18T11:51:44","guid":{"rendered":"http:\/\/blog.antarias.com\/?p=7"},"modified":"2014-08-14T14:57:21","modified_gmt":"2014-08-14T12:57:21","slug":"ejecutando-access-apps-en-sharepoint-2013","status":"publish","type":"post","link":"https:\/\/blog.antarias.com\/?p=7","title":{"rendered":"Ejecutando Access Apps en SharePoint 2013"},"content":{"rendered":"

Las aplicaciones Access para SharePoint me han parecido una herramienta que puede resultar muy \u00fatil para crear r\u00e1pidamente aplicaciones empresariales, aquellas que b\u00e1sicamente consisten en un interfaz para una serie de tablas SQL relacionadas.<\/p>\n

No obstante, la instalaci\u00f3n necesaria para tenerlas funcionando en una instalaci\u00f3n local, dista de ser trivial. Aunque existen varias gu\u00edas online, tras el primer intento me he encontrado con varias dificultades, siendo lo m\u00e1s frustante errores con las fechas tras probar las demos inclu\u00eddas, que sospecho que est\u00e1n provocadas por emplear la instalaci\u00f3n por defecto de SQL Server 2012 en espa\u00f1ol.<\/p>\n

Por ello, recojo a continuaci\u00f3n algunas ideas y tutoriales con informaci\u00f3n sobre la instalaci\u00f3n<\/p>\n

SQL Server 2012<\/strong><\/p>\n

Es importante que la collation elegida al instalar SQL Server 2012 sea Latin1_General_CI_AS_KS_WS<\/strong> , tal como recomeinda Microsoft en http:\/\/support.microsoft.com\/kb\/2008668\/en-us <\/a><\/p>\n

Para seleccionar, en el instalador de SQL SErver deberemos seleccionarla as\u00ed:<\/p>\n

\"Inst<\/a><\/p>\n

Adem\u00e1s, el idioma predeterminado<\/strong> debe ser ‘English’.<\/p>\n

Gu\u00eda parar instalar SQL Server 2012 para usar con SharePoint 2013: http:\/\/www.sharepointdoug.com\/2013\/02\/instruction-guide-for-installing-sql.html<\/a><\/p>\n

Recomendaciones sobre Cuentas de Usuario para instalar SharePoint 2013<\/strong><\/p>\n

Una buena gu\u00eda, con tres niveles de seguridad: http:\/\/absolute-sharepoint.com\/2013\/01\/sharepoint-2013-service-accounts-best-practices-explained.html<\/a><\/p>\n

Otra gu\u00eda, de MS: http:\/\/social.technet.microsoft.com\/wiki\/contents\/articles\/14500.sharepoint-2013-service-accounts.aspx<\/a><\/p>\n

Instalaci\u00f3n de Access Apps para 2013<\/strong><\/p>\n

Primero necesitamos configurar un \u00abentorno para aplicaciones de SharePoint\u00bb, tal como se explica en http:\/\/technet.microsoft.com\/es-es\/library\/fp161236%28office.15%29.aspx<\/a><\/p>\n

Una de las mejores gu\u00edas de instalaci\u00f3n de Access App 2013 que he encontrado: http:\/\/blogs.msdn.com\/b\/kaevans\/archive\/2013\/07\/14\/access-services-2013-setup-for-an-on-premises-installation.aspx<\/a><\/p>\n

La gu\u00eda de Microsoft: http:\/\/www.microsoft.com\/es-es\/download\/details.aspx?id=30445<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Las aplicaciones Access para SharePoint me han parecido una herramienta que puede resultar muy \u00fatil para crear r\u00e1pidamente aplicaciones empresariales, aquellas que b\u00e1sicamente consisten en un interfaz para una serie de tablas SQL relacionadas. No obstante, la instalaci\u00f3n necesaria para tenerlas funcionando en una instalaci\u00f3n local, dista de ser trivial. Aunque existen varias gu\u00edas online, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","ocean_post_oembed":"","ocean_post_self_hosted_media":"","ocean_post_video_embed":"","ocean_link_format":"","ocean_link_format_target":"self","ocean_quote_format":"","ocean_quote_format_link":"post","ocean_gallery_link_images":"on","ocean_gallery_id":[],"footnotes":""},"categories":[1],"tags":[2,3],"class_list":["post-7","post","type-post","status-publish","format-standard","hentry","category-sin-categoria","tag-sharepoint","tag-sql-server","entry"],"_links":{"self":[{"href":"https:\/\/blog.antarias.com\/index.php?rest_route=\/wp\/v2\/posts\/7","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.antarias.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.antarias.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.antarias.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.antarias.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7"}],"version-history":[{"count":9,"href":"https:\/\/blog.antarias.com\/index.php?rest_route=\/wp\/v2\/posts\/7\/revisions"}],"predecessor-version":[{"id":36,"href":"https:\/\/blog.antarias.com\/index.php?rest_route=\/wp\/v2\/posts\/7\/revisions\/36"}],"wp:attachment":[{"href":"https:\/\/blog.antarias.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.antarias.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.antarias.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}