System Integration

Microsoft® SQL Server™ is integrated with other products and environments.

Internet Access

SQL Server works with other products to form a stable and secure data store for Internet and intranet systems.

• SQL Server works with Microsoft Windows NT® Server security and encryption facilities to implement secure data storage.
• SQL Server forms a high-performance data storage service for Internet Information Services Web applications.
• SQL Server can be used with Site Server to build and maintain large, sophisticated e-commerce Web sites.
• The SQL Server TCP/IP Sockets Net-Library can be integrated with Microsoft Proxy Server to implement secure Internet and intranet communications.

SQL Server is scalable to levels of performance capable of handling extremely large Internet sites.

The Web Assistant Wizard quickly guides users through the steps to:

• Generate HTML pages from SQL Server data.
• Post SQL Server data to HTTP and FTP locations.

SQL Server fully supports Web pages using Active Server Pages (ASP) or the Internet Data Connector (IDC).

Security Integrated with Windows NT Security

SQL Server supports using Windows NT user and domain accounts as SQL Server login identifiers. This is called Windows NT Authentication. Users are validated by Windows NT when the connect to the network. When a connection is formed to SQL Server, the SQL Server client software requests a trusted connection, which can be granted only if they have been validated by Windows NT. SQL Server then does not have to validate the user separately. Users do not have to have separate logins and passwords for each SQL Server system to which they connect.

With Windows NT Authentication, no passwords are transmitted to the server running SQL Server, eliminating a security concern. Also, the SQL Server Multiprotocol Net-Library uses the Windows NT RPC API to send network packets to SQL Server. The RPC API supports encryption, allowing users who want the capability of encrypting all the network traffic between their client computer and SQL Server.

Mail Integration

SQL Server can send and receive e-mail and pages from Microsoft Exchange or other MAPI-compliant mail servers. This allows SQL Server stored procedures or triggers to send e-mail. SQL Server events and alerts can be set to send e-mail or pages automatically to the server administrators in case of severe or pending problems.

SQL Server can also accept e-mail containing an SQL statement. SQL Server will execute the statement and send the results using a reply e-mail, with an optional CC: list.

See Also