Export (0) Print
Expand All

Connect to Server (Login Page) SQL Server Compact

Use this tab to view or specify options when connecting to Microsoft SQL Server Compact 3.5 SP2.

Server type

When registering a server from Object Explorer, select the type of server to connect to: Database Engine, Analysis Services, Reporting Services, SQL Server Compact 3.5 SP2, or Integration Services. The rest of the dialog shows only the options that apply to the selected server type. When registering a server from Registered Servers, the Server type box is read-only, and matches the type of server displayed in the Registered Servers component. To register a different type of server, select Database Engine, Analysis Services, Reporting Services, SQL Server Compact 3.5 SP2, or Integration Services from the Registered Servers toolbar before starting to register a new server.

Database file

Select the database by selecting the database file to connect to.

Authentication

SQL Server Compact 3.5 SP2 Authentication is the only option available.

Login

This option in not available for SQL Server Compact 3.5 SP2.

Password

Enter the password for the login. This option is only editable if you have selected to connect using SQL Server Authentication.

Remember password

Click to have SQL Server store the password you have entered. This option is only displayed if you have selected to connect using SQL Server Compact 3.5 SP2 Authentication.

Connect

Click to connect to the server selected above.

Options

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

NoteNote

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

ADD
Show:
© 2014 Microsoft