Export (0) Print
Expand All

Connect to Server (Connection Properties Page) SQL Server Compact

Use this tab to view or specify options when connecting to Microsoft SQL Server Compact 3.5 SP2. or registering SQL Server Compact 3.5 SP2 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 Compact 3.5 SP2.

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 Compact 3.5 SP2 in Registered Servers, click to test the connection.


Saves the settings in Registered Servers.


SQL Server Management Studio does not support SQL Server Compact 4.0.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft