{"id":9207,"date":"2022-07-26T14:07:29","date_gmt":"2022-07-26T17:07:29","guid":{"rendered":"https:\/\/www.alfagestion.com.ar\/ag\/?p=9207"},"modified":"2022-07-26T14:07:33","modified_gmt":"2022-07-26T17:07:33","slug":"error-de-conexion-no-abre-el-alfa-gestion","status":"publish","type":"post","link":"https:\/\/www.alfagestion.com.ar\/ag\/error-de-conexion-no-abre-el-alfa-gestion\/","title":{"rendered":"Error de conexi\u00f3n, no abre el Alfa Gestion"},"content":{"rendered":"\n<p>Estado de SQL 01S00<\/p>\n<p>Numero de Error -2147467259 Atributo de cadena de conexion no valido<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"252\" height=\"177\" data-attachment-id=\"9209\" data-permalink=\"https:\/\/www.alfagestion.com.ar\/ag\/error-de-conexion-no-abre-el-alfa-gestion\/image-3-19\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-3.png?fit=252%2C177&amp;ssl=1\" data-orig-size=\"252,177\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image-3\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-3.png?fit=252%2C177&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-3.png?fit=252%2C177&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-3.png?resize=252%2C177&#038;ssl=1\" alt=\"\" class=\"wp-image-9209\" srcset=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-3.png?w=252&amp;ssl=1 252w, https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-3.png?resize=150%2C105&amp;ssl=1 150w\" sizes=\"(max-width: 252px) 100vw, 252px\" data-recalc-dims=\"1\" \/><\/figure>\n\n\n\n<p>Si el error lo da en el mismo equipo donde esta instalado el motor de base de datos, puede ocurrir porque no arranco el SQL Server, que se ejecuta como un servicio de windows. Para solucionarlo siga los siguientes pasos:<\/p>\n<ol>\n<li>Desde el buscador de windows escriba SERVICIOS, como se muestra en la imagen<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"724\" height=\"680\" data-attachment-id=\"9210\" data-permalink=\"https:\/\/www.alfagestion.com.ar\/ag\/error-de-conexion-no-abre-el-alfa-gestion\/image-4-16\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-4.png?fit=724%2C680&amp;ssl=1\" data-orig-size=\"724,680\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image-4\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-4.png?fit=300%2C282&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-4.png?fit=724%2C680&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-4.png?resize=724%2C680&#038;ssl=1\" alt=\"\" class=\"wp-image-9210\" srcset=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-4.png?w=724&amp;ssl=1 724w, https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-4.png?resize=300%2C282&amp;ssl=1 300w\" sizes=\"(max-width: 724px) 100vw, 724px\" data-recalc-dims=\"1\" \/><figcaption><strong>Ejecutelo como Administrador<\/strong><\/figcaption><\/figure>\n\n\n\n<p>Cuando se abre la aplicacion de servicios, ubique el texto SQL Server, como se muestra en la siguiente imagen<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1020\" height=\"568\" data-attachment-id=\"9212\" data-permalink=\"https:\/\/www.alfagestion.com.ar\/ag\/error-de-conexion-no-abre-el-alfa-gestion\/image-6-14\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-6.png?fit=1020%2C568&amp;ssl=1\" data-orig-size=\"1020,568\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image-6\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-6.png?fit=300%2C167&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-6.png?fit=1020%2C568&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-6.png?resize=1020%2C568&#038;ssl=1\" alt=\"\" class=\"wp-image-9212\" srcset=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-6.png?w=1020&amp;ssl=1 1020w, https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-6.png?resize=300%2C167&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-6.png?resize=768%2C428&amp;ssl=1 768w, https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-6.png?resize=150%2C84&amp;ssl=1 150w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" data-recalc-dims=\"1\" \/><figcaption>Dele un clic con el boton derecho y elija INICIAR<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"703\" height=\"573\" data-attachment-id=\"9213\" data-permalink=\"https:\/\/www.alfagestion.com.ar\/ag\/error-de-conexion-no-abre-el-alfa-gestion\/image-7-11\/\" data-orig-file=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-7.png?fit=703%2C573&amp;ssl=1\" data-orig-size=\"703,573\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"image-7\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-7.png?fit=300%2C245&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-7.png?fit=703%2C573&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-7.png?resize=703%2C573&#038;ssl=1\" alt=\"\" class=\"wp-image-9213\" srcset=\"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-7.png?w=703&amp;ssl=1 703w, https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-7.png?resize=300%2C245&amp;ssl=1 300w, https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2022\/07\/image-7.png?resize=150%2C122&amp;ssl=1 150w\" sizes=\"(max-width: 703px) 100vw, 703px\" data-recalc-dims=\"1\" \/><figcaption>Tambien puede abrir las <strong>propiedades <\/strong>y verificar que este servicio este en forma <strong>automatica<\/strong>.<\/figcaption><\/figure>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Compartir:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/error-de-conexion-no-abre-el-alfa-gestion\/?share=email\" target=\"_blank\" title=\"Haz clic para enviar por correo electr\u00f3nico a un amigo\"><span>Correo electr\u00f3nico<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/error-de-conexion-no-abre-el-alfa-gestion\/\" target=\"_blank\" title=\"Haz clic para imprimir\"><span>Imprimir<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Estado de SQL 01S00 Numero de Error -2147467259 Atributo de cadena de conexion no valido Si el error lo da en el mismo equipo donde esta instalado el motor de base de datos, puede ocurrir porque no arranco el SQL &hellip; <a class=\"kt-excerpt-readmore\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/error-de-conexion-no-abre-el-alfa-gestion\/\" aria-label=\"Error de conexi\u00f3n, no abre el Alfa Gestion\">Leer m&aacute;s<\/a><\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Compartir:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/error-de-conexion-no-abre-el-alfa-gestion\/?share=email\" target=\"_blank\" title=\"Haz clic para enviar por correo electr\u00f3nico a un amigo\"><span>Correo electr\u00f3nico<\/span><\/a><\/li><li class=\"share-print\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-print sd-button share-icon\" href=\"https:\/\/www.alfagestion.com.ar\/ag\/error-de-conexion-no-abre-el-alfa-gestion\/\" target=\"_blank\" title=\"Haz clic para imprimir\"><span>Imprimir<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":5,"featured_media":4753,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","spay_email":"","footnotes":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[1],"tags":[],"class_list":["post-9207","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-faq"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.alfagestion.com.ar\/ag\/wp-content\/uploads\/2016\/10\/Question.jpg?fit=320%2C400&ssl=1","jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9eJDz-2ov","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":1710,"url":"https:\/\/www.alfagestion.com.ar\/ag\/no-puedo-acceder-a-un-servidor-sql-remoto\/","url_meta":{"origin":9207,"position":0},"title":"No puedo acceder a un servidor SQL remoto.","date":"5 diciembre 2013","format":false,"excerpt":"Si no puede acceder a un servidor SQL remoto debe tener en cuenta las siguientes opciones. Agregar al Firewall de Windows las excepciones a SQL y SQLBrowser. O deshabilitar el Firewall. Los puertos habituales son TCP 1433 SQL y UDP 1434 para el SQL Browser. En configuraci\u00f3n de superficie de\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1269,"url":"https:\/\/www.alfagestion.com.ar\/ag\/error-tieme-out-o-tiempo-de-espera-finalizado\/","url_meta":{"origin":9207,"position":1},"title":"Error Tieme Out o Tiempo de espera finalizado","date":"25 agosto 2011","format":false,"excerpt":"Abrir la tabla AUX_ERR. Identificar el c\u00f3digo del error. Para ordenar por fecha (Order by fecha = 'xx\/xx\/xxxx') En una nueva consulta ejecutar el siguiente Script. DECLARE @SQL nvarchar(4000) set @sql = 'bcp \"select sql from abuela.dbo.aux_err where id = 821\" queryout \"c:\\xx.txt\" -c -T -C ANSI' exec master..xp_cmdshell @sql\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1782,"url":"https:\/\/www.alfagestion.com.ar\/ag\/como-instalar-la-consola-administrativa-del-sql-2000-en-windows-7\/","url_meta":{"origin":9207,"position":2},"title":"Como instalar la consola administrativa del sql 2000 en Windows 7?","date":"21 febrero 2014","format":false,"excerpt":"Buscar la carpeta X86, Setup, y ejecutar Mstup.exe, luego pedr\u00e1 el archivo setup.dbg que est\u00e1 en la misma carpeta, seleccionar y eso es todo\u2026 Ver imagen\u2026 \u00a0 Otro problema que puede surgir, en el sqlserver 2000 que es muy simple de reparar solo que no mucho en explicar, asi que\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4975,"url":"https:\/\/www.alfagestion.com.ar\/ag\/4975-2\/","url_meta":{"origin":9207,"position":3},"title":"Registro de Errores en Alfa Gestion","date":"1 agosto 2017","format":false,"excerpt":"El Alfa Gesti\u00f3n registra todos los errores producidos en la base de datos al intentar grabar, para poder\u00a0analizar y recuperar\u00a0la sentencia que produjo el error. Para esto, puede abrir desde el manager la tabla aux_err, normalmente ordenar por id desc para ver los ultimos errores primeros, detectar cual es, y\u2026","rel":"","context":"En \u00abBase de Datos\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1685,"url":"https:\/\/www.alfagestion.com.ar\/ag\/sincronizacion-lista-de-precios-proveedor\/","url_meta":{"origin":9207,"position":4},"title":"Sincronizaci\u00f3n Lista de Precios Proveedor","date":"29 noviembre 2013","format":false,"excerpt":"Este instructivo detalla los pasos b\u00e1sicos para dar de alta una lista de precios de proveedor y sincronizarla con el sistema. Abrir Archivos > Interfaces > Sincronizaci\u00f3n Lista de Precios Proveedor. \u00a0 Para configurar una lista iremos a la pesta\u00f1a Configuraci\u00f3n de Listas. Puede generar autom\u00e1ticamente una lista de precios\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1661,"url":"https:\/\/www.alfagestion.com.ar\/ag\/registrar-las-librerias-del-sistema-alfa-gestion\/","url_meta":{"origin":9207,"position":5},"title":"Registrar las Librer\u00edas del Sistema ALFA Gestion","date":"18 noviembre 2013","format":false,"excerpt":"En algunos casos, la instalaci\u00f3n de otros sistemas, antivirus, etc\u2026 puede causar el reemplazo accidental de una librer\u00eda o controles utilizado por el sistema. Esto puede causar mensajes de error como \"Error de automatizaci\u00f3n\", No se puede cargar el objeto, etc\u2026 En estos casos se debe proceder de la siguiente\u2026","rel":"","context":"En \u00abAlfa Gesti\u00f3n Comercial\u00bb","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts\/9207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/comments?post=9207"}],"version-history":[{"count":2,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts\/9207\/revisions"}],"predecessor-version":[{"id":9214,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/posts\/9207\/revisions\/9214"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/media\/4753"}],"wp:attachment":[{"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/media?parent=9207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/categories?post=9207"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.alfagestion.com.ar\/ag\/wp-json\/wp\/v2\/tags?post=9207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}