{"id":3360,"date":"2019-03-25T17:43:55","date_gmt":"2019-03-25T20:43:55","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/sql-server-express-2005-tutorial-installation-and-settings\/"},"modified":"2019-07-05T16:15:06","modified_gmt":"2019-07-05T19:15:06","slug":"sql-server-express-2005-tutorial-installation-and-settings","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/","title":{"rendered":"SQL Server Express 2005 Tutorial: installation and settings."},"content":{"rendered":"<div align=\"justify\">\n<p>This article illustrates how to install and set up the <b>SQL Server Express 2005<\/b>, free version of Microsoft&#8217;s database, and use it as E3&#8217;s database.<\/p>\n<p>The installer can be downloaded <a href=\"http:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server-editions\/sql-server-express.aspx#fbid=oMdzkUav62v\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>.<\/p>\n<p><u><b>Installing the Server<\/b><\/u><\/p>\n<p>To install the Server, follow the procedures illustrated in the figures below:<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID2405\/SQL.bmp\" alt=\"\" width=\"486\" height=\"449\" align=\"Baseline\" border=\"0\" \/><\/div>\n<p>&nbsp;<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID2405\/SQL%20(1).bmp\" alt=\"\" width=\"486\" height=\"449\" align=\"Baseline\" border=\"0\" \/><\/div>\n<p>&nbsp;<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID2405\/SQL%20(2).bmp\" alt=\"\" width=\"486\" height=\"449\" align=\"Baseline\" border=\"0\" \/><\/div>\n<p>&nbsp;<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID2405\/SQL%20(3).bmp\" alt=\"\" width=\"486\" height=\"449\" align=\"Baseline\" border=\"0\" \/><\/p>\n<\/div>\n<p>The next step is the most important in the installation: select <b>Mixed Mode (Windows Authentication and SQL Server Authentication)<\/b> option; right below, set up a password for &#8220;sa&#8221;, the default admin user.<\/p>\n<p>This password will be used to connect to E3, as seen later in this article.<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID2405\/SQL%20(4).bmp\" alt=\"\" width=\"486\" height=\"449\" align=\"Baseline\" border=\"0\" \/><\/p>\n<\/div>\n<p>On the next screens, proceed as follows:<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID2405\/SQL%20(5).bmp\" alt=\"\" width=\"486\" height=\"449\" align=\"Baseline\" border=\"0\" \/><\/div>\n<p>&nbsp;<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID2405\/SQL%20(6).bmp\" alt=\"\" width=\"486\" height=\"449\" align=\"Baseline\" border=\"0\" \/><\/div>\n<p>&nbsp;<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID2405\/SQL%20(7).bmp\" alt=\"\" width=\"486\" height=\"449\" align=\"Baseline\" border=\"0\" \/><\/div>\n<p>&nbsp;<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID2405\/SQL%20(8).bmp\" alt=\"\" width=\"486\" height=\"449\" align=\"Baseline\" border=\"0\" \/><\/p>\n<\/div>\n<p>Once the installation is completed, the next step is to install the <b>Management Studio Express<\/b>, which enables creating databases.<\/p>\n<p>When installing it, just click <b>Next <\/b>on all screens. No new settings are required.<\/p>\n<p><u><b>Creating the Database<\/b><\/u><\/p>\n<p>To create the database, you will need to open the <b>Management Studio<\/b> and connect it to the Server. To do so, use the password you have set up when installing the Server:<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID2405\/SQL%20(9).bmp\" alt=\"\" width=\"416\" height=\"315\" align=\"Baseline\" border=\"0\" \/><\/p>\n<\/div>\n<p>Then, right-click <b>Databases<\/b>, and select <b>New Database&#8230;<\/b>:<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID2405\/FiguraReduzida1.png\" alt=\"\" width=\"500\" height=\"309\" align=\"Baseline\" border=\"0\" \/><\/div>\n<p>Choose a name for your database. The .mdf file path can be changed at <b>Path <\/b>column, as seen below:<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID2405\/FiguraReduzida2.png\" alt=\"\" width=\"500\" height=\"449\" align=\"Baseline\" border=\"0\" \/><\/div>\n<p>Now the database is ready to be used. Open E3 Studio, add a <b>Database1 <\/b>object, and set its properties up:<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5050\/Properties.png\" alt=\"\" width=\"466\" height=\"528\" align=\"Baseline\" border=\"0\" \/><\/p>\n<\/div>\n<p>Click <b>Test Connection<\/b>. If all is correctly set up, the following message will be displayed:<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5050\/Connection.png\" alt=\"\" width=\"380\" height=\"162\" align=\"Baseline\" border=\"0\" \/><\/div>\n<p>Some errors may occur in this step. In case it happens, review your user and authentication settings. Most of them can be altered in the Management Studio, with no need to reinstall the software.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This article illustrates how to install and set up the SQL Server Express 2005, free version of Microsoft&#8217;s database, and use it as E3&#8217;s database. The installer can be downloaded&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[735],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server Express 2005 Tutorial: installation and settings. - Elipse Knowledgebase<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server Express 2005 Tutorial: installation and settings.\" \/>\n<meta property=\"og:description\" content=\"This article illustrates how to install and set up the SQL Server Express 2005, free version of Microsoft&#8217;s database, and use it as E3&#8217;s database. The installer can be downloaded&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:43:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-05T19:15:06+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID2405\/SQL.bmp\" \/>\n<meta name=\"author\" content=\"Elipse Software\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elipse Software\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"SQL Server Express 2005 Tutorial: installation and settings.\",\"datePublished\":\"2019-03-25T20:43:55+00:00\",\"dateModified\":\"2019-07-05T19:15:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/\"},\"wordCount\":278,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"DataBases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/\",\"name\":\"[:pt]SQL Server Express 2005 Tutorial: installation and settings.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:43:55+00:00\",\"dateModified\":\"2019-07-05T19:15:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server Express 2005 Tutorial: installation and settings.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\",\"name\":\"Elipse Software\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"caption\":\"Elipse Software\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server Express 2005 Tutorial: installation and settings. - Elipse Knowledgebase","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]SQL Server Express 2005 Tutorial: installation and settings.[:] - Elipse Knowledgebase","og_description":"This article illustrates how to install and set up the SQL Server Express 2005, free version of Microsoft&#8217;s database, and use it as E3&#8217;s database. The installer can be downloaded&hellip;","og_url":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:43:55+00:00","article_modified_time":"2019-07-05T19:15:06+00:00","og_image":[{"url":"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID2405\/SQL.bmp"}],"author":"Elipse Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elipse Software","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"SQL Server Express 2005 Tutorial: installation and settings.","datePublished":"2019-03-25T20:43:55+00:00","dateModified":"2019-07-05T19:15:06+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/"},"wordCount":278,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["DataBases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/","url":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/","name":"[:pt]SQL Server Express 2005 Tutorial: installation and settings.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:43:55+00:00","dateModified":"2019-07-05T19:15:06+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-tutorial-installation-and-settings\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"SQL Server Express 2005 Tutorial: installation and settings."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87","name":"Elipse Software","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","caption":"Elipse Software"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3360"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=3360"}],"version-history":[{"count":1,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3360\/revisions"}],"predecessor-version":[{"id":7557,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3360\/revisions\/7557"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=3360"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=3360"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=3360"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}