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)