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 Compact 3.5 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.
Note Windows Authentication is more secure than SQL Server Authentication. When possible, you should use Windows Authentication. |
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.