Get-MasterDataServicesDatabaseServerInformation (Windows PowerShell)

Gets connection information for a specified instance of SQL Server.

Syntax

Get-MasterDataServicesDatabaseServerInformation [-ConnectionString] <String>

Description

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. 

Parameters

-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

Inputs and Outputs

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.

Examples

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='