SQL Server Authentication

[StuartShepherd]

I have recently installed SQL Server 2000 onto my development computer.

I need to set SQL Servers Authentication to "SQL Server and Windows" so I can use the SA login. The problem I am experiencing is that everytime I select "SQL Server and Windows" option on the Security tab on the Properties dialog and click on OK and go back to the Security Tab, the "Windows only" radio button is re-selected!

No errors are reported and I searched the interenet for an reported problems but I cant find any thing.

Any ideas?

Thanks in advanced.

 

[SQLBill]

What access level does your login have?

(In Enterprise Manager, go to Security, expand that, click on Logins. Right click on your login and check the second tab).

-SQLBill

 

[StuartShepherd]

Thanks for reply SQLBill,

After posting this message, i continued searching this forum and found a number of other posts with users experiencing the same problem as I have. The solution is the good old tech advice of "Have you tried rebooting your computer?". I rebooted and everything worked as expected. Dont you just love computers?

Thanks
Stuart

 

[SQLBill]

Ahhh, the old magical REBOOT. Well I'm glad you found the solution.

-SQLBill