In making your security decisions, you might wonder whether to use IPSec or Kerberos for authentication and encryption. The main difference between them is that IPSec authenticates computer-to-computer communications and Kerberos authenticates...
Learn how to balance data modification against retrieval
I'm having trouble getting my SQL Server client tools to connect to a default instance of SQL Server 2000 through a dynamically determined TCP/IP port. The SQL Server has the TCP/IP Net-Library enabled. I installed SQL Server 2000 using the...
One of my SQL Server users periodically stops and starts the SQL Server Agent service. The user isn't a member of the sysadmin role and isn't a member of any other SQL Server role, but the user can still stop the service. I've denied public access...