• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 317
  • Last Modified:

Cannot switch to Mixed Authentication Mode for SQL Server

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.
0
nebfis
Asked:
nebfis
  • 3
2 Solutions
 
Dave BaldwinFixer of ProblemsCommented:
Please click on "Request Attention" and get your question moved to the Microsoft SQL Server zones.  MySQL is a different database.
0
 
nebfisAuthor Commented:
No solution was found.
0
 
nebfisAuthor Commented:
Oh, well ...
0
 
nebfisAuthor Commented:
No solution was found.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now