Microsoft SQL Server Security
Microsoft SQL Server 2000 is used by many portal implementations as data storage for personalization and user profile information. Many portals incorporate enterprise data residing in SQL Server databases. A detailed discussion of Microsoft SQL Server features is beyond the scope of this chapter, but this section does briefly cover the main points on SQL Server security.
SQL Server 2000 security is based on Windows security. SQL Server provides two authentication modes:
Windows authentication mode
Mixed authentication mode
Windows Authentication Mode
Windows authentication mode is the default and most secure authentication mode. As its name implies, it bases SQL Server security on existing Windows user or group accounts. ...
Get Building Portals, Intranets, and Corporate Web Sites Using Microsoft Servers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
