{"id":6630,"date":"2018-03-22T17:05:52","date_gmt":"2018-03-22T20:05:52","guid":{"rendered":"https:\/\/www.kinghost.com.br\/wiki\/?post_type=article&#038;p=6630"},"modified":"2025-08-28T17:49:59","modified_gmt":"2025-08-28T20:49:59","slug":"acessar-sql-server-pelo-dbeaver","status":"publish","type":"article","link":"https:\/\/king.host\/wiki\/artigo\/acessar-sql-server-pelo-dbeaver\/","title":{"rendered":"DBeaver: Como acessar um banco SQL Server"},"content":{"rendered":"\n<p>O DBeaver \u00e9 um programa multiplataforma, que tem por objetivo conectar e manipular v\u00e1rios tipos de banco de dados. Veja nesse artigo mais detalhes.<\/p>\n\n\n\n<p><strong><em>Quer ouvir o conte\u00fado completo? \u00c9 s\u00f3 dar o play abaixo!<\/em><\/strong><\/p>\n\n\n<p><iframe loading=\"lazy\" style=\"height: 83px !important;\" title=\"Narra\u00e7\u00e3o humana do artigo\" data-src=\"https:\/\/go.vooozer.com\/embed\/ff9b0a46\" width=\"100%\" height=\"83\" frameborder=\"0\" scrolling=\"no\" allowfullscreen=\"allowfullscreen\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" class=\"lazyload\" data-load-mode=\"1\"><\/iframe><\/p>\n\n\n<p>Voc\u00ea pode utilizar o DBeaver tanto em Windows quanto em Linux e macOS. Com ele voc\u00ea consegue acessar bancos MySQL, Postgre, Firebird, SQL Server (MSSQL) entre outros.<\/p>\n\n\n\n<p>Fa\u00e7a o <a href=\"http:\/\/dbeaver.jkiss.org\/download\/\" rel=\"noopener noreferrer\" target=\"_blank\">download<\/a> e instala\u00e7\u00e3o em sua m\u00e1quina para poder iniciar.<\/p>\n\n\n\n<p>O aplicativo padr\u00e3o para conex\u00f5es \u00e0 bases de dados do SQL server \u00e9 o Management Studio da Microsoft. O problema \u00e9 que ele somente funciona em sistema Windows. Com o DBeaver voc\u00ea consegue conectar uma base SQL Server atrav\u00e9s de um Linux Ubuntu, por exemplo.<\/p>\n\n\n\n<p><box-info><strong>Para este tutorial voc\u00ea pode precisar de um apoio adicional, confira<\/strong>:<br><br>Para verificar os dados de acesso ao banco de dados, acesse: <a href=\"https:\/\/www.kinghost.com.br\/wiki\/artigo\/verificar-dados-de-acesso-do-seu-banco-de-dados\/\" target=\"_blank\" rel=\"noopener noreferrer\">Credenciais de acesso \u00e0 base de dados<\/a>.<br><br>Para alterar a senha de um base dados, veja: <a href=\"https:\/\/www.kinghost.com.br\/wiki\/artigo\/alterar-senha-de-uma-base-de-dados\/\" target=\"_blank\" rel=\"noopener noreferrer\">Alterar a senha de um banco de dados<\/a><br><br><small>Mais artigos sobre SQL Server: <a href=\"https:\/\/www.kinghost.com.br\/wiki\/base-de-conhecimento\/mssql\/\" target=\"_blank\" rel=\"noopener noreferrer\">Central de Ajuda &gt; SQL Server<\/a><\/small><\/box-info><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/king.host\/?utm_source=wiki&amp;utm_medium=banner-artigo&amp;utm_campaign=banner-artigo-wiki-awareness-acessar-sql-server-pelo-dbeaver\" target=\"_blank\" rel=\"noreferrer noopener\"><img data-original=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2015\/07\/banner_2.png\" alt=\"banner-kinghost\" class=\"wp-image-25433\"\/><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Conectando um banco SQL Server com o DBeaver<\/h2>\n\n\n\n<p>Abra o aplicativo em seu computador. Nos menus, clique em <strong>Database<\/strong> e posteriormente em <strong>New Connection<\/strong>.<br>\n<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2017\/06\/dbeaver1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"920\" height=\"436\" data-src=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2017\/06\/dbeaver1.png\" alt=\"DBeaver\" class=\"wp-image-6619 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2017\/06\/dbeaver1.png 920w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2017\/06\/dbeaver1-300x142.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2017\/06\/dbeaver1-768x364.png 768w\" data-sizes=\"(max-width: 920px) 100vw, 920px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 920px; --smush-placeholder-aspect-ratio: 920\/436;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"920\" height=\"436\" src=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2017\/06\/dbeaver1.png\" alt=\"DBeaver\" class=\"wp-image-6619\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2017\/06\/dbeaver1.png 920w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2017\/06\/dbeaver1-300x142.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2017\/06\/dbeaver1-768x364.png 768w\" sizes=\"(max-width: 920px) 100vw, 920px\" \/><\/noscript><\/a><figcaption class=\"wp-element-caption\">DBeaver &#8211; Iniciar conex\u00e3o com uma base de dados<\/figcaption><\/figure><\/div>\n\n\n<p>Dentre as conex\u00f5es dispon\u00edveis, escolha <strong>MS SQL Server<\/strong>.<br>\nNela, voc\u00ea deve selecionar a op\u00e7\u00e3o <strong>Microsoft Driver<\/strong>. Clique no bot\u00e3o <btn-plano-secondary>Next<\/btn-plano-secondary>.<br>\n<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql01.png\"><img loading=\"lazy\" decoding=\"async\" width=\"666\" height=\"705\" data-src=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql01.png\" alt=\"\" class=\"wp-image-6636 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql01.png 666w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql01-283x300.png 283w\" data-sizes=\"(max-width: 666px) 100vw, 666px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 666px; --smush-placeholder-aspect-ratio: 666\/705;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"666\" height=\"705\" src=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql01.png\" alt=\"\" class=\"wp-image-6636\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql01.png 666w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql01-283x300.png 283w\" sizes=\"(max-width: 666px) 100vw, 666px\" \/><\/noscript><\/a><figcaption class=\"wp-element-caption\">selecione a op\u00e7ao Microsoft Driver<\/figcaption><\/figure><\/div>\n\n\n<p>Na pr\u00f3xima tela adicione as credenciais de acesso conforme os dados do seu dom\u00ednio.<br>\n<small>Para saber mais sobre os dados, acesse: <a href=\"https:\/\/www.kinghost.com.br\/wiki\/artigo\/verificar-dados-de-acesso-do-seu-banco-de-dados\/\" rel=\"noopener noreferrer\" target=\"_blank\">Credenciais de acesso \u00e0 base de dados<\/a>.<\/small><br>\n<box-info><strong>Host<\/strong>: host de conex\u00e3o ao banco (Exemplo: mssql.seusite.com.br)<br>\n<strong>Database\/Schema<\/strong>: nome da base de dados (Exemplo: seusite1)<br>\n<strong>User name<\/strong>: nome do usu\u00e1rio da base de dados (\u00e9 o mesmo que o nome da base)<br>\n<strong>Password<\/strong>: a senha que voc\u00ea definiu para a base de dados<\/box-info><br>\n<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql02.png\"><img loading=\"lazy\" decoding=\"async\" width=\"669\" height=\"707\" data-src=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql02.png\" alt=\"\" class=\"wp-image-6638 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql02.png 669w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql02-284x300.png 284w\" data-sizes=\"(max-width: 669px) 100vw, 669px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 669px; --smush-placeholder-aspect-ratio: 669\/707;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"669\" height=\"707\" src=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql02.png\" alt=\"\" class=\"wp-image-6638\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql02.png 669w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql02-284x300.png 284w\" sizes=\"(max-width: 669px) 100vw, 669px\" \/><\/noscript><\/a><figcaption class=\"wp-element-caption\">Insira os dados de acesso ao seu banco SQL Server<\/figcaption><\/figure><\/div>\n\n\n<p>Depois de inserir os dados, clique no bot\u00e3o <btn-plano-secondary>Test Connection&#8230;<\/btn-plano-secondary>.<br>\nSe surgiu uma tela para fazer a instala\u00e7\u00e3o de drivers, fa\u00e7a. O processo leva segundos e garantir\u00e1 a conex\u00e3o com o servidor. Para instalar, basta clicar no bot\u00e3o <btn-plano-secondary>Download<\/btn-plano-secondary>, o resto \u00e9 feito pelo aplicativo.<br>\n<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql03.png\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"555\" data-src=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql03.png\" alt=\"\" class=\"wp-image-6640 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql03.png 624w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql03-300x267.png 300w\" data-sizes=\"(max-width: 624px) 100vw, 624px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 624px; --smush-placeholder-aspect-ratio: 624\/555;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"555\" src=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql03.png\" alt=\"\" class=\"wp-image-6640\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql03.png 624w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql03-300x267.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/noscript><\/a><figcaption class=\"wp-element-caption\">Instala\u00e7\u00e3o dos drivers de conex\u00e3o ao MS SQL Server<\/figcaption><\/figure><\/div>\n\n\n<p>Assim que instalado os drivers, ou se voc\u00ea j\u00e1 havia os instalado, ser\u00e1 mostrado se houve sucesso ou n\u00e3o na conex\u00e3o. Se houver erros, confira os dados inseridos. <br><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql04.png\"><img loading=\"lazy\" decoding=\"async\" width=\"623\" height=\"204\" data-src=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql04.png\" alt=\"\" class=\"wp-image-6641 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql04.png 623w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql04-300x98.png 300w\" data-sizes=\"(max-width: 623px) 100vw, 623px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 623px; --smush-placeholder-aspect-ratio: 623\/204;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"623\" height=\"204\" src=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql04.png\" alt=\"\" class=\"wp-image-6641\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql04.png 623w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql04-300x98.png 300w\" sizes=\"(max-width: 623px) 100vw, 623px\" \/><\/noscript><\/a><figcaption class=\"wp-element-caption\">Sucesso na conex\u00e3o com a base SQL Server<\/figcaption><\/figure><\/div>\n\n\n<p>Clique em <btn-plano-secondary>Next<\/btn-plano-secondary> nas pr\u00f3ximas telas e por fim em <btn-plano-secondary>Finish<\/btn-plano-secondary>.<br>\nA conex\u00e3o estar\u00e1 dispon\u00edvel \u00e0 esquerda da tela do programa, basta clicar para verificar a estrutura e dados do banco de dados.<br>\n<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><a href=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql05.png\"><img loading=\"lazy\" decoding=\"async\" width=\"1435\" height=\"806\" data-src=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql05.png\" alt=\"\" class=\"wp-image-6643 lazyload\" data-srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql05.png 1435w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql05-300x169.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql05-768x431.png 768w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql05-960x539.png 960w\" data-sizes=\"(max-width: 1435px) 100vw, 1435px\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" style=\"--smush-placeholder-width: 1435px; --smush-placeholder-aspect-ratio: 1435\/806;\" \/><noscript><img loading=\"lazy\" decoding=\"async\" width=\"1435\" height=\"806\" src=\"https:\/\/www.kinghost.com.br\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql05.png\" alt=\"\" class=\"wp-image-6643\" srcset=\"https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql05.png 1435w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql05-300x169.png 300w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql05-768x431.png 768w, https:\/\/king.host\/wiki\/wp-content\/uploads\/2018\/03\/dbeaver-sql05-960x539.png 960w\" sizes=\"(max-width: 1435px) 100vw, 1435px\" \/><\/noscript><\/a><figcaption class=\"wp-element-caption\">DBeaver &#8211; Gerenciamento do banco de dados SQL Server<\/figcaption><\/figure><\/div>\n\n\n<p>Pronto! Agora voc\u00ea pode manipular os dados do seu banco de dados SQL Server.<\/p>\n","protected":false},"author":9,"featured_media":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","article-category":[11],"article-tag":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/6630"}],"collection":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/types\/article"}],"author":[{"embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/comments?post=6630"}],"version-history":[{"count":17,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/6630\/revisions"}],"predecessor-version":[{"id":27002,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article\/6630\/revisions\/27002"}],"wp:attachment":[{"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/media?parent=6630"}],"wp:term":[{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article-category?post=6630"},{"taxonomy":"article-tag","embeddable":true,"href":"https:\/\/king.host\/wiki\/wp-json\/wp\/v2\/article-tag?post=6630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}