O'Reilly logo

Security for Microsoft® Visual Basic® .NET by Michael James Bond, Ed Robinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Server Authentication

SQL Server 2000 can authenticate users with one of two mechanisms. The first mechanism is Windows Authentication, where the user’s Windows user code is silently passed to SQL Server. The second type is confusingly named SQL Server Authentication, where the user enters a username/password combination that is maintained in SQL Server. Don’t be fooled by the name SQL Server Authentication—this type of authentication is by no means a preferred option for authentication. As we discuss soon, Windows Authentication is the preferred option.

You can configure SQL Server to use Windows authentication only, or Mixed Mode. Mixed Mode supports both Windows Authentication and SQL Server Authentication, and is provided mainly for backward ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required