-->

Aug 02, 2019  942177 How to determine the version of SQL Server Integration Services. SQL Server Analysis Services. To determine the version of SQL Server Analysis Services, use one of the following methods: Method 1: Connect to the server by using Object Explorer in SQL Server Management Studio. After Object Explorer is connected, it will show the version. Let’s say you are helping out a co-worker with their SSIS package. They have SQL 2008 installed and that’s the version of the server where it’s currently running. You open it but forget that you are actually running Data Tools for SQL 2012.

2019

Gets a list of all servers in the subscription.

URI Parameters

NameInRequiredTypeDescription
path True
  • string

The subscription ID that identifies an Azure subscription.

api-version
query True
  • string

The API version to use for the request.

Responses

NameTypeDescription
200 OK

Successfully retrieved the list of servers.

Other Status Codes

*** Error Responses: ***

Examples

List servers

Sample Response

Microsoft Sql Server Version List

Definitions

IdentityType

The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

ResourceIdentity

Azure Active Directory identity configuration for a resource.

Server

An Azure SQL Database server.

ServerListResult

A list of servers.

IdentityType

The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

Sql Server Native Client Version List

NameTypeDescription
SystemAssigned
  • string

ResourceIdentity

Ms Sql Server Version List

Azure Active Directory identity configuration for a resource.

NameTypeDescription
principalId
  • string

The Azure Active Directory principal id.

tenantId
  • string

The Azure Active Directory tenant id.

type

The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource.

Server

Sql Server Version List 2016

An Azure SQL Database server.

NameTypeDescription
id
  • string

Resource ID.

identity

The Azure Active Directory identity of the server.

kind
  • string

Kind of sql server. This is metadata used for the Azure portal experience.

location
  • string

Resource location.

name
  • string

Resource name.

properties.administratorLogin
  • string

Administrator username for the server. Once created it cannot be changed.

properties.administratorLoginPassword
  • string

The administrator login password (required for server creation).

properties.fullyQualifiedDomainName
  • string

The fully qualified domain name of the server.

properties.state
  • string

The state of the server.

properties.version
  • string

The version of the server.

tags
  • object

Resource tags.

type
  • string

Toshiba harman kardon drivers download free. Resource type.

ServerListResult

A list of servers.

Sql Server 2016 Version List

NameTypeDescription
nextLink
  • string

Link to retrieve next page of results.

value
  • Server[]

Array of results.