{"id":2461,"date":"2013-10-31T15:27:48","date_gmt":"2013-10-31T05:27:48","guid":{"rendered":"http:\/\/support.cybersecure.com\/?p=2461"},"modified":"2013-10-31T15:27:48","modified_gmt":"2013-10-31T05:27:48","slug":"how-to-enable-mixed-mode-authentication-in-ms-sql-server","status":"publish","type":"post","link":"http:\/\/support.cybersecure.com\/?p=2461","title":{"rendered":"How to enable mixed mode authentication in MS-SQL server"},"content":{"rendered":"<ol>\n<li>Open the SQL server configuration studio<\/li>\n<li>Login with appropriate admin-level privileges<\/li>\n<li>In the main console, right-click your server  and choose &#8220;Properties&#8221;<\/li>\n<li>Click on &#8220;Security&#8221;<\/li>\n<li>Under &#8220;Server authentication&#8221;, ensure that &#8220;SQL Server and Windows authentication mode&#8221; is selected<br \/>\n<a href=\"http:\/\/support.cybersecure.com\/wp-content\/uploads\/2013\/10\/sql-mgmt-studio-server-properties-authmode.fw_.png\"><img loading=\"lazy\" class=\"alignnone size-medium wp-image-2462\" title=\"sql-mgmt-studio-server-properties-authmode.fw\" src=\"http:\/\/support.cybersecure.com\/wp-content\/uploads\/2013\/10\/sql-mgmt-studio-server-properties-authmode.fw_-300x265.png\" alt=\"\" width=\"300\" height=\"265\" srcset=\"http:\/\/support.cybersecure.com\/wp-content\/uploads\/2013\/10\/sql-mgmt-studio-server-properties-authmode.fw_-300x265.png 300w, http:\/\/support.cybersecure.com\/wp-content\/uploads\/2013\/10\/sql-mgmt-studio-server-properties-authmode.fw_.png 800w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/li>\n<li>Choose OK<\/li>\n<li>You may need to restart the SQL service for the changes to take effect<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Open the SQL server configuration studio Login with appropriate admin-level privileges In the main console, right-click your server and choose &#8220;Properties&#8221; Click on &#8220;Security&#8221; Under &#8220;Server authentication&#8221;, ensure that &#8220;SQL Server and Windows authentication mode&#8221; is selected Choose OK You &hellip; <a href=\"http:\/\/support.cybersecure.com\/?p=2461\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"_links":{"self":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/2461"}],"collection":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2461"}],"version-history":[{"count":1,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/2461\/revisions"}],"predecessor-version":[{"id":2463,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=\/wp\/v2\/posts\/2461\/revisions\/2463"}],"wp:attachment":[{"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2461"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/support.cybersecure.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}