<div>
<div class="content wysiwyg-content">
Hello,<br />
I am running MS SQL Server 2000 on Windows XP machine. Currently Authentication mode is set to &quot;Windows only&quot;. I use Enterprise Manager, go to Properties for SQL Server engine, then to Security tab. I have no problems clicking on &quot;SQL Server and Windows&quot; radio button there. Then I click the &quot;OK&quot; button. When I reopen the Properties window, security mode is still set to &quot;Windows only&quot;. Restarting SQL Server doesn't make any difference. I hope there is some simple explanation to this stupid problem. Will appreciate any suggestions.
</div>
</div>


Hello,
I am running MS SQL Server 2000 on Windows XP machine. Currently Authentication mode is set to "Windows only". I use Enterprise Manager, go to Properties for SQL Server engine, then to Security tab. I have no problems clicking on "SQL Server and Windows" radio button there. Then I click the "OK" button. When I reopen the Properties window, security mode is still set to "Windows only". Restarting SQL Server doesn't make any difference. I hope there is some simple explanation to this stupid problem. Will appreciate any suggestions.

Cannot switch to Mixed Authentication Mode for SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.