Export (0) Print
Expand All

Get-MasterDataServicesDatabaseServerInformation (Windows PowerShell)

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

Gets connection information for a specified instance of SQL Server.


Get-MasterDataServicesDatabaseServerInformation [-ConnectionString] <String>

Get-MasterDataServicesDatabaseServerInformation returns a database server information object that connects to a specified instance of SQL Server and gets information about that instance. It verifies that the specified instance of SQL Server is a supported version and edition to host a Master Data Services database. 

-ConnectionString

The ConnectionString parameter is a string that specifies the information to connect to an instance of SQL Server.

Required?

true

Position?

0

Default Value

none

Accept Pipeline Input

false

Accept Wildcard Characters?

false

The input type is the type of the objects that you can pipe to the cmdlet. The return type is the type of the objects that the cmdlet returns.

Inputs

none

Outputs

Microsoft.MasterDataServices.Configuration.DatabaseServerInformation

Get-MasterDataServicesDatabaseServerInformation returns a database server information object to connect to a specified instance of SQL Server.

Output

The following is an example of the output that is returned when you use this cmdlet.

IsSkuValid         : True
IsVersionValid     : True
SqlInstance        : MyServer\MyInstance
SqlSku             : Enterprise
SqlVersion         : 10.50.NNNN.N
IsValid            : True
IsConnectionTested : True
Collations         : {Albanian, Arabic, Assamese, Azeri_Cyrillic...}
ServerProperties   : Microsoft.MasterDataServices.Configuration.DatabaseServerProperties
Connection         : System.Data.SqlClient.SqlConnection
ConnectionString   : Data Source=MyServer\MyInstance;Integrated Security=True;Persist Security Info=True;Pooling=False
IsSqlAdministrator : True

Using a Named Parameter

This example specifies the ConnectionString parameter as a named parameter to connect to and get information about the specified instance of SQL Server. Optionally, this object can be piped to other Master Data Services cmdlets that require a connection to the server that hosts a Master Data Services database.

C:\PS> Get-MasterDataServicesDatabaseServerInformation -ConnectionString 'Data Source=MyServer\MyInstance;Initial catalog=;Integrated Security=True;User ID=;Password='
Show:
© 2015 Microsoft