Progress
DataServer for
Microsoft SQL Server
Guide
Connections and Security on NT
When you configure an ODBC data source on NT, you can choose one of three levels of security:
- Standard — Requires that a client pass a user ID and password that the SQL Server™ database validates against the list of users in the syslogins table. The request typically comes from a nontrusted connection, such as through TCP/IP. The Progress client or WebSpeed agent passes this information with the User ID (-U) and Password (-P) connection parameters.
- Integrated — Relies on the NT operating system to validate user information. The SQL Server™ database accepts user information from the process that requests a connection. The request must come from a trusted connection, such as one using Named Pipes. The SQL Server™ database performs no additional validation.
- Mixed — Accepts requests from trusted or nontrusted connections.
- If the connection is trusted and the client provides no user ID, a user ID that consists entirely of spaces, or a user ID that matches the user that started the process, the SQL Server™ database accepts the connection.
- If the connection is nontrusted, the Progress client must provide the user ID and password.
Progress Software Corporation recommends the following guidelines for working with a SQL Server™ database and NT security:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |