Connection Properties Dialog Box (SSAS - Tabular)

Use this page to view or modify in SQL Server Management Studio the connection properties of a data source used by a tabular model database.

This dialog box provides timestamps and other descriptive information, plus customizable properties that determine characteristics of the connection.

Options

Term	Definition
Name	Specifies the name of the data source.
ID	Displays the identifier of the data source object.
Description	Displays the description of the data source object.
Create Timestamp	Displays the date and time the database was created.
Last Schema Update	Displays the date and time the metadata for the database was last updated.
Connection String	Displays the connection string used to connect to the data source that provides data to the model.
Maximum Number of Connections	Specifies the maximum number of client connections to this database.
Isolation	Valid values are ReadCommitted or Snapshot. For more information, see Isolation Element (ASSL).
Query Timeout	Specifies the time, in seconds, after which an attempt to retrieve data is timed out.
Managed Provider	Specifies the name of the managed provider. If the data source connection uses a native OLE DB provider, this value is empty.
Impersonation Info	Specifies the impersonation account used for database connections when processing or refreshing data, queries that run against a relational data store (via DirectQuery), out-of-line bindings, remote partitions, and database synchronization from target to source. Valid values include the Analysis Services service account or a specific set of Windows credentials. Do not specify Use the credentials of the current user or Inherit. Those credential options are not supported for a tabular model database.