{"id":2282,"date":"2015-05-26T06:38:18","date_gmt":"2015-05-26T06:38:18","guid":{"rendered":"http:\/\/techsupport.relyonsoft.in\/?p=2282"},"modified":"2017-01-07T11:25:57","modified_gmt":"2017-01-07T11:25:57","slug":"change-windows-authentication-to-mixed-mode-in-sql-server","status":"publish","type":"post","link":"https:\/\/relyonsoft.in\/techsupport\/change-windows-authentication-to-mixed-mode-in-sql-server\/","title":{"rendered":"Change Windows Authentication To Mixed Mode In SQL Server."},"content":{"rendered":"<p style=\"text-align: left\">This post describes changing Window Authentication mode to Mixed Authentication mode in SQL Server. When you install SQL Server by default window authentication is installed If you do not choose mixed authentication at the time of SQL Server installation. However these modes can be changed even after installation of SQL Server.<\/p>\n<p><strong>Step 1 : <\/strong>Start <strong>Query Express.exe<\/strong>\/<strong>SQL MANAGEMENT STUDIO<\/strong> .<\/p>\n<p><strong>NOTE : \u00a0<\/strong>You can find<strong> queryexpress.ex<\/strong>e in application path of <strong>RELYON<\/strong> \u00a0products<\/p>\n<p><img class=\"alignnone size-full wp-image-2283\" src=\"http:\/\/techsupport.relyonsoft.in\/wp-content\/uploads\/2015\/05\/query-express.bmp\" alt=\"\" \/><\/p>\n<ul>\n<li>Connect to an instance of Database Engine.<\/li>\n<li>Copy and paste the following queries \u00a0into the query window and click\u00a0<strong>Execute<\/strong>.<\/li>\n<\/ul>\n<div>\n<p><strong>USE [master]<\/strong><\/p>\n<p><strong>GO<\/strong><\/p>\n<p><strong>\u00a0<\/strong><strong>EXEC xp_instance_regwrite N&#8217;HKEY_LOCAL_MACHINE&#8217;, N&#8217;Software\\Microsoft\\MSSQLServer\\MSSQLServer&#8217;, N&#8217;LoginMode&#8217;, REG_DWORD, 2<\/strong><\/p>\n<p><strong>GO<\/strong><\/p>\n<p><strong>\u00a0<\/strong><strong>ALTER LOGIN [sa] ENABLE<\/strong><\/p>\n<p><strong>GO<\/strong><\/p>\n<p><strong>\u00a0<\/strong><strong>ALTER LOGIN [SA] WITH PASSWORD = N&#8217;YOURPASSWORD&#8217;<\/strong><\/p>\n<p><strong>GO<\/strong><\/p>\n<\/div>\n<p><strong>Step 2 : <\/strong>Restart SQL server service.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post describes changing Window Authentication mode to Mixed Authentication mode in SQL Server. When you install SQL Server by default window authentication is installed If you do not choose mixed authentication at the time of SQL Server installation. However these modes can be changed even after installation of SQL Server. Step 1 : Start [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/2282"}],"collection":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/comments?post=2282"}],"version-history":[{"count":0,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/2282\/revisions"}],"wp:attachment":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/media?parent=2282"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/categories?post=2282"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/tags?post=2282"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}