Cambiar zona horaria bogota lima quito<\/li>\n<\/ul>\nSe puede agregar un usario sin tener la contrase\u00f1a de sa:<\/p>\n
Desde una consoloa de comandos en modo administrador<\/p>\n
C:\\Users\\Administrator>net start\r\n\r\nC:\\Users\\Administrator>net stop \"SQL Server (SQLEXPRESS)\"\r\nThe SQL Server (SQLEXPRESS) service is stopping.\r\nThe SQL Server (SQLEXPRESS) service was stopped successfully.\r\n\r\n\r\nC:\\Users\\Administrator>net start \"SQL Server (SQLEXPRESS)\" \/m\r\nThe SQL Server (SQLEXPRESS) service is starting..\r\nThe SQL Server (SQLEXPRESS) service was started successfully.\r\n\r\nC:\\Users\\Administrator>osql -S SERCESPA\\SQLEXPRESS -E\r\n\r\n1> CREATE LOGIN admin WITH PASSWORD='Cespa.2020';\r\n2> ALTER SERVER ROLE sysadmin ADD MEMBER admin;\r\n3> GO\r\n1> quit\r\n\r\nC:\\Users\\Administrator>net stop \"SQL Server (SQLEXPRESS)\"\r\nThe SQL Server (SQLEXPRESS) service is stopping.\r\nThe SQL Server (SQLEXPRESS) service was stopped successfully.\r\n\r\nC:\\Users\\Administrator>net start \"SQL Server (SQLEXPRESS)\"\r\nThe SQL Server (SQLEXPRESS) service is starting.\r\nThe SQL Server (SQLEXPRESS) service was started successfully.<\/pre>\n <\/p>\n
Una vez a\u00f1adido el usuario, es necesario habilitar los permisos del puerto. Ojo se debe habilitar la entrada y la salida en el firewall de windows.<\/p>\n
<\/p>\n
![\"\"](\"http:\/\/tunjasoporte.890m.com\/wp-content\/uploads\/2020\/10\/configuracion-de-puertos.png\")
<\/p>\n
![\"\"](\"http:\/\/tunjasoporte.890m.com\/wp-content\/uploads\/2020\/10\/puerto.png\")
<\/p>\n
Tambi\u00e9n hay que habilitar el puerto 1433 donde diga si:<\/p>\n
![\"\"](\"http:\/\/tunjasoporte.890m.com\/wp-content\/uploads\/2021\/08\/nCoZW.png\")
<\/p>\n
El pipenames tambi\u00e9n debe estar habilitado<\/p>\n
![\"\"](\"http:\/\/tunjasoporte.890m.com\/wp-content\/uploads\/2021\/08\/pipenames.png\")
<\/p>\n
![\"\"](\"http:\/\/tunjasoporte.890m.com\/wp-content\/uploads\/2020\/10\/configuracion-de-puertos2.png\")
<\/p>\n
![\"\"](\"http:\/\/tunjasoporte.890m.com\/wp-content\/uploads\/2020\/10\/tipo-de-conexion.png\")
<\/p>\n
Reiniciar el servicio<\/p>\n
![\"\"](\"http:\/\/tunjasoporte.890m.com\/wp-content\/uploads\/2020\/10\/reiniciar-servidor.png\")
<\/p>\n","protected":false},"excerpt":{"rendered":"
Configuraci\u00f3n Remota SQLSERVER Los backups de las bases de datos es mejor generarlos y crearlos desde el escritorio remoto. lo anterior porque el administrador emplea los directorios del servidor. En el servidor remoto es necesario instalar la sqlserver + su mangement Studio. Para la instalaci\u00f3n se debe agregar el framework .net , esto se hace […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-591","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/tunjasoporte.890m.com\/index.php\/wp-json\/wp\/v2\/pages\/591","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tunjasoporte.890m.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tunjasoporte.890m.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tunjasoporte.890m.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tunjasoporte.890m.com\/index.php\/wp-json\/wp\/v2\/comments?post=591"}],"version-history":[{"count":9,"href":"https:\/\/tunjasoporte.890m.com\/index.php\/wp-json\/wp\/v2\/pages\/591\/revisions"}],"predecessor-version":[{"id":639,"href":"https:\/\/tunjasoporte.890m.com\/index.php\/wp-json\/wp\/v2\/pages\/591\/revisions\/639"}],"wp:attachment":[{"href":"https:\/\/tunjasoporte.890m.com\/index.php\/wp-json\/wp\/v2\/media?parent=591"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"http:\/\/tunjasoporte.890m.com\/wp-content\/uploads\/2021\/10\/rolesandfunctions.png\")
<\/p>\n