Authentication
-
SQL2000 supports Windows Only Authentication as well as Windows & SQL Authentication.
Are people setting up their DB's with Windows Only authentication or are they using *both*.
What I think is occuring is that most people are setting up using *both* Windows and SQL and keeping only the SA account with a secure password.
-
Usually I use *both* since we use a lot of web applications and remote applications. However on two of ours, due to the fact the only accounts that can access are domain admins we set to Windows only. I do this primarily for specific protection.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
-
Most people use both. I've got an article coming out next week that talks about this topic some.
Andy
-
We use both at our company. About half a year ago we had a situation, where a user couldn't connect to a remote system (running SQL Server) within his Enterprise Manager.
We eventually found out that because the remote SQL Server was running on a server without a host name (only IP address), that it needed SQL Server Authentication switched on so that the other SQL Server instance on the network workstation could connect to the SQL Server instance with only an IP address.
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
__________________________________
Searching the KB articles is like
picking your nose. You never know
what you'll find.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply