Connect to Server (SQL Server Compact Edition)

Use this dialog to view or specify options when connecting to Microsoft SQL Server 2005 Compact Edition.

Options

  • 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 2005 Compact Edition, 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 2005 Compact Edition, 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 2005 Compact Edition Authentication is the only option available.
  • Login
    This option in not available for SQL Server 2005 Compact Edition.
  • Password
    Enter the password for the database.
  • Connect
    Click to connect to the server selected above.
  • Options
    Click to display additional server connection options, such as registering a server and remembering the password.

See Also

Other Resources

How to: Connect to SQL Server from Windows Vista

Help and Information

Getting SQL Server 2005 Assistance