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.
Select the database by selecting the database file to connect to.
SQL Server Compact 3.5 SP2 Authentication is the only option available.
This option in not available for SQL Server Compact 3.5 SP2.
Enter the password for the database.
Click to connect to the server selected above.
Click to display additional server connection options, such as registering a server and remembering the password.
SQL Server Management Studio does not support SQL Server Compact 4.0.