fix broken links from CATS report

craigcaseyMSFT · craigcaseyMSFT · commit a1da732f73c8 · 2020-03-12T11:49:58.000-07:00
diff --git a/docs/2014/analysis-services/data-mining/data-mining-services-and-data-sources.md b/docs/2014/analysis-services/data-mining/data-mining-services-and-data-sources.md
@@ -111,7 +111,7 @@ manager: craigg
   
  If the procedure returns a dataset, the client will receive a dataset or datatable with a nested table containing the rows. For example, if you create a query against the model content, the query returns the entire model. To avoid bringing back too many rows, you can write stored procedures by using the ADOMD+ object model.  
   
- To write a server stored procedure, you must reference the Microsoft.AnalysisServices.AdomdServer namespace. For more information about how to create and use stored procedures, see [User Defined Functions and Stored Procedures](https://docs.microsoft.com/bi-reference/adomd/multidimensional-models-adomd-net-server/user-defined-functions-and-stored-procedures).  
+ To write a server stored procedure, you must reference the Microsoft.AnalysisServices.AdomdServer namespace. For more information about how to create and use stored procedures, see [User Defined Functions and Stored Procedures](https://docs.microsoft.com/analysis-services/adomd/multidimensional-models-adomd-net-server/user-defined-functions-and-stored-procedures).  
   
 > [!NOTE]  
 >  Stored procedures cannot be used to change security on data server objects. When you execute a stored procedure, the user's current context is used to determine access to all server objects. Therefore, users must have appropriate permissions on any database objects that they access.  
diff --git a/docs/2014/analysis-services/instances/configure-http-access-to-analysis-services-on-iis-8-0.md b/docs/2014/analysis-services/instances/configure-http-access-to-analysis-services-on-iis-8-0.md
@@ -287,7 +287,7 @@ manager: craigg
   
  `Data Source=https://<servername>/olap/msmdpump.dll; Initial Catalog=AdventureWorksDW2012; Integrated Security=Basic; User ID=XXXX; Password=XXXXX;`  
   
- For more information about setting up the connection programmatically, see [Establishing Secure Connections in ADOMD.NET](https://docs.microsoft.com/bi-reference/adomd/multidimensional-models-adomd-net-client/connections-in-adomd-net-establishing-secure-connections).  
+ For more information about setting up the connection programmatically, see [Establishing Secure Connections in ADOMD.NET](https://docs.microsoft.com/analysis-services/adomd/multidimensional-models-adomd-net-client/connections-in-adomd-net-establishing-secure-connections).  
   
  As a final step, be sure to follow-up with more rigorous testing by using a client computer that runs in the network environment from which the connections will originate.  
   
diff --git a/docs/2014/analysis-services/instances/connection-string-properties-analysis-services.md b/docs/2014/analysis-services/instances/connection-string-properties-analysis-services.md
@@ -63,7 +63,7 @@ manager: craigg
 |`Integrated Security`|The Windows identity of the caller is used to connect to Analysis Services. Valid values are blank, SSPI, and BASIC.<br /><br /> `Integrated Security`=`SSPI` is the default value for TCP connections, allowing NTLM, Kerberos, or Anonymous authentication. Blank is the default value for HTTP connections.<br /><br /> When using `SSPI`, `ProtectionLevel` must be set to one of the following: `Connect`, `PktIntegrity`, `PktPrivacy`.|  
 |`Persist Encrypted`|Set this property when the client application requires the data source object to persist sensitive authentication information, such as a password, in encrypted form. By default, authentication information is not persisted.|  
 |`Persist Security Info`|Valid values are True and False. When set to True, security information, such as the user identity or password previously specified on the connection string, can be obtained from the connection after the connection is made. The default value is False.|  
-|`ProtectionLevel`|Determines the security level used on the connection. Valid values are:<br /><br /> `None`. Unauthenticated or anonymous connections. Performs no authentication on data sent to the server.<br /><br /> `Connect`. Authenticated connections. Authenticates only when the client establishes a relationship with a server.<br /><br /> `PktIntegrity`. Encrypted connections. Verifies that all data is received from the client and that it has not been changed in transit.<br /><br /> `PktPrivacy`. Signed encryption, supported only for XMLA. Verifies that all data is received from the client, that it has not been changed in transit, and protects the privacy of the data by encrypting it.<br /><br /> <br /><br /> For more information, see [Establishing Secure Connections in ADOMD.NET](https://docs.microsoft.com/bi-reference/adomd/multidimensional-models-adomd-net-client/connections-in-adomd-net-establishing-secure-connections)|  
+|`ProtectionLevel`|Determines the security level used on the connection. Valid values are:<br /><br /> `None`. Unauthenticated or anonymous connections. Performs no authentication on data sent to the server.<br /><br /> `Connect`. Authenticated connections. Authenticates only when the client establishes a relationship with a server.<br /><br /> `PktIntegrity`. Encrypted connections. Verifies that all data is received from the client and that it has not been changed in transit.<br /><br /> `PktPrivacy`. Signed encryption, supported only for XMLA. Verifies that all data is received from the client, that it has not been changed in transit, and protects the privacy of the data by encrypting it.<br /><br /> <br /><br /> For more information, see [Establishing Secure Connections in ADOMD.NET](https://docs.microsoft.com/analysis-services/adomd/multidimensional-models-adomd-net-client/connections-in-adomd-net-establishing-secure-connections)|  
 |`Roles`|Specify a comma-delimited list of predefined roles to connect to a server or database using permissions conveyed by that role. If this property is omitted, all roles are used, and the effective permissions are the combination of all roles. Setting the property to an empty value (for example, Roles=' ') the client connection has no role membership.<br /><br /> An administrator using this property connects using the permissions conveyed by the role. Some commands might fail if the role does not provide sufficient permission.|  
 |`SSPI`|Explicitly specifies which security package to use for client authentication when `Integrated Security` is set to `SSPI`. SSPI supports multiple packages, but you can use this property to specify a particular package. Valid values are Negotiate, Kerberos, NTLM, and Anonymous User. If this property is not set, all packages will be available to the connection.|  
 |`Use Encryption for Data`|Encrypts data transmissions. Value values are True and False.|  
diff --git a/docs/2014/analysis-services/instances/use-dynamic-management-views-dmvs-to-monitor-analysis-services.md b/docs/2014/analysis-services/instances/use-dynamic-management-views-dmvs-to-monitor-analysis-services.md
@@ -102,7 +102,7 @@ ORDER BY TABLE_NAME ASC
 |[DBSCHEMA_TABLES Rowset](https://docs.microsoft.com/bi-reference/schema-rowsets/ole-db/dbschema-tables-rowset)|Returns a list of all the tables in the current database. You can use this list to construct a DMV query.|  
 |[DISCOVER_CALC_DEPENDENCY Rowset](https://docs.microsoft.com/bi-reference/schema-rowsets/xml/discover-calc-dependency-rowset)|Returns a list of the columns and tables used in a model that have dependencies on other columns and tables.|  
 |[DISCOVER_COMMAND_OBJECTS Rowset](https://docs.microsoft.com/bi-reference/schema-rowsets/xml/discover-command-objects-rowset)|Provides resource usage and activity information about objects in use by the referenced command.|  
-|[DISCOVER_COMMANDS Rowset](https://docs.microsoft.com/bi-reference/schema-rowsets/xml/discover-commands-rowset)|Provides resource usage and activity information about currently executing command.|  
+|[DISCOVER_COMMANDS Rowset](https://docs.microsoft.com/analysis-services/instances/analysis-services-schema-rowsets)|Provides resource usage and activity information about currently executing command.|  
 |[DISCOVER_CONNECTIONS Rowset](https://docs.microsoft.com/bi-reference/schema-rowsets/xml/discover-connections-rowset)|Provides resource usage and activity information about open connections to Analysis Services.|  
 |[DISCOVER_CSDL_METADATA Rowset](https://docs.microsoft.com/bi-reference/schema-rowsets/xml/discover-csdl-metadata-rowset)|Returns information about a tabular model.<br /><br /> Requires the addition of SYSTEMRESTRICTSCHEMA and additional parameters.|  
 |[DISCOVER_DB_CONNECTIONS Rowset](https://docs.microsoft.com/bi-reference/schema-rowsets/xml/discover-db-connections-rowset)|Provides resource usage and activity information about open connections from Analysis Services to external data sources, for example during processing or importing.|  
@@ -149,9 +149,9 @@ ORDER BY TABLE_NAME ASC
 |[MDSCHEMA_INPUT_DATASOURCES Rowset](https://docs.microsoft.com/bi-reference/schema-rowsets/ole-db-olap/mdschema-input-datasources-rowset)|Returns information about the data source objects that are defined in the current database.|  
 |[MDSCHEMA_KPIS Rowset](https://docs.microsoft.com/bi-reference/schema-rowsets/ole-db-olap/mdschema-kpis-rowset)|Returns information about the KPIs that are defined in the current database.|  
 |[MDSCHEMA_LEVELS Rowset](https://docs.microsoft.com/bi-reference/schema-rowsets/ole-db-olap/mdschema-levels-rowset)|Returns information about the levels within the hierarchies that are defined in the current database.|  
-|[MDSCHEMA_MEASUREGROUP_DIMENSIONS Rowset](https://docs.microsoft.com/bi-reference/schema-rowsets/ole-db-olap/mdschema-measuregroup-dimensions-rowset)|Lists the dimension of measure groups.|  
+|[MDSCHEMA_MEASUREGROUP_DIMENSIONS Rowset](https://docs.microsoft.com/openspecs/sql_server_protocols/ms-ssas/e6399481-a289-41f3-94d2-e081bf29e094)|Lists the dimension of measure groups.|  
 |[MDSCHEMA_MEASUREGROUPS Rowset](https://docs.microsoft.com/bi-reference/schema-rowsets/ole-db-olap/mdschema-measuregroups-rowset)|Returns a list of measure groups in the current connection.|  
-|[MDSCHEMA_MEASURES Rowset](https://docs.microsoft.com/bi-reference/schema-rowsets/ole-db-olap/mdschema-measures-rowset)|Returns a list of measures in the current connection.|  
+|[MDSCHEMA_MEASURES Rowset](https://docs.microsoft.com/openspecs/sql_server_protocols/ms-ssas/ab8e721f-9b9c-4ba1-b105-37a5f200d67c)|Returns a list of measures in the current connection.|  
 |[MDSCHEMA_MEMBERS Rowset](https://docs.microsoft.com/bi-reference/schema-rowsets/ole-db-olap/mdschema-members-rowset)|Returns a list of all members in the current connection, listed by database, cube, and dimension.|  
 |[MDSCHEMA_PROPERTIES Rowset](https://docs.microsoft.com/bi-reference/schema-rowsets/ole-db-olap/mdschema-properties-rowset)|Returns a fully qualified name of each property, along with property type, data type, and other metadata.|  
 |[MDSCHEMA_SETS Rowset](https://docs.microsoft.com/bi-reference/schema-rowsets/ole-db-olap/mdschema-sets-rowset)|Returns a list of set that are defined in the current connection.|  
diff --git a/docs/2014/analysis-services/multidimensional-models-adomd-net-server/adomd-net-server-programming.md b/docs/2014/analysis-services/multidimensional-models-adomd-net-server/adomd-net-server-programming.md
@@ -23,10 +23,10 @@ manager: craigg
 |-----------|-----------------|  
 |[ADOMD.NET Server Functionality](https://docs.microsoft.com/bi-reference/adomd/multidimensional-models-adomd-net-server/adomd-net-server-functionality)|Describes the uses for ADOMD.NET server objects.|  
 |[ADOMD.NET Server Object Architecture](https://docs.microsoft.com/bi-reference/adomd/multidimensional-models-adomd-net-server/adomd-net-server-object-architecture)|Describes the object architecture for ADOMD.NET server objects.|  
-|[User Defined Functions and Stored Procedures](https://docs.microsoft.com/bi-reference/adomd/multidimensional-models-adomd-net-server/user-defined-functions-and-stored-procedures)|Walks you through the process of creating a user defined function or stored Procedure.|  
+|[User Defined Functions and Stored Procedures](https://docs.microsoft.com/analysis-services/adomd/multidimensional-models-adomd-net-server/user-defined-functions-and-stored-procedures)|Walks you through the process of creating a user defined function or stored Procedure.|  
   
 ## See Also  
- [ADOMD.NET Client Programming](https://docs.microsoft.com/bi-reference/adomd/multidimensional-models-adomd-net-client/adomd-net-client-programming)   
+ [ADOMD.NET Client Programming](https://docs.microsoft.com/analysis-services/adomd/multidimensional-models-adomd-net-client/adomd-net-client-programming)   
  [Developing with ADOMD.NET](https://docs.microsoft.com/bi-reference/adomd/developing-with-adomd-net)  
   
   
diff --git a/docs/2014/analysis-services/multidimensional-models/mdx/multidimensional-model-data-access-analysis-services-multidimensional-data.md b/docs/2014/analysis-services/multidimensional-models/mdx/multidimensional-model-data-access-analysis-services-multidimensional-data.md
@@ -83,7 +83,7 @@ manager: craigg
 |Interface|Description|  
 |---------------|-----------------|  
 |Analysis Services Management Objects (AMO)|AMO is the primary object model for administering Analysis Services instances and multidimensional databases in code. For example, SQL Server Management Studio uses AMO to support server and database administration. For more information, see [Developing with Analysis Management Objects &#40;AMO&#41;](https://docs.microsoft.com/bi-reference/amo/developing-with-analysis-management-objects-amo).|  
-|ADOMD.NET|ADOMD.NET is the primary object model creating and accessing multidimensional data in custom applications. You can use ADOMD.NET in a managed client application to retrieve [!INCLUDE[ssASnoversion](../../../includes/ssasnoversion-md.md)] information using common Microsoft .NET Framework data access interfaces. For more information, see [Developing with ADOMD.NET](https://docs.microsoft.com/bi-reference/adomd/developing-with-adomd-net) and [ADOMD.NET Client Programming](https://docs.microsoft.com/bi-reference/adomd/multidimensional-models-adomd-net-client/adomd-net-client-programming).|  
+|ADOMD.NET|ADOMD.NET is the primary object model creating and accessing multidimensional data in custom applications. You can use ADOMD.NET in a managed client application to retrieve [!INCLUDE[ssASnoversion](../../../includes/ssasnoversion-md.md)] information using common Microsoft .NET Framework data access interfaces. For more information, see [Developing with ADOMD.NET](https://docs.microsoft.com/bi-reference/adomd/developing-with-adomd-net) and [ADOMD.NET Client Programming](https://docs.microsoft.com/analysis-services/adomd/multidimensional-models-adomd-net-client/adomd-net-client-programming).|  
 |Analysis Services OLE DB Provider (MSOLAP.dll)|You can use the native OLE DB provider to access [!INCLUDE[ssASnoversion](../../../includes/ssasnoversion-md.md)] programmatically from a non-managed API. For more information, see [Analysis Services OLE DB Provider &#40;Analysis Services - Multidimensional Data&#41;](../../dev-guide/analysis-services-ole-db-provider-analysis-services-multidimensional-data.md).|  
 |Schema Rowsets|Schema rowset tables are data structures that contain descriptive information about a multidimensional model that is deployed on the server, as well as information about current activity on the server. As a programmer, you can query schema rowset tables in client applications to examine metadata stored on, and retrieve support and monitoring information from, an [!INCLUDE[ssASnoversion](../../../includes/ssasnoversion-md.md)] instance. You can use schema rowsets with these programmatic interfaces: OLE DB, OLE DB for Analysis Services, OLE DB for Data Mining, or XMLA. For more information, see [Analysis Services Schema Rowsets](https://docs.microsoft.com/bi-reference/schema-rowsets/analysis-services-schema-rowsets).<br /><br /> The following list explains several approaches for using schema rowsets:<br /><br /> Run DMV queries in SQL Server Management Studio or in custom reports to access schema rowsets using SQL syntax. For more information, see [Use Dynamic Management Views &#40;DMVs&#41; to Monitor Analysis Services](../../instances/use-dynamic-management-views-dmvs-to-monitor-analysis-services.md).<br /><br /> Write ADOMD.NET code that calls a schema rowset.<br /><br /> Run the XMLA `Discover` method directly against an [!INCLUDE[ssASnoversion](../../../includes/ssasnoversion-md.md)] instance to retrieve schema rowset information. For more information, see [Discover Method &#40;XMLA&#41;](https://docs.microsoft.com/bi-reference/xmla/xml-elements-methods-discover).|  
 |XMLA|XMLA is the lowest level API available to an Analysis Services programmer, and is the common denominator that underlies all Analysis Services data access methodologies. XMLA is an industry standard, SOAP based XML protocol that supports universal data access to any standard multidimensional data source available over an HTTP connection. It uses SOAP to formulate requests and responses for multidimensional data. If your application runs on a non-Windows platform, you can use XMLA to access a multidimensional database that is running on a Windows server on your network. For more information, see [Developing with XMLA in Analysis Services](../../multidimensional-models-scripting-language-assl-xmla/developing-with-xmla-in-analysis-services.md).|  
diff --git a/docs/2014/database-engine/install-windows/upgrade-sql-server.md b/docs/2014/database-engine/install-windows/upgrade-sql-server.md
@@ -52,8 +52,8 @@ manager: craigg
  [Upgrade Integration Services](../../integration-services/install-windows/upgrade-integration-services.md)   
  [Upgrade Replicated Databases](../../database-engine/install-windows/upgrade-replicated-databases.md)   
  [Upgrade Master Data Services](upgrade-master-data-services.md)   
- [SQL Server 2005 Best Practices Analyzer](https://www.microsoft.com/download/details.aspx?id=23864)   
- [SQL Server 2008 R2 Best Practices Analyzer](https://www.microsoft.com/download/details.aspx?id=15289)   
+ [SQL Server 2012 Best Practices Analyzer](https://www.microsoft.com/download/details.aspx?id=29302)   
+ [SQL Server 2008 R2 Best Practices Analyzer](https://www.microsoft.com/download/details.aspx?id=436)   
  [Backward Compatibility](../../../2014/getting-started/backward-compatibility.md)  
   
   
diff --git a/docs/connect/sql-data-developer.md b/docs/connect/sql-data-developer.md
@@ -17,7 +17,7 @@ Use Microsoft's SQL data platform to create data-centric solutions across mobile
 ## SQL Data storage
 * [SQL Server Database Engine](../database-engine/configure-windows/sql-server-database-engine.md): Use the  SQL Server Database Engine to create relational databases for online transaction processing or online analytical processing data. 
 * [SQL Azure](https://docs.microsoft.com/azure/sql-database/): Use  SQL Azure to move your database to the cloud 
-* [SQL Compact](https://www.microsoft.com/download/details.aspx?id=17876): SQL Server Compact to build standalone and occasionally connected applications for mobile devices, desktops, and Web clients.
+* [SQL Compact](https://www.microsoft.com/download/details.aspx?id=30709): SQL Server Compact to build standalone and occasionally connected applications for mobile devices, desktops, and Web clients.
 * [LocalDB](../database-engine/configure-windows/sql-server-2016-express-localdb.md): Use LocalDB during development to write and test Transact-SQL code without having to manage a full server instance of SQL Server.
 
 ## SQL Data tools
diff --git a/docs/database-engine/install-windows/upgrade-sql-server.md b/docs/database-engine/install-windows/upgrade-sql-server.md
@@ -47,7 +47,7 @@ This section contains the following articles:
  [Upgrade Integration Services](../../integration-services/install-windows/upgrade-integration-services.md)   
  [Upgrade Replicated Databases](../../database-engine/install-windows/upgrade-replicated-databases.md)   
  [Upgrade Master Data Services](../../database-engine/install-windows/upgrade-master-data-services.md)   
- [SQL Server 2008 R2 Best Practices Analyzer](https://www.microsoft.com/download/details.aspx?id=15289)   
+ [SQL Server 2008 R2 Best Practices Analyzer](https://www.microsoft.com/download/details.aspx?id=436)   
  [Backward Compatibility](../../database-engine/sql-server-database-engine-backward-compatibility.md)  
   
   
