Connect to Server (Connection Properties Page) SQL Server Compact Edition
Use this tab to view or specify options when connecting to Microsoft SQL Server Compact Edition or registering SQL Server 2005 Compact Edition in Registered Servers. Connect and Options only appear in this dialog box when connecting. Test and Save only appear in this dialog box when registering SQL Server 2005 Compact Edition.
- Connection timeout
Enter the number of seconds to wait for a connection to be established before timing out. The default value is 15 seconds.
- Execution timeout
Enter the amount of time in seconds to wait before execution of a task is completed on the server. The default value is zero seconds, which indicates there is no time-out.
- Maximum database size
Default size is 128 MB.
- Default lock escalation
Default value is 100 locks.
- Reset All
Replace all manually entered connection property values with the default values.
Attempt a connection using the listed values.
Click to change the dialog and hide the additional server connection options, such as remembering the password.
When registering SQL Server 2005 Compact Edition in Registered Servers, click to test the connection.
Saves the settings in Registered Servers.