{"id":3373,"date":"2019-03-25T17:43:59","date_gmt":"2019-03-25T20:43:59","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/sql-server-express-2005-frequently-asked-questions\/"},"modified":"2019-06-10T14:04:35","modified_gmt":"2019-06-10T17:04:35","slug":"sql-server-express-2005-frequently-asked-questions","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/","title":{"rendered":"SQL Server Express 2005: Frequently Asked Questions."},"content":{"rendered":"
\n

How can I set up an SQL Database?<\/b><\/u><\/p>\n

To do so, follow the procedures in SQL Server Express 2005 Tutorial: installation and settings<\/a>.<\/p>\n

I forgot my “sa” password. What can I do about it? <\/b><\/u><\/p>\n

You can change it via Management Studio<\/b>. To do so, connect temporarily to the Server with Windows Authentication<\/b>.<\/p>\n

\"\"<\/div>\n

After connecting, right-click “sa”, and select Properties<\/b>:<\/p>\n

\"\"<\/div>\n

On this screen, you will be able to redefine this user’s password. Uncheck Enforce password policy<\/b> option to enable other passwords’ definition, regardless of their complexity level in characters combination.<\/p>\n

\"\"<\/div>\n

I don’t want to use the “sa” user. How can I create another login?<\/b><\/u><\/p>\n

Right-click Logins<\/b>, and then select New Login…<\/b>:<\/p>\n

\"\"<\/div>\n

Choose a name for your login, select the SQL Server Authentication<\/b> option, and set up the new password:<\/p>\n

\"\"<\/div>\n

At User mapping<\/b> menu, select the databases this user will have access to.<\/p>\n

\"\"<\/div>\n

When changing a login’s password, another (larger) password is saved instead. Why does this happen? <\/u><\/b><\/p>\n

Actually, the software will insert a few extra false asterisks to the password field<\/u>, to try to mask the actual number of characters in the password.<\/p>\n

During installation, I checked the Windows Authentication<\/i> option. Can this be altered later?\u00a0 <\/b><\/u><\/p>\n

Yes. To do so, right-click the server (as seen below), and select Properties<\/b>:<\/p>\n

\"\"<\/div>\n

At Security <\/b>menu, you can redefine the authentication option:<\/p>\n

\"\"<\/div>\n

After that, create a new user by following the steps in previous items of this article. This user will be required to log into SQL Express, and also to connect the Elipse E3 to the Database.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

How can I set up an SQL Database? To do so, follow the procedures in SQL Server Express 2005 Tutorial: installation and settings. I forgot my “sa” password. What can…<\/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":"\nSQL Server Express 2005: Frequently Asked Questions. - 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-frequently-asked-questions\/\" \/>\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: Frequently Asked Questions.\" \/>\n<meta property=\"og:description\" content=\"How can I set up an SQL Database? To do so, follow the procedures in SQL Server Express 2005 Tutorial: installation and settings. I forgot my “sa” password. What can…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/\" \/>\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:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-06-10T17:04:35+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID2407\/SQL%20(49).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-frequently-asked-questions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"SQL Server Express 2005: Frequently Asked Questions.\",\"datePublished\":\"2019-03-25T20:43:59+00:00\",\"dateModified\":\"2019-06-10T17:04:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/\"},\"wordCount\":260,\"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-frequently-asked-questions\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/\",\"name\":\"[:pt]SQL Server Express 2005: Frequently Asked Questions.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:43:59+00:00\",\"dateModified\":\"2019-06-10T17:04:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/#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: Frequently Asked Questions.\"}]},{\"@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: Frequently Asked Questions. - 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-frequently-asked-questions\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]SQL Server Express 2005: Frequently Asked Questions.[:] - Elipse Knowledgebase","og_description":"How can I set up an SQL Database? To do so, follow the procedures in SQL Server Express 2005 Tutorial: installation and settings. I forgot my “sa” password. What can…","og_url":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:43:59+00:00","article_modified_time":"2019-06-10T17:04:35+00:00","og_image":[{"url":"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID2407\/SQL%20(49).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-frequently-asked-questions\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"SQL Server Express 2005: Frequently Asked Questions.","datePublished":"2019-03-25T20:43:59+00:00","dateModified":"2019-06-10T17:04:35+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/"},"wordCount":260,"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-frequently-asked-questions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/","url":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/","name":"[:pt]SQL Server Express 2005: Frequently Asked Questions.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:43:59+00:00","dateModified":"2019-06-10T17:04:35+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/sql-server-express-2005-frequently-asked-questions\/#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: Frequently Asked Questions."}]},{"@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\/3373"}],"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=3373"}],"version-history":[{"count":1,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3373\/revisions"}],"predecessor-version":[{"id":7134,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3373\/revisions\/7134"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=3373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=3373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=3373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}