Jaa

SQL Server Authentication

  • Artikkeli

The SQL Server Authentication page of the New Subscription Wizard lets you specify either Windows Authentication or SQL Server Authentication to be used when the SQL Server 2005 Compact Edition Subscriber connects to SQL Server.

Options

Use Windows Authentication. A SQL Server user name and password are not required.

Select this check box if you want to use Windows Authentication. When Windows Authentication is used to connect to SQL Server, Microsoft Windows is completely responsible for authenticating the client. In this case, the client is identified by its Windows user account.

Use SQL Server Authentication with the following SQL Server user name and password.

Select this check box if you want to use SQL Server Authentication. When SQL Server Authentication is used, SQL Server authenticates the client by comparing the client-supplied user name and password to the list of valid user names and passwords maintained within SQL Server.