Share via


Database Connection and Database Properties

These properties appear in the Properties window when you select a data source connection in Server Explorer. Unless otherwise noted, data connection properties cannot be edited in the Properties window.

Note

The properties in this topic are ordered by category rather than alphabet.

  • Identity Category
    Expands to show the Name property. (Applies only to Microsoft SQL Server.)

  • Name
    Shows the database name for which the data source is configured. (Applies only to Microsoft SQL Server.)

  • Connection Category
    Expands to show properties for Connection String, Provider, State, Type, and Version.

  • Connection String
    Displays the connection string used to establish a connection to the data source.

  • Provider
    Displays the name of the provider used in the connection. This can be modified from the Change Data Source dialog. By default the .NET managed provider for SQL Server is selected.

  • State
    Indicates whether Server Explorer is connected to a data source. The value can be either Open or Closed.

  • Type
    Indicates the type of the database management system, such as Microsoft SQL Server or Oracle that manages your data source.

  • Version
    Shows the version number of the database management system.

  • Misc Category
    Expands to show properties for Case Sensitive, Owner, and Primary File Path.

  • Case Sensitive
    Shows whether the selected data source is case sensitive. (Applies only to Microsoft SQL Server 2000 or later.)

  • Owner
    Shows the name of the owner of the selected database. (Applies only to Microsoft SQL Server.)

  • Primary File Path
    Shows the location of the selected data source's primary file's folder. (Applies only to Microsoft SQL Server 2000 or later.)

See Also

Tasks

How to: Connect to a Database from Server Explorer

Reference

Add/Modify Connection Dialog Box (General)

Other Resources

Properties in Visual Database Tools