June 13, 2005 at 3:53 pm
It been a while since i set up SQL Server 2000 on my laptop. How do i know if i set it up using Windows Authentication Mode or Mixed Mode? Is there a way to change it?
June 13, 2005 at 3:57 pm
Using Enterprise Manager, right click on the server, select properties, then select Security Tab.
Hal
June 13, 2005 at 4:41 pm
You can also check in the registry (and modify): Key LoginMode in HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer. 1 is Windows Only, 0 is Mixed Mode.
June 15, 2005 at 10:33 am
Thanks guys! That basically answered my question.
It doesn't use the terms Windows Authentication Mode or Mixed Mode but i assume that SQL Server and Windows is Mixed Mode--the first option and Windows only is Windows Authentication Mode.
However, for Audit Level, i have None selected. Maybe i'll get to that later in the book.
Startup service account
"Start and run SQL Server in the following account."
- System Account
- This account (Has password option)
What is this section about? How does it relate to the two above modes?
Thanks again!
June 15, 2005 at 12:54 pm
One more question. If i'm using windows authentication mode, do i have to worry about password protecting the SA account?
June 15, 2005 at 3:03 pm
You should still set a strong password for sa, since all that is required is for someone that has access to the registry to change the key I mentioned above to change to mixed mode authentication. If you do not have a password for sa they would then gain full access to SQL Server.
June 16, 2005 at 7:59 am
Thanks!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply