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.

Options

• 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.

• Connect
  Attempt a connection using the listed values.

• Options
  Click to change the dialog and hide the additional server connection options, such as remembering the password.

• Test
  When registering SQL Server Compact 3.5 SP2 in Registered Servers, click to test the connection.

• Save
  Saves the settings in Registered Servers.

Note

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